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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-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

Browse pgsql-hackers by date

  From Date Subject
Next Message Curt Sampson 2003-02-13 14:18:00 Re: location of the configuration files
Previous Message Dave Page 2003-02-13 14:10:49 Re: location of the configuration files

Browse pgsql-interfaces by date

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