Re: Upgrade - Mailing list 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! ;-)