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
Comments
Post a Comment