467,858 Members | 1,699 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,858 developers. It's quick & easy.

restore from a pg_dumpall file

** 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 ma*******@postgresql.org

Nov 23 '05 #1
  • viewed: 4602
Share:
1 Reply
"Bob Powell" <Bo*@hotchkiss.org> writes:
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?


You pretty much always have to start the restore of a pg_dumpall file
as superuser. That does not mean it will create everything as owned by
the superuser, but it needs superuser permissions.

regards, tom lane

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

Nov 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Edwin Quijada | last post: by
9 posts views Thread by GL | last post: by
2 posts views Thread by Mike Nolan | last post: by
8 posts views Thread by Carter Harrison | last post: by
reply views Thread by Josué Maldonado | last post: by
reply views Thread by jack112 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.