It should be noted that users who use Slony can create a subscriber
node running 8.0 that subscribes to a node running 7.4.x and can
transition with only the downtime required for failover.
This obviates the need for a dump/restore.
See <http://slony.info/>.
-tfo
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005
On Jan 26, 2005, at 1:51 PM, Michael Fuhr wrote:
On Wed, Jan 26, 2005 at 12:51:14PM -0600, James Gunzelman wrote:
Will I have to dump and reload all my databases when migrating from
7.4.2 to 8.0?
Yes -- the Release Notes mention it under "Migration to version 8.0":
http://www.postgresql.org/docs/8.0/static/release.html#RELEASE-8-0
Those unfamiliar with doing an upgrade might want to read "If You
Are Upgrading" in the "Installation Instructions" chapter of the
documenation, and "Migration Between Releases" in the "Backup and
Restore" chapter:
http://www.postgresql.org/docs/8.0/static/install-upgrading.html
http://www.postgresql.org/docs/8.0/static/migration.html
(Install or upgrade questions should probably go to pgsql-admin or
pgsql-general instead of pgsql-performance.)
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
