Thread: 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)