FAQ: upgrade recommendation
Would you use pg_dumpall v7.2 or v7.3 to dump a v7.2 database before loading
it into a v7.3 server?
Does it matter?
(Guess not, just see slight changes like constraints on primary keys being
part of table creation for 7.2, but added at the end for 7.3 - probably for
speed of COPYing)
Cheers,
Patrick
Doesn't really matter. There are few improvements in the 7.3 version,
but nothing dramatic.
---------------------------------------------------------------------------
Patrick Welche wrote:
Would you use pg_dumpall v7.2 or v7.3 to dump a v7.2 database before loading
it into a v7.3 server?Does it matter?
(Guess not, just see slight changes like constraints on primary keys being
part of table creation for 7.2, but added at the end for 7.3 - probably for
speed of COPYing)Cheers,
Patrick
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
On Wed, 25 Sep 2002, Patrick Welche wrote:
Would you use pg_dumpall v7.2 or v7.3 to dump a v7.2 database before loading
it into a v7.3 server?Does it matter?
(Guess not, just see slight changes like constraints on primary keys being
part of table creation for 7.2, but added at the end for 7.3 - probably for
speed of COPYing)
There have been some minor issues that have been cleared up by using the
7.3 pg_dump instead of the 7.2 pg_dump. I don't remember what they all
are, but the archive should list them somewhere.