From: Scott Marlowe <scott.marlowe@gmail.com>
To: Swathi S <ss.postgres@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Ideal way to upgrade to postgres 8.3 with less downtime
Date: Tue, 11 Nov 2008 12:12:55 -0700
Message-ID: <dcc563d10811111112m516209daq48be34c77dce2d07@mail.gmail.com> (raw)
In-Reply-To: <6c1264780811062204t260f7c4eo20675bc8d2b0bb6b@mail.gmail.com>
References: <6c1264780811062204t260f7c4eo20675bc8d2b0bb6b@mail.gmail.com>
On Thu, Nov 6, 2008 at 11:04 PM, Swathi S <ss.postgres@gmail.com> wrote:
> Hi,
>
> I have a database of size approx 400G. It's a 24/7 database. Only few tables
> have regular reads and writes. The other tables just store information.
>
> I would like to upgrade to 8.3 and would like to know the best way to
> upgrade with less downtime.
Assuming you're running 8.0 or higher now, slony should provide you
with a one stop upgrade path with the minimum amount of downtime. We
use it for our database which is smaller (~20 Gigs) but quite hard
working, with access around the clock, and we switched out 8.1 to 8.3
with abut 1 minute of downtime.
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-admin@postgresql.org
Cc: scott.marlowe@gmail.com, ss.postgres@gmail.com
Subject: Re: Ideal way to upgrade to postgres 8.3 with less downtime
In-Reply-To: <dcc563d10811111112m516209daq48be34c77dce2d07@mail.gmail.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