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/