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

Re: postgresql 7.3 versus 7.2

From: Ulf Rehmann <rehmann(at)mathematik(dot)uni-bielefeld(dot)de>
To: xzilla(at)users(dot)sourceforge(dot)net
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 14:14:01
Message-ID: E18jK7l-0002jC-00@ada (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-interfaces
 | 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.
 | 

Thanks a lot for this quick explanation, this is very helpful!
By the way, is there a possibility to just do incremental
dumps/restores? Say, since a given date?

Ulf





In response to

pgsql-hackers by date

Next:From: Curt SampsonDate: 2003-02-13 14:18:00
Subject: Re: location of the configuration files
Previous:From: Dave PageDate: 2003-02-13 14:10:49
Subject: Re: location of the configuration files

pgsql-interfaces by date

Next:From: Tom LaneDate: 2003-02-13 15:42:27
Subject: Re: [HACKERS] postgresql 7.3 versus 7.2
Previous:From: Robert TreatDate: 2003-02-13 13:49:36
Subject: Re: postgresql 7.3 versus 7.2

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