#> pg_dump -f noOwner.dmp -O -x -h localhost -U user1 dbname1
#> psql -h localhost -U user2 -d dbname2 < noOwner.dmp
Postgresql: backUp from one user/owner and restore into another user/owner
June 14, 2010 by campa
June 14, 2010 by campa
#> pg_dump -f noOwner.dmp -O -x -h localhost -U user1 dbname1
#> psql -h localhost -U user2 -d dbname2 < noOwner.dmp
[...] http://campa.wordpress.com/2010/06/14/postgresql-backup-from-one-userowner-and-restore-into-another-… [...]