Re: [HACKERS] [INTERFACES] postgresql 7.3 versus 7.2

2003-02-13 Thread .
> 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 d

Re: [HACKERS] [INTERFACES] postgresql 7.3 versus 7.2

2003-02-13 Thread Ulf Rehmann
| 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

Re: [HACKERS] [INTERFACES] postgresql 7.3 versus 7.2

2003-02-13 Thread Neil Conway
On Thu, 2003-02-13 at 10:42, Tom Lane wrote: > 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. If you used an insert-only, data-only dump, that might work... Cheers, Neil -- Neil Con

Re: [HACKERS] [INTERFACES] postgresql 7.3 versus 7.2

2003-02-13 Thread Tom Lane
Robert Treat <[EMAIL PROTECTED]> 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) w

Re: [HACKERS] [INTERFACES] postgresql 7.3 versus 7.2

2003-02-13 Thread Robert Treat
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 ser