"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