Skip site navigation (1) Skip section navigation (2)

Re: Upgrading from from 7.4.2 to 8.0

From: Thomas F(dot)O'Connell <tfo(at)sitening(dot)com>
To: Michael Fuhr <mike(at)fuhr(dot)org>
Cc: pgsql-performance(at)postgresql(dot)org,James Gunzelman <JamesGunzelman(at)solutionary(dot)com>
Subject: Re: Upgrading from from 7.4.2 to 8.0
Date: 2005-01-26 20:14:35
Message-ID: 9a5a0440c005682cf2963293f6fc779d@sitening.com (view raw or flat)
Thread:
Lists: pgsql-performance
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/


In response to

pgsql-performance by date

Next:From: PFCDate: 2005-01-26 21:10:19
Subject: Re: 200 times slower then MSSQL??
Previous:From: PFCDate: 2005-01-26 20:02:42
Subject: Re: poor performance of db?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group