Andreas Haumer <andreas(at)xss(dot)co(dot)at> writes:
> I now solved it by temporarily adding the "superuser" privilege
> to the roles in question.
That should not be necessary, unless the dump contained objects that
require superuser permission to create (such as C-language functions)
--- in which case giving ownership of them to a non-superuser account
seems a bit unwise anyway.
Exactly what problems did you have using "-O -U user" ?
regards, tom lane
In response to
pgsql-admin by date
|Next:||From: Tom Lane||Date: 2008-01-12 17:21:43|
|Subject: Re: 8.3 RC1 - Logging and filenames |
|Previous:||From: Andreas Haumer||Date: 2008-01-12 16:25:45|
|Subject: Re: Restore dump into different databases/owners|