[PERFORM] Upgrading from from 7.4.2 to 8.0
Title: Message Will I have to dump and reload all my databases when migrating from 7.4.2 to 8.0? Jim Gunzelman Senior Software Engineer phone: 402.361.3078 fax: 402.361.3178 e-mail: JamesGunzelman[EMAIL PROTECTED] Solutionary, Inc. www.Solutionary.com Making Security Manageable 24x7 _ Confidentiality Notice The content of this communication, along with any attachments, is covered by federal and state law governing electronic communications and may contain confidential and legally privileged information. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, use or copying of the information contained herein is strictly prohibited. If you have received this communication in error, please immediately contact us by telephone at (402) 361-3000 or e-mail [EMAIL PROTECTED] Thank you. Copyright 2000-2005, Solutionary, Inc. All rights reserved. ActiveGuard, eV3, Solutionary and the Solutionary logo are registered trademarks of Solutionary, Inc.
Re: [PERFORM] Upgrading from from 7.4.2 to 8.0
James Gunzelman [EMAIL PROTECTED] writes: Will I have to dump and reload all my databases when migrating from 7.4.2 to 8.0? Yes. -Doug ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [PERFORM] Upgrading from from 7.4.2 to 8.0
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 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [PERFORM] Upgrading from from 7.4.2 to 8.0
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