Andreas Haumer <andreas@xxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate