Re: pg_upgrade + streaming replication ?

On Mon, Mar 19, 2012 at 12:30 PM, Bruce Momjian <bruce@momjian.us> wrote:
> On Thu, Mar 01, 2012 at 02:01:31PM -0800, Lonni J Friedman wrote:
>> I've got a 3 node cluster (1 master/2 slaves) running 9.0.x with
>> streaming replication.  I'm in the planning stages of upgrading to
>> 9.1.x, and am looking into the most efficient way to do the upgrade
>> with the goal of minimizing downtime & risk.  After googling, the only
>> discussion that I've found of using pg_upgrade with a streaming
>> replication setup seems to be this (nearly) year old thread:
>> http://web.archiveorange.com/archive/v/9FNVlDWGQtpyWVL54jlK
>>
>> In summary, there is no way to use both pg_upgrade and streaming
>> replication simultaneously.  I'd have to either use pg_upgrade and
>> then effectively rebuild/redeploy the slaves, or not use pg_upgrade,
>> and reimport all of the data.  Is that still the latest status, or are
>> there other options?
>
> You can shut down all three servers, run pg_upgrade on all of them, then
> restart them as 9.1 servers.
>

Thanks for your reply.  This is very good news.