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
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 |
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 |