"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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
