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.
