Restoring the DB from others user DB Backup.
Hello,
We have 2 altogether databases owned by two different users.The
requirement is ,by using a back up dump of a database owned by some
other user,We will need to restore the other DB which is owned
completely by other user.
The problem what we are facing is,if we try to use pg_restore
command,then it cribbs saying the user doesn't exist.So could you please
direct me for a way to achieve this.Unfortunately I have to use
postgreSQL 7.4.2 version where there is no support for -O option.
Thanks a lot for all your support,
Prasanna.
On Jul 4, 2007, at 5:22 AM, Mavinakuli, Prasanna (STSD) wrote:
We have 2 altogether databases owned by two different users.The
requirement is ,by using a back up dump of a database owned by some
other user,We will need to restore the other DB which is owned
completely by other user.The problem what we are facing is,if we try to use pg_restore
command,then it cribbs saying the user doesn't exist.So could you
please
direct me for a way to achieve this.Unfortunately I have to use
postgreSQL 7.4.2 version where there is no support for -O option.
pg_restore will just send SQL commands to STDOUT if you don't give it
a database to connect to. You can then use something like 'grep -v'
to strip out all the ownership commands for the affected user.
--
Jim Nasby jim@nasby.net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)