Re: Upgrade

On Thu, Jun 25, 2009 at 10:04 PM, Pedro Doria Meunier <pdoria(at)netmadeira(dot)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