From: Christian Fowler <spider@viovio.com>
To: pgsql-admin list <pgsql-admin@postgresql.org>
Subject: Re: upgrading postgresql
Date: Wed, 15 Dec 2004 11:43:52 -0500 (EST)
Message-ID: <Pine.LNX.4.61.0412151131040.686@leda.steelsun.com> (raw)
In-Reply-To: <1103127600.22049.40.camel@state.g2switchworks.com>
References: <41C00963.7090904@mail.jct.ac.il>
<1103127600.22049.40.camel@state.g2switchworks.com>
2 bits of wisdom:
1. As mentioned below, always try this upgrade on a test/ offline/
sandbox/ development/ testing /etc server first
> -- Clean out the $PGDATA directory (keep a copy of your pg_hba.conf and
> postgresql.conf for reference)
2. A simple 'mv data/ data73/' after pg shutdown keeps your 7.3 DB around
incase something goes terribly wrong (i have had some dumps that would
*not* re-import themselves due to illegal characters). If you need to get
back online asap, just slip the 7.3 rpms back in, and 'mv data73 data'
> I'd recommend a test run of the major upgrade procedures you're planning
> on doing on a backup machine in case you run into some problems. Use of
> a replication engine, like Slony as well as pgpool can allow you to
> seamlessly upgrade your installation while it stays online. I'd
> practice this too on a backup system before going after the live
> servers.
[ \ /
[ >X< Christian Fowler | spider AT viovio.com
[ / \ http://www.viovio.com | http://www.tikipro.org
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: spider@viovio.com
Subject: Re: upgrading postgresql
In-Reply-To: <Pine.LNX.4.61.0412151131040.686@leda.steelsun.com>
References: <41C00963.7090904@mail.jct.ac.il> <1103127600.22049.40.camel@state.g2switchworks.com> <Pine.LNX.4.61.0412151131040.686@leda.steelsun.com>
* 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