Naomi Walker wrote: > We are currently using Postgresql 7.1.2, running on a E3500 server, OS > Solaris 2.6. We would like to upgrade to postgresql 7.2. > > 1) Do you all consider it stable enough now to upgrade? > > 2) If I understand correctly, to upgrade, step would be: > > a) pg_dumpall > b) reset PGHOME to new version of postgresql > c) pg_restore > > Is this correct? > > If so, that seems pretty drastic. I cannot imagine that once our databases > start getting really huge that this will last as an upgrade method. I > thought we would be using pg_upgrade, but I see a note that it will not > work with versions of postgres 7.1 and higher. > > Why did pg_upgrade go away, and can we look forward to one in the future?
It is in /contrib/pg_upgrade now and it does work for 7.1 upgrades, though it is only lightly tested. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])