From: Achilleas Mantzios <achill@matrix.gatewaynet.com>
To: pgsql-admin@postgresql.org
Cc: Swathi S <ss.postgres@gmail.com>
Subject: Re: Ideal way to upgrade to postgres 8.3 with less downtime
Date: Fri, 7 Nov 2008 10:32:40 +0200
Message-ID: <200811071032.40803.achill@matrix.gatewaynet.com> (raw)
In-Reply-To: <6c1264780811062204t260f7c4eo20675bc8d2b0bb6b@mail.gmail.com>
References: <6c1264780811062204t260f7c4eo20675bc8d2b0bb6b@mail.gmail.com>
Στις Friday 07 November 2008 08:04:05 ο/η Swathi S έγραψε:
> 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.
>
> Thanks
> Swathi
>
And now you are running with which version?
The ideal way is to read the HISTORY file, do several upgrade excercises on a test system with the
same database (e.g. with a recent backup of the original), and then plan/organize your actions.
But i must say that the older version of postgresql you run, the fancier things your apps do, and the more lines of code they have,
the harder it will be to upgrade.
Usually SPI and JDBC require large amounts of work as well.
Well i dont mean to be pessimistic, but our 7.4 -> 8.3 upgrade was pretty painful.
--
Achilleas Mantzios
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: achill@matrix.gatewaynet.com, ss.postgres@gmail.com
Subject: Re: Ideal way to upgrade to postgres 8.3 with less downtime
In-Reply-To: <200811071032.40803.achill@matrix.gatewaynet.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