From: Ulf Rehmann <rehmann@mathematik.uni-bielefeld.de>
To: xzilla@users.sourceforge.net
Cc: pgsql-hackers@postgresql.org
Cc: pgsql-interfaces@postgresql.org
Subject: Re: postgresql 7.3 versus 7.2
Date: Thu, 13 Feb 2003 15:14:01 +0100
Message-ID: <E18jK7l-0002jC-00@ada> (raw)
In-Reply-To: <1045144176.12930.438.camel@camel>
References: <E18j41S-0001fZ-00@ada>
<1045144176.12930.438.camel@camel>
| 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: rehmann@mathematik.uni-bielefeld.de, xzilla@users.sourceforge.net, pgsql-hackers@postgresql.org
Subject: Re: postgresql 7.3 versus 7.2
In-Reply-To: <E18jK7l-0002jC-00@ada>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox