Re: postgresql 8.0 advantages - Mailing list pgsql-general

From Jim C. Nasby
Subject Re: postgresql 8.0 advantages
Date
Msg-id 20050226213527.GA84483@decibel.org
Whole thread Raw
In response to Re: postgresql 8.0 advantages  (Jeff Davis <jdavis-pgsql@empires.org>)
Responses Re: postgresql 8.0 advantages
List pgsql-general
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?"

pgsql-general by date:

Previous
From: Tatsuo Ishii
Date:
Subject: http://www.postgresql.org/community/lists/
Next
From: Scott Marlowe
Date:
Subject: Re: postgresql 8.0 on windows 2003 server