Re: Best practise for upgrade of 24GB+ database

> -----Original Message-----
> From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-
> owner@postgresql.org] On Behalf Of francis picabia
> Sent: Friday, January 20, 2012 1:12 PM
> To: pgsql-admin@postgresql.org
> Subject: [ADMIN] Best practise for upgrade of 24GB+ database
>
> How do others manage larger database upgrades while minimizing
> downtime?  Do you avoid pg_upgradecluster and simply do a pg_restore
> from a dump made prior to the upgrade?  Do you run a replication
> and then resync it after the upgrade is complete?  Googling for info
> on this I've only found remarks about it taking longer than you'd
> expect.

In the past I've used Slony to upgrade much larger database clusters than yours with minimal down time (I'm talking
secondsfor the actual master switch).  You set up a new replica on the new version and then move the master from old to
new. No need to explicitly resync afterwards. 

Brad.