"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
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
In response to
pgsql-general by date
|Next:||From: Marcos Iuato||Date: 2004-05-25 16:42:24|
|Subject: Iterating over an varchar array?|
|Previous:||From: Tom Lane||Date: 2004-05-25 15:05:50|
|Subject: Re: FW: Majordomo results: subscribe pgsql-general |