pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedIdeal way to upgrade to postgres 8.3 with less downtime
3+ messages / 3 participants
[nested] [flat]
* Ideal way to upgrade to postgres 8.3 with less downtime
@ 2008-11-07 06:04 Swathi S <ss.postgres@gmail.com>
0 siblings, 2 replies; 3+ messages in thread
From: Swathi S @ 2008-11-07 06:04 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Ideal way to upgrade to postgres 8.3 with less downtime
@ 2008-11-07 08:32 Achilleas Mantzios <achill@matrix.gatewaynet.com>
parent: Swathi S <ss.postgres@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Achilleas Mantzios @ 2008-11-07 08:32 UTC (permalink / raw)
To: pgsql-admin; +Cc: Swathi S <ss.postgres@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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Ideal way to upgrade to postgres 8.3 with less downtime
@ 2008-11-11 19:12 Scott Marlowe <scott.marlowe@gmail.com>
parent: Swathi S <ss.postgres@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Scott Marlowe @ 2008-11-11 19:12 UTC (permalink / raw)
To: Swathi S <ss.postgres@gmail.com>; +Cc: pgsql-admin
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2008-11-11 19:12 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-11-07 06:04 Ideal way to upgrade to postgres 8.3 with less downtime Swathi S <ss.postgres@gmail.com>
2008-11-07 08:32 ` Achilleas Mantzios <achill@matrix.gatewaynet.com>
2008-11-11 19:12 ` Scott Marlowe <scott.marlowe@gmail.com>
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