Skip site navigation (1) Skip section navigation (2)

Re: Proposal for restoring a dump into a database with a different owner

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Bruce Momjian" <bruce(at)momjian(dot)us>
Cc: postgresql(dot)20(dot)j_random_hacker(at)spamgourmet(dot)com, pgsql-admin(at)postgresql(dot)org
Subject: Re: Proposal for restoring a dump into a database with a different owner
Date: 2008-06-30 20:01:36
Message-ID: dcc563d10806301301q1fd902b6qed52671352a41523@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Mon, Jun 30, 2008 at 1:50 PM, Bruce Momjian <bruce(at)momjian(dot)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.

In response to

pgsql-admin by date

Next:From: Tom LaneDate: 2008-06-30 20:05:36
Subject: Re: Proposal for restoring a dump into a database with a different owner
Previous:From: Bruce MomjianDate: 2008-06-30 19:50:06
Subject: Re: Proposal for restoring a dump into a database with a different owner

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group