Date: Sat, 26 Feb 2005 15:35:27 -0600
From: "Jim C. Nasby" <decibel@decibel.org>
To: Jeff Davis <jdavis-pgsql@empires.org>
Cc: schen@graciousstyle.com, PgSQL General List <pgsql-general@postgresql.org>
Subject: Re: postgresql 8.0 advantages
Message-ID: <20050226213527.GA84483@decibel.org>
References: <421F3926.6090201@graciousstyle.com>
	<5708.1109348115@sss.pgh.pa.us>
	<421F5E5D.1010902@graciousstyle.com>
	<1109410075.4089.216.camel@jeff>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <1109410075.4089.216.camel@jeff>
User-Agent: Mutt/1.5.6i

On Sat, Feb 26, 2005 at 01:27:55AM -0800, Jeff Davis wrote:
> 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.

Has anyone tried moving a database from one location to another on the
HD? I'd like to use slony to minimize downtime, but I'd also like my
data to end up in the same place it is right now when I'm done.
-- 
Jim C. Nasby, Database Consultant               decibel@decibel.org 
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"