Re: [GENERAL] Restoring the DB from others user DB Backup.

2007-07-13 Thread Jim Nasby
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

[GENERAL] Restoring the DB from others user DB Backup.

2007-07-09 Thread Mavinakuli, Prasanna (STSD)
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