Subject: Re: postgresql 8.0 advantages
From: Jeff Davis <jdavis-pgsql@empires.org>
To: schen@graciousstyle.com
Cc: PgSQL General List <pgsql-general@postgresql.org>
In-Reply-To: <421F5E5D.1010902@graciousstyle.com>
References: <421F3926.6090201@graciousstyle.com>
	<5708.1109348115@sss.pgh.pa.us>  <421F5E5D.1010902@graciousstyle.com>
Content-Type: text/plain
Date: Sat, 26 Feb 2005 01:27:55 -0800
Message-Id: <1109410075.4089.216.camel@jeff>
Mime-Version: 1.0
Content-Transfer-Encoding: 7bit

On Fri, 2005-02-25 at 09:20 -0800, Si Chen wrote:
> Thanks!
> 
> Is there any documentation on how to upgrade to 8.0?
> 
> Is it possible to upgrade from 7.4 to 8.0 while keeping a production 
> database running "in place"?  Or should I install 8.0 in another 
> directory/machine and then restore the database into it?  Are there any 
> incompatibilities/modifications to databases from the earlier veresion 
> required?
> 

You might want to check out Slony-I <http://www.slony.info> for the
purpose of upgrading. Slony is actually a replication engine, but it can
be used to upgrade with little or no downtime. Otherwise, just
dump/upgrade/restore like normal.

As far as compatibility, 8.0 should be mostly backwards compatible.
There may be some minor things that I don't know about, so I recommend
some testing first.

Regards,
	Jeff Davis