Postgres Pro
Downloads
Home   >   mailing lists

Re: Proposal for restoring a dump into a database with a different owner - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: Proposal for restoring a dump into a database with a different owner
Date
Msg-id dcc563d10806301301q1fd902b6qed52671352a41523@mail.gmail.com
Whole thread Raw
In response to Re: Proposal for restoring a dump into a database with a different owner  (Bruce Momjian <bruce@momjian.us>)
List pgsql-admin
Tree view 
On Mon, Jun 30, 2008 at 1:50 PM, Bruce Momjian <bruce@momjian.us> wrote:
>
> I see you didn't get a response this request.  I am thinking it would be
> better to implement some form of massive change ownership option that
> can be done to change ownership after the dump is restored.

Currently the way I do that is to dump with the -O option, and then
restore to the user account I want everything to belong to.

pgsql-admin by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Proposal for restoring a dump into a database with a different owner
Next
From: Tom Lane
Date:
Subject: Re: Proposal for restoring a dump into a database with a different owner