Re: Best practise for upgrade of 24GB+ database - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: Best practise for upgrade of 24GB+ database
Date
Msg-id CAOR=d=0udSUXwjS0vxfOph3_+DRhvkeLfk+wKbgefsY1wm13eQ@mail.gmail.com
Whole thread Raw
In response to Re: Best practise for upgrade of 24GB+ database  (Andreas Hasenack <panlinux@gmail.com>)
List pgsql-admin
On Mon, Jan 23, 2012 at 10:21 AM, Andreas Hasenack <panlinux@gmail.com> wrote:
> On Fri, Jan 20, 2012 at 16:45, Nicholson, Brad (Toronto, ON, CA)
> <bnicholson@hp.com> wrote:
>> 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. 
>
> Would that work to upgrade from, say, 8.4 to 9.1? Using slony?

It should.  As long as both can support the same version of slony
you're good to go.

pgsql-admin by date:

Previous
From: Andreas Hasenack
Date:
Subject: Re: Best practise for upgrade of 24GB+ database
Next
From: Gary Webster
Date:
Subject: Re: two questions regarding warm-standby on 8.4