Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 3796D9F9B09 for ; Tue, 21 Aug 2007 11:57:53 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 31313-05 for ; Tue, 21 Aug 2007 11:57:28 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from gwmta.wicourts.gov (gwmta.wicourts.gov [165.219.244.99]) by postgresql.org (Postfix) with ESMTP id C36D89F9A43 for ; Tue, 21 Aug 2007 11:57:46 -0300 (ADT) Received: from Courts-MTA by gwmta.wicourts.gov with Novell_GroupWise; Tue, 21 Aug 2007 09:57:45 -0500 Message-Id: <46CAB713.EE98.0025.0@wicourts.gov> X-Mailer: Novell GroupWise Internet Agent 7.0.2 Date: Tue, 21 Aug 2007 09:57:39 -0500 From: "Kevin Grittner" To: ,"smiley2211" Subject: Re: Dump & Load a database??? References: <12256258.post@talk.nabble.com> In-Reply-To: <12256258.post@talk.nabble.com> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/251 X-Sequence-Number: 26582 >>> On Tue, Aug 21, 2007 at 9:50 AM, in message <12256258.post@talk.nabble= .com>, smiley2211 wrote:=20 > Do I have to DROP \ recreate and load the target database (this is what = I > currently do)? is there a way to just do an IN PLACE load like in other > RDBMS environments??? >=20 > pg_dump proddb | gzip > proddb_082107.sql.gz >=20 > gunzip < proddb_082107.sql.gz | psql -d testdb -f - =20 You might want to consider using one or both of these pg_dump options: =20 -c, --clean clean (drop) schema prior to create -C, --create include commands to create database in dump =20