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

Re: postgresql 7.3 versus 7.2

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: Ulf Rehmann <rehmann(at)mathematik(dot)uni-bielefeld(dot)de>
Cc: pgsql-hackers(at)postgresql(dot)org, pgsql-interfaces(at)postgresql(dot)org
Subject: Re: postgresql 7.3 versus 7.2
Date: 2003-02-13 13:49:36
Message-ID: 1045144176.12930.438.camel@camel (view raw, whole thread or download thread mbox)
Lists: pgsql-hackerspgsql-interfaces
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 servers/mirrors at various locations in the
> world, handling data based on postgresql, and now we have trouble to
> transport data from and to sites with different versions.

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

Robert Treat

In response to


pgsql-hackers by date

Next:From: Dave PageDate: 2003-02-13 14:10:49
Subject: Re: location of the configuration files
Previous:From: Christopher BrowneDate: 2003-02-13 13:32:51
Subject: Re: location of the configuration files

pgsql-interfaces by date

Next:From: Ulf RehmannDate: 2003-02-13 14:14:01
Subject: Re: postgresql 7.3 versus 7.2
Previous:From: Michael UmanDate: 2003-02-13 08:57:12
Subject: LIBPQXX on Windows

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