Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 34FCE95164A for ; Mon, 7 Nov 2011 13:17:07 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 61740-03 for ; Mon, 7 Nov 2011 17:16:55 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.8.0-rc2 Received: from gw.wicourts.gov (gwmta.wicourts.gov [165.219.244.99]) by mail.postgresql.org (Postfix) with ESMTP id 9937595164B for ; Mon, 7 Nov 2011 13:16:21 -0400 (AST) Received: from Courts-MTA by gw.wicourts.gov with Novell_GroupWise; Mon, 07 Nov 2011 11:16:17 -0600 Message-Id: <4EB7BDF60200002500042B06@gw.wicourts.gov> X-Mailer: Novell GroupWise Internet Agent 8.0.1 Date: Mon, 07 Nov 2011 11:16:06 -0600 From: "Kevin Grittner" To: "Kieren Scott" , Subject: Re: pg_dump from 8.4 to 8.3 References: In-Reply-To: Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-3.101 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RP_MATCHES_RCVD=-1.201 X-Spam-Level: X-Archive-Number: 201111/16 X-Sequence-Number: 38610 Kieren Scott wrote: > I need to migrate some data (a few GB's) from an 8.4 database to > an 8.3 database using pg_dump. What is the best way to acheive > this? This is always a little tricky because you may have objects in your later-release database which can't be represented in the older release. My inclination would be to dump with the later release and hand-modify the file for each error you run into, until you get a clean restore. Be sure you have an editor which doesn't need to load the whole file into RAM at one time, if the database is large. Of course, an even easier route is generally to avoid moving backward. -Kevin