Monday, June 30, 2008

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

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

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

No comments: