From: Phillip Smith <fukawi2@iinet.net.au>
To: pgsql-admin@postgresql.org
Subject: Re: How do you upgrade for production servers?
Date: Sat, 30 Dec 2006 00:02:26 +1100
Message-ID: <200612300002.26510.fukawi2@iinet.net.au> (raw)
I install the new version to a new directory (eg, /usr/local/pg-8.2 ) then
start that server on a different port to the live server (eg, 54321), create
a new data directory (eg. /home/postgres/pgData-8.2) dump the live database,
import to the new database to make sure it's all good, then once I know
that's all good, I'll drop the live database back to "single user mode" using
pg_hba.conf, dump the database again, shutdown the old version, restart the
new version on the normal port, re-import the data then re-enable normal
access with pg_hba.conf
I have the advantage that our database generally isn't accessed out of
hours, so I have the luxury to be able to have the server offline for 30 -
60 minutes while the second dump and import is happening. Depends how big
your database is as to how long the server will be unavailable.
At least by installing the new version to a new directory and doing a test
import first lets me see how (if) the new version will affect the data
without having the live server offline.
Cheers,
-p
On Friday 29 December 2006 23:06, Arnau wrote:
> Hi all,
>
> This is a general question about which procedure you follow when you
> upgrade your productions servers. Let's say we have a server running and
> older version and I want to install the latest version on the same
> server. Do you install slony? do you dump all the databases, install the
> latest version and after you restore? any other procedure? I'd like to
> have my production server down as less time as possible.
>
>
> Thank you very much and have a great new year :D
-------------------------------------------------------
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: fukawi2@iinet.net.au
Subject: Re: How do you upgrade for production servers?
In-Reply-To: <200612300002.26510.fukawi2@iinet.net.au>
References: <200612300002.26510.fukawi2@iinet.net.au>
* 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