pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedMajor Version Upgradation in Replication Environment
4+ messages / 3 participants
[nested] [flat]
* Major Version Upgradation in Replication Environment
@ 2016-05-05 09:48 Vicky Soni - Quipment India <vicky.soni@quipment.nl>
2016-05-05 13:59 ` Re: Major Version Upgradation in Replication Environment Guillaume Lelarge <guillaume@lelarge.info>
0 siblings, 1 reply; 4+ messages in thread
From: Vicky Soni - Quipment India @ 2016-05-05 09:48 UTC (permalink / raw)
To: 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.soni@quipment.in> / www.quipment.in<http://www.quipment.in;
QTwee Group BV
KvK Arnhem 60858001
BTW NL854090721B01
mail@<mailto:mail@quipment.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.
Attachments:
image001.jpg (image/jpeg, 23.8K) download
view image
* Re: Major Version Upgradation in Replication Environment
2016-05-05 09:48 Major Version Upgradation in Replication Environment Vicky Soni - Quipment India <vicky.soni@quipment.nl>
@ 2016-05-05 13:59 ` Guillaume Lelarge <guillaume@lelarge.info>
2016-05-10 20:39 ` Re: Major Version Upgradation in Replication Environment Bruce Momjian <bruce@momjian.us>
0 siblings, 1 reply; 4+ messages in thread
From: Guillaume Lelarge @ 2016-05-05 13:59 UTC (permalink / raw)
To: Vicky Soni - Quipment India <vicky.soni@quipment.nl>; +Cc: pgsql-admin
2016-05-05 11:48 GMT+02:00 Vicky Soni - Quipment India <
vicky.soni@quipment.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.
>
>
>
>
--
Guillaume.
http://blog.guillaume.lelarge.info
http://www.dalibo.com
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Major Version Upgradation in Replication Environment
2016-05-05 09:48 Major Version Upgradation in Replication Environment Vicky Soni - Quipment India <vicky.soni@quipment.nl>
2016-05-05 13:59 ` Re: Major Version Upgradation in Replication Environment Guillaume Lelarge <guillaume@lelarge.info>
@ 2016-05-10 20:39 ` Bruce Momjian <bruce@momjian.us>
2016-05-11 07:07 ` Re: Major Version Upgradation in Replication Environment Guillaume Lelarge <guillaume@lelarge.info>
0 siblings, 1 reply; 4+ messages in thread
From: Bruce Momjian @ 2016-05-10 20:39 UTC (permalink / raw)
To: Guillaume Lelarge <guillaume@lelarge.info>; +Cc: Vicky Soni - Quipment India <vicky.soni@quipment.nl>; 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.soni@quipment.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@momjian.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 +
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Major Version Upgradation in Replication Environment
2016-05-05 09:48 Major Version Upgradation in Replication Environment Vicky Soni - Quipment India <vicky.soni@quipment.nl>
2016-05-05 13:59 ` Re: Major Version Upgradation in Replication Environment Guillaume Lelarge <guillaume@lelarge.info>
2016-05-10 20:39 ` Re: Major Version Upgradation in Replication Environment Bruce Momjian <bruce@momjian.us>
@ 2016-05-11 07:07 ` Guillaume Lelarge <guillaume@lelarge.info>
0 siblings, 0 replies; 4+ messages in thread
From: Guillaume Lelarge @ 2016-05-11 07:07 UTC (permalink / raw)
To: Bruce Momjian <bruce@momjian.us>; +Cc: Vicky Soni - Quipment India <vicky.soni@quipment.nl>; pgsql-admin
2016-05-10 22:39 GMT+02:00 Bruce Momjian <bruce@momjian.us>:
> 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.soni@quipment.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
>
>
Well, you still have to rsync the data directory (and all tablespaces'
directories). Though I agree you don't literaly have to do a complete setup.
Thanks for the clarification.
--
Guillaume.
http://blog.guillaume.lelarge.info
http://www.dalibo.com
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2016-05-11 07:07 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2016-05-05 09:48 Major Version Upgradation in Replication Environment Vicky Soni - Quipment India <vicky.soni@quipment.nl>
2016-05-05 13:59 ` Guillaume Lelarge <guillaume@lelarge.info>
2016-05-10 20:39 ` Bruce Momjian <bruce@momjian.us>
2016-05-11 07:07 ` Guillaume Lelarge <guillaume@lelarge.info>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox