Major Version Upgradation in Replication Environment

From: "Vicky Soni - Quipment India" <vicky(dot)soni(at)quipment(dot)nl>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Major Version Upgradation in Replication Environment
Date: 2016-05-05 09:48:58
Message-ID: 77592492c52d46ccbbe7e79b448da317@Strand.quipment.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

[Quipment Logo]

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?

What are the best possible ways available to upgrade slave and master without setting up replication again?

Our Setup - WINDOWS SERVER 2012 , PostgreSQL 9.3.12 on primary and slave
Objective - To Upgrade Master and Slave from 9.3 to 9.4

Vicky Soni
Database Administrator

.Net Department

T / +91 (0) 93288 80507
vicky.soni@<mailto:%20vicky(dot)soni(at)quipment(dot)in> / www.quipment.in<http://www.quipment.in>

QTwee Group BV
KvK Arnhem 60858001
BTW NL854090721B01
mail@<mailto:mail(at)quipment(dot)nl> / www.quipment.nl<http://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
A-212 Shivalik Corporate Park
B/H IOC Petrol Pump
Satellite, 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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Guillaume Lelarge 2016-05-05 13:59:00 Re: Major Version Upgradation in Replication Environment
Previous Message Ondřej Světlík 2016-05-04 20:27:30 Re: Autovacuum of pg_shdepend