X-Original-To: pgsql-interfaces@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 045CA4758E6 for ; Thu, 13 Feb 2003 10:42:39 -0500 (EST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 07F60474E42 for ; Thu, 13 Feb 2003 10:42:38 -0500 (EST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.6/8.12.6) with ESMTP id h1DFgS5u013484; Thu, 13 Feb 2003 10:42:28 -0500 (EST) To: Robert Treat Cc: Ulf Rehmann , pgsql-hackers@postgresql.org, pgsql-interfaces@postgresql.org Subject: Re: [HACKERS] postgresql 7.3 versus 7.2 In-reply-to: <1045144176.12930.438.camel@camel> References: <1045144176.12930.438.camel@camel> Comments: In-reply-to Robert Treat message dated "13 Feb 2003 08:49:36 -0500" Date: Thu, 13 Feb 2003 10:42:27 -0500 Message-ID: <13483.1045150947@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/44 X-Sequence-Number: 3665 Robert Treat writes: > On Wed, 2003-02-12 at 16:02, Ulf Rehmann wrote: >> Is there any way to adjust dumps from postgresql 7.3 for use by >> version 7.2 and vice versa ? > 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. I think he'll have trouble even with that :-( ... 7.3 pg_dump will try to use column-name-list syntax in its COPY commands, which the 7.2 server won't like. AFAICS the only answer is to run the data dump through a filter (sed or perl or whatever) to edit the COPY commands to a format 7.2 will take. regards, tom lane