From: Tom Lane <tgl@sss.pgh.pa.us>
To: Robert Treat <xzilla@users.sourceforge.net>
Cc: Ulf Rehmann <rehmann@mathematik.uni-bielefeld.de>
Cc: pgsql-hackers@postgresql.org
Cc: pgsql-interfaces@postgresql.org
Subject: Re: [HACKERS] postgresql 7.3 versus 7.2
Date: Thu, 13 Feb 2003 10:42:27 -0500
Message-ID: <13483.1045150947@sss.pgh.pa.us> (raw)
In-Reply-To: <1045144176.12930.438.camel@camel>
References: <E18j41S-0001fZ-00@ada>
<1045144176.12930.438.camel@camel>
Robert Treat <xzilla@users.sourceforge.net> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: tgl@sss.pgh.pa.us, xzilla@users.sourceforge.net, rehmann@mathematik.uni-bielefeld.de, pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] postgresql 7.3 versus 7.2
In-Reply-To: <13483.1045150947@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox