Upgrade

From: Pedro Doria Meunier <pdoria(at)netmadeira(dot)com>
To: Postgresql Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Upgrade
Date: 2009-06-25 12:04:03
Message-ID: 4A4367B3.90403@netmadeira.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi all,

I've got a somewhat 'hairy' problem in my hands...

One of my servers is still Fedora Core (cough) (cough) 6 :]
It's running Postgresql 8.2.4

I want it to serve as a last resort, end of the spectrum, backup/slave
for another server running Postgresql 8.2.9 via Slony-I.

The other server is running Postgresql 8.2.9 over Fedora Core 8.

First challenge: I need to upgrade to postgresql 8.3 if I'm to use
Slony-I 2.0.2 on both servers.

At a glance I feel that upgrading the FC6 server is the hairiest of
tasks to be accomplished.
Regarding the FC8 (a.k.a. master wannabe): would an upgrade from 8.2.9
to 8.3 require a dump/reload ?
The DB size on this server is not that big (~6GB), although a single
table has >8.3M rows, meaning that if a dump/reload is involved I'm
looking at several hours of out of service (sweat)...

Insight on how to tackle the upgrade for these two servers (especially
the FC6 one) would be much appreciated! ;-)

Thanks in advance.
BR.

- --
Pedro Doria Meunier
GSM: +351 96 17 20 188
Skype: pdoriam

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org

iD8DBQFKQ2eq2FH5GXCfxAsRAvqkAJwOrlUSI37IdbiaFmnWfkBo4hakkwCeMugm
NbYacw6nox6xubq3llNR0xk=
=f862
-----END PGP SIGNATURE-----

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bill Moran 2009-06-25 12:11:08 Re: Upgrade
Previous Message Saurabh Dave 2009-06-25 11:55:07 Re: [JDBC] Postgres 8.3.7 -- EOF on client connection