On Fri, Jan 20, 2012 at 2:45 PM, Nicholson, Brad (Toronto, ON, CA) <[email protected]> wrote: > >> -----Original Message----- >> From: [email protected] [mailto:pgsql-admin- >> [email protected]] On Behalf Of francis picabia >> Sent: Friday, January 20, 2012 1:12 PM >> To: [email protected] >> 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 seconds for 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.
That's great information. 9.0 is introducing streaming replication, so that is another option I'll look into. -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
