Re: pg_upgrade + streaming replication ?

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.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +