X-Original-To: pgsql-interfaces@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 185FB4759BD; Thu, 13 Feb 2003 08:49:48 -0500 (EST) Received: from localhost.localdomain (unknown [65.217.53.66]) by postgresql.org (Postfix) with ESMTP id 6CF044759AF; Thu, 13 Feb 2003 08:49:47 -0500 (EST) Received: from thorn.mmrd.com (thorn.mmrd.com [172.25.10.100]) by localhost.localdomain (8.12.5/8.12.5) with ESMTP id h1DEF76P011176; Thu, 13 Feb 2003 09:15:07 -0500 Received: from gnvex001.mmrd.com (gnvex001.mmrd.com [192.168.3.55]) by thorn.mmrd.com (8.11.6/8.11.6) with ESMTP id h1DDnbj08999; Thu, 13 Feb 2003 08:49:38 -0500 Received: from camel.mmrd.com ([172.25.5.213]) by gnvex001.mmrd.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2653.13) id CWVL1142; Thu, 13 Feb 2003 08:49:34 -0500 Subject: Re: postgresql 7.3 versus 7.2 From: Robert Treat To: Ulf Rehmann Cc: pgsql-hackers@postgresql.org, pgsql-interfaces@postgresql.org In-Reply-To: References: Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.0.8 Date: 13 Feb 2003 08:49:36 -0500 Message-Id: <1045144176.12930.438.camel@camel> Mime-Version: 1.0 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/52 X-Sequence-Number: 3673 On Wed, 2003-02-12 at 16:02, Ulf Rehmann wrote: > > Hi! > > Is there any way to adjust dumps from postgresql 7.3 for use by > version 7.2 and vice versa ? > > Or is there a way to transport a full database via csv or in any other > kind to 7.2 and vice versa ? > > We are running a couple of servers/mirrors at various locations in the > world, handling data based on postgresql, and now we have trouble to > transport data from and to sites with different versions. > Create a schema only dump with the 7.2 pg_dump. Create a data only dump (possibly with INSERT output) with the 7.3 pg_dump. Assuming you haven't done anything too wacky, you should be able to drop your 7.2 database, reload the 7.2 schema, then load up the 7.3 data. As always, test this out before doing it on a production system. Robert Treat