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
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" |