On Mon, Mar 19, 2012 at 12:30 PM, Bruce Momjian <bruce@xxxxxxxxxx> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
