From: Jeff Davis <jdavis-pgsql@empires.org>
To: schen@graciousstyle.com
Cc: PgSQL General List <pgsql-general@postgresql.org>
Subject: Re: postgresql 8.0 advantages
Date: Sat, 26 Feb 2005 01:27:55 -0800
Message-ID: <1109410075.4089.216.camel@jeff> (raw)
In-Reply-To: <421F5E5D.1010902@graciousstyle.com>
References: <421F3926.6090201@graciousstyle.com>
<5708.1109348115@sss.pgh.pa.us>
<421F5E5D.1010902@graciousstyle.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: jdavis-pgsql@empires.org, schen@graciousstyle.com, pgsql-general@postgresql.org
Subject: Re: postgresql 8.0 advantages
In-Reply-To: <1109410075.4089.216.camel@jeff>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox