On Thu, Jun 25, 2009 at 10:04 PM, Pedro Doria Meunier <pdo...@netmadeira.com > wrote:
> -----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! ;-) > <http://www.postgresql.org/mailpref/pgsql-general> You would need to do a dump restore when upgrading from 8.2.9 to 8.3. Guy Flaherty