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
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
pgsql-hackers by date
|Next:||From: mlw||Date: 2003-02-13 15:59:11|
|Subject: Re: location of the configuration files|
|Previous:||From: Tom Lane||Date: 2003-02-13 15:38:42|
|Subject: Re: Brain dump: btree collapsing |
pgsql-interfaces by date
|Next:||From: Neil Conway||Date: 2003-02-13 16:31:28|
|Subject: Re: [HACKERS] postgresql 7.3 versus 7.2|
|Previous:||From: Ulf Rehmann||Date: 2003-02-13 14:14:01|
|Subject: Re: postgresql 7.3 versus 7.2|