Search Postgresql Archives

restore from a pg_dumpall file

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



** High Priority **

Hello everyone,

I have a restore file created by pg_dumpall.  The restore file has two
users associated with ownership of tables.  The postgres user and a user
called nsadmin.  

When I attempt to restore this it won't create my call_handlers because
it's not the postgres user.  If I attempt to restore under the nsadmin
user the language handlers fail. 

How can I restore this file without changing everything to postgress
user?  

Thanks.

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux