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