Thread: 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.