Re: restore from a pg_dumpall file

"Bob Powell" <Bob@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