Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id F1499650F5E for ; Mon, 30 Jun 2008 17:02:56 -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 20133-01-9 for ; Mon, 30 Jun 2008 17:02:50 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.182]) by postgresql.org (Postfix) with ESMTP id 49D48650F13 for ; Mon, 30 Jun 2008 17:01:38 -0300 (ADT) Received: by py-out-1112.google.com with SMTP id d37so426836pye.29 for ; Mon, 30 Jun 2008 13:01:37 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:cc:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references; bh=CA9mT4/csx+a8PmpqAYhQVIrSesqD6fHxb1XoKVRFg4=; b=kxCoQlYgFj42XqluscIKoRGOH4AI1smahv/KsK5/1NhypBKjbift3oLz6bneaiBero 1ffcF4f25iNJj9A2qa3kCS/nxUFZ0fobS6GvgM2SYnzaniV8zvEozKOCbEjUofeWui5T wHGz7q9PyQteXkJGmQksBDXEvTDSmdOjKhWoY= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=f2IEhvDCPWdozcYTACwnezpLzh9aT22E9c4BJWGhlMVCqx1WFAkjAEoqSv+of1EeLo R3iCYTyB65lM9+wyoxVncE4ulyumm391l+rwLkD7/05UG6gm0y98qR9kFQDyl+IkVupJ 8Uai2R1ZSFFa45x1dx4CBLG8EdvUiIlVKEZhI= Received: by 10.114.176.1 with SMTP id y1mr4723348wae.118.1214856096563; Mon, 30 Jun 2008 13:01:36 -0700 (PDT) Received: by 10.114.180.17 with HTTP; Mon, 30 Jun 2008 13:01:36 -0700 (PDT) Message-ID: Date: Mon, 30 Jun 2008 14:01:36 -0600 From: "Scott Marlowe" To: "Bruce Momjian" Subject: Re: Proposal for restoring a dump into a database with a different owner Cc: postgresql.20.j_random_hacker@spamgourmet.com, pgsql-admin@postgresql.org In-Reply-To: <200806301950.m5UJo6p03894@momjian.us> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <000301c8b28a$d8d15e90$959c7b82@massey.ac.nz> <200806301950.m5UJo6p03894@momjian.us> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200806/256 X-Sequence-Number: 29594 On Mon, Jun 30, 2008 at 1:50 PM, Bruce Momjian wrote: > > 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. Currently the way I do that is to dump with the -O option, and then restore to the user account I want everything to belong to.