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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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:05:36
Message-ID: 4380.1214856336@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Bruce Momjian <bruce(at)momjian(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Rafael Domiciano 2008-06-30 23:16:02 Re: Configuring Shared Buffers
Previous Message Scott Marlowe 2008-06-30 20:01:36 Re: Proposal for restoring a dump into a database with a different owner