pg_upgrade + streaming replication ?

From: Lonni J Friedman <netllama(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: pg_upgrade + streaming replication ?
Date: 2012-03-01 22:01:31
Message-ID: CAP=oouH_-7H-MLegKHTMa=NqgZe6oRZqTSBZmahCfEPPA2nO3A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

thanks

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Benjamin Henrion 2012-03-01 22:06:29 Split read/write queries between 2 servers (one master and one slave with streaming replication)?
Previous Message Tom Lane 2012-03-01 21:50:29 Re: "Compressed data is corrupt"