Postgresql - backup database and restore on different owner? -


i did backup on database on different server , has different role need, command:

pg_dump -fc db_name -f db_name.dump 

then copied backup server need restore database, there no such owner used database. let database has owner owner1, on different server have owner2 , need restore database , change owner.

what did on server when restoring:

createdb -p 5433 -t template0 db_name  pg_restore -p 5433 --role=owner2 -d db_name db_name.dump 

but when restore run these errors:

pg_restore: [archiver (db)] not execute query: error:  role "owner1" not exist 

how can specify change owner? or impossible?

you should use --no-owner option, stops pg_restore trying set ownership of objects original owner. instead objects owned user specified --role

createdb -p 5433 -t template0 db_name  pg_restore -p 5433 --no-owner --role=owner2 -d db_name db_name.dump 

pg_restore doc


Comments