Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 0525B64FCBA for ; Wed, 27 Aug 2008 11:34:14 -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 26851-03 for ; Wed, 27 Aug 2008 11:34:01 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mx00.pub.collaborativefusion.com (mx00.pub.collaborativefusion.com [206.210.89.199]) by postgresql.org (Postfix) with ESMTP id DA9F564FCDA for ; Wed, 27 Aug 2008 11:34:07 -0300 (ADT) Received: from vanquish.ws.pitbpa0.priv.collaborativefusion.com (vanquish.ws.pitbpa0.priv.collaborativefusion.com [192.168.2.162]) (SSL: TLSv1/SSLv3,256bits,AES256-SHA) by wingspan with esmtp; Wed, 27 Aug 2008 10:34:06 -0400 id 00056405.0000000048B565DE.000125B2 Date: Wed, 27 Aug 2008 10:34:29 -0400 From: Bill Moran To: "Phoenix Kiula" Cc: "PG-General Mailing List" Subject: Re: Dumping/Restoring with constraints? Message-Id: <20080827103429.081e93a1.wmoran@collaborativefusion.com> In-Reply-To: References: <22708.1219845242@sss.pgh.pa.us> <20080827102403.dc69c802.wmoran@collaborativefusion.com> Organization: Collaborative Fusion X-Mailer: Sylpheed 2.5.0 (GTK+ 2.12.11; i386-portbld-freebsd7.0) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200808/950 X-Sequence-Number: 136780 In response to "Phoenix Kiula" : > Thanks Bill for this recommendation: > > > > *) In the early step dump the data only with pg_dumpall --disable-triggers -a > > > Dumb question. Will this kind of pg_dumpall lead to downtime, I mean > is there a database lock during this time? No. -- Bill Moran Collaborative Fusion Inc. http://people.collaborativefusion.com/~wmoran/ wmoran@collaborativefusion.com Phone: 412-422-3463x4023