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

From Tom Lane
Subject Re: Proposal for restoring a dump into a database with a different owner
Date
Msg-id 4380.1214856336@sss.pgh.pa.us
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
Bruce Momjian <bruce@momjian.us> writes:
> 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.

We already have REASSIGN OWNED, though that doesn't entirely do the job
because it doesn't worry about reassigning grants.  Reassigning grants
seems like a big headache for the --map-users proposal too.

            regards, tom lane

pgsql-admin by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: Proposal for restoring a dump into a database with a different owner
Next
From: "Rafael Domiciano"
Date:
Subject: Re: Configuring Shared Buffers