From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
Cc: | Vicky Soni - Quipment India <vicky(dot)soni(at)quipment(dot)nl>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Major Version Upgradation in Replication Environment |
Date: | 2016-05-10 20:39:01 |
Message-ID: | 20160510203901.GB22757@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Thu, May 5, 2016 at 03:59:00PM +0200, Guillaume Lelarge wrote:
> 2016-05-05 11:48 GMT+02:00 Vicky Soni - Quipment India <vicky(dot)soni(at)quipment(dot)nl>
> :
>
>
> Hello Friends,
>
>
>
> We have a windows setup where we have 2 node
> primary-slave setup which comprises Async Replication + Log Shippin on slave.
>
>
>
> Now we want to upgrade it from 9.3 to 9.4 version.
>
>
>
> Do we need to upgrade slave to 9.4, upgrade master to 9.4 and setup replication
> again from scratch?
>
>
>
>
>
> Just upgrade master to 9.4, install 9.4 on slave, and setup replication again.
>
>
> What are the best possible ways available to upgrade slave and master without
> setting up replication again?
>
>
>
> You can't.
Actually, the 9.5 pg_upgrade docs have in insructions on how upgrade a
slave without recreating the slave image, and it works back to 9.1:
http://www.postgresql.org/docs/9.5/static/pgupgrade.html
Upgrade Streaming Replication and Log-Shipping standby servers
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ As you are, so once was I. As I am, so you will be. +
+ Ancient Roman grave inscription +
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Whitney | 2016-05-10 21:21:41 | Re: Memory and Swap |
Previous Message | Kevin Grittner | 2016-05-10 20:24:31 | Re: driving postgres to achieve benchmark results similar to bonnie++ |