Re: Restore dump into different databases/owners - Mailing list pgsql-admin

From Tom Lane
Subject Re: Restore dump into different databases/owners
Date
Msg-id 9118.1200158125@sss.pgh.pa.us
Whole thread Raw
In response to Re: Restore dump into different databases/owners  (Andreas Haumer <andreas@xss.co.at>)
Responses Re: Restore dump into different databases/owners  (Andreas Haumer <andreas@xss.co.at>)
List pgsql-admin
Andreas Haumer <andreas@xss.co.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

pgsql-admin by date:

Previous
From: Andreas Haumer
Date:
Subject: Re: Restore dump into different databases/owners
Next
From: Tom Lane
Date:
Subject: Re: 8.3 RC1 - Logging and filenames