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