Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id E6D10650EB7 for ; Mon, 30 Jun 2008 17:05:54 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 23968-04 for ; Mon, 30 Jun 2008 17:05:36 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 305AC650DBC for ; Mon, 30 Jun 2008 17:05:39 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m5UK5a7U004381; Mon, 30 Jun 2008 16:05:36 -0400 (EDT) To: Bruce Momjian cc: postgresql.20.j_random_hacker@spamgourmet.com, pgsql-admin@postgresql.org Subject: Re: Proposal for restoring a dump into a database with a different owner In-reply-to: <200806301950.m5UJo6p03894@momjian.us> References: <200806301950.m5UJo6p03894@momjian.us> Comments: In-reply-to Bruce Momjian message dated "Mon, 30 Jun 2008 15:50:06 -0400" Date: Mon, 30 Jun 2008 16:05:36 -0400 Message-ID: <4380.1214856336@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200806/257 X-Sequence-Number: 29595 Bruce Momjian 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