Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] postgresql 7.3 versus 7.2

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
Cc: Ulf Rehmann <rehmann(at)mathematik(dot)uni-bielefeld(dot)de>,pgsql-hackers(at)postgresql(dot)org, pgsql-interfaces(at)postgresql(dot)org
Subject: Re: [HACKERS] postgresql 7.3 versus 7.2
Date: 2003-02-13 15:42:27
Message-ID: 13483.1045150947@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-interfaces
Robert Treat <xzilla(at)users(dot)sourceforge(dot)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

In response to

Responses

pgsql-hackers by date

Next:From: mlwDate: 2003-02-13 15:59:11
Subject: Re: location of the configuration files
Previous:From: Tom LaneDate: 2003-02-13 15:38:42
Subject: Re: Brain dump: btree collapsing

pgsql-interfaces by date

Next:From: Neil ConwayDate: 2003-02-13 16:31:28
Subject: Re: [HACKERS] postgresql 7.3 versus 7.2
Previous:From: Ulf RehmannDate: 2003-02-13 14:14:01
Subject: Re: postgresql 7.3 versus 7.2

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group