Re: postgresql 8.0 advantages - Mailing list pgsql-general

From Jeff Davis
Subject Re: postgresql 8.0 advantages
Date
Msg-id 1109410075.4089.216.camel@jeff
Whole thread Raw
In response to Re: postgresql 8.0 advantages  (Si Chen <schen@graciousstyle.com>)
Responses Re: postgresql 8.0 advantages  ("Jim C. Nasby" <decibel@decibel.org>)
List pgsql-general
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



pgsql-general by date:

Previous
From: Jeff Davis
Date:
Subject: Re: row numbering
Next
From: Benjamin
Date:
Subject: Re: db replication and errors