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

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 (view raw or flat)
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

pgsql-admin by date

Next:From: Rafael DomicianoDate: 2008-06-30 23:16:02
Subject: Re: Configuring Shared Buffers
Previous:From: Scott MarloweDate: 2008-06-30 20:01:36
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