X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 421843AC444 for ; Wed, 15 Dec 2004 16:44:11 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 04208-10 for ; Wed, 15 Dec 2004 16:44:00 +0000 (GMT) Received: from leda.steelsun.com (dsl093-240-204.ral1.dsl.speakeasy.net [66.93.240.204]) by svr1.postgresql.org (Postfix) with ESMTP id 251A83AC464 for ; Wed, 15 Dec 2004 16:43:59 +0000 (GMT) Received: from leda.steelsun.com (localhost [127.0.0.1]) by leda.steelsun.com (8.12.11/8.12.8) with ESMTP id iBFGhqhl001415 for ; Wed, 15 Dec 2004 11:43:52 -0500 Received: from localhost (cfowler@localhost) by leda.steelsun.com (8.12.11/8.12.11/Submit) with ESMTP id iBFGhq2f001410 for ; Wed, 15 Dec 2004 11:43:52 -0500 X-Authentication-Warning: leda.steelsun.com: cfowler owned process doing -bs Date: Wed, 15 Dec 2004 11:43:52 -0500 (EST) From: Christian Fowler X-X-Sender: cfowler@leda.steelsun.com To: pgsql-admin list Subject: Re: upgrading postgresql In-Reply-To: <1103127600.22049.40.camel@state.g2switchworks.com> Message-ID: References: <41C00963.7090904@mail.jct.ac.il> <1103127600.22049.40.camel@state.g2switchworks.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200412/145 X-Sequence-Number: 15731 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