Re: restore from a pg_dumpall file

"Bob Powell" <Bob(at)hotchkiss(dot)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