Re: Restoring the DB from others user DB Backup.

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(at)nasby(dot)net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)