Restoring the DB from others user DB Backup.

From: "Mavinakuli, Prasanna (STSD)" <prasanna(dot)b-m(at)hp(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Cc: "Mavinakuli, Prasanna (STSD)" <prasanna(dot)b-m(at)hp(dot)com>
Subject: Restoring the DB from others user DB Backup.
Date: 2007-07-04 10:22:08
Message-ID: FFE5D42C74BFBE48A79FA506C15E1E7C068061BA@bgeexc04.asiapacific.cpqcorp.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2007-07-04 12:43:15 Re: how to covert a column?
Previous Message Joshua N Pritikin 2007-07-04 09:20:28 tsearch2 in multilingual database?