pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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





view thread (6+ messages)  latest in thread

Message-ID: <Pine.LNX.4.61.0412151131040.686@leda.steelsun.com>
Permalink:  ../Pine.LNX.4.61.0412151131040.686@leda.steelsun.com/
Also on:    postgresql.org/message-id/Pine.LNX.4.61.0412151131040.686@leda.steelsun.com

 · 

reply

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