From: | Lonni J Friedman <netllama(at)gmail(dot)com> |
---|---|
To: | Bruce Momjian <bruce(at)momjian(dot)us> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: pg_upgrade + streaming replication ? |
Date: | 2012-03-19 19:38:11 |
Message-ID: | CAP=oouFcUS7AQZUYX6O2pu0WHOHgKdewsP0TR0MxrWfGR2dCAQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Mon, Mar 19, 2012 at 12:30 PM, Bruce Momjian <bruce(at)momjian(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2012-03-19 20:05:33 | Re: BUG #6510: A simple prompt is displayed using wrong charset |
Previous Message | Bruce Momjian | 2012-03-19 19:30:35 | Re: pg_upgrade + streaming replication ? |