Re: Major Version Upgradation from 9.4 to 9.6 in Replication Environment

Not sure windows，on linux，you can use pg_upgrade hardlink mode and use
rsync to achieve this. See 9.6 pg_upgrade doc for detail.

Jov

2017年7月26日 5:50 AM，"Amee Sankhesara - Quipment India" <
amee(dot)sankhesara(at)quipment(dot)nl>写道：

> [image: Quipment Logo]
>
> Hello,
>
>
>
> We have a windows setup where we have 2 node primary-slave setup which
> comprises Async Replication + Log Shipping on slave.
>
>
>
> Now we want to upgrade it from 9.4 to 9.6 version.
>
>
>
> Do we need to upgrade slave to 9.6, upgrade master to 9.6 and setup
> replication again from scratch?
>
>
>
> What are the best possible ways available to upgrade slave and master
> without setting up replication again?
>
>
>
> Our Setup - WINDOWS SERVER 2012 , PostgreSQL 9.4.7 on primary and slave
>
> Objective - To Upgrade Master and Slave from 9.4 to 9.6
>
>
>
> Thanks,
>
> *Amee Sankhesara*
> *Database Developer*
>
> R&D .Net Department
>
> T / +91 (0) 94295 45266
> amee.sankhesara@ <%20amee(dot)sankhesara(at)quipment(dot)in> / www.quipment.in
>
>
>
> *QTwee Group BV*
> KvK Arnhem 60858001
> BTW NL854090721B01
> mail@ <mail(at)quipment(dot)nl> / www.quipment.nl
>
> *Hoofdkantoor Nijmegen*
> Kerkenbos 1236 C
> 6546 BE Nijmegen
>
> Tel.
>
> +31 (0)24 372 47 00
>
> Fax.
>
> +31 (0)24 372 47 07
>
> *Quipment India*
> 903-904 Landmark,
> Beside Titanium City Centre,
> Anandnagar Road, 100ft Ring Road,
> Ahmedabad
> Gujarat - 380015 - India
> Tel. +91 (0) 79 4009 7847
>
> *Disclaimer*
>
> This e-mail message (including any attachment) is intended only for the
> personal use of the recipient(s) named above. This message is confidential
> and may be legally privileged. If you are not an intended recipient, you
> may not review, copy or distribute this message. If you have received this
> communication in error, please notify us immediately by e-mail and delete
> the original message.
>
>
>