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

From Andreas Hasenack
Subject Re: Best practise for upgrade of 24GB+ database
Date
Msg-id CAKyYGbMoYELhmj=qXowPSM-05A20tKwrSb3mXM8iY4hGVO48gg@mail.gmail.com
Whole thread Raw
In response to Re: Best practise for upgrade of 24GB+ database  ("Nicholson, Brad (Toronto, ON, CA)" <bnicholson@hp.com>)
Responses Re: Best practise for upgrade of 24GB+ database  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-admin
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?

pgsql-admin by date:

Previous
From: Simon Riggs
Date:
Subject: Re: two questions regarding warm-standby on 8.4
Next
From: Scott Marlowe
Date:
Subject: Re: Best practise for upgrade of 24GB+ database