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

Поиск
Список
Период
Сортировка
От Jov
Тема Re: [GENERAL] Major Version Upgradation from 9.4 to 9.6 in Replication Environment
Дата
Msg-id CADyrUxPsz4pBqNnh9u_XSeMB5212-pZKCSVay3HVBrZhm-3Wpw@mail.gmail.com
обсуждение исходный текст
Ответ на [GENERAL] Major Version Upgradation from 9.4 to 9.6 in Replication Environment  (Amee Sankhesara - Quipment India <amee.sankhesara@quipment.nl>)
Список pgsql-general
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.sankhesara@quipment.nl>写道:

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@ / www.quipment.in

 

QTwee Group BV
KvK Arnhem 60858001
BTW NL854090721B01
mail@ / 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.

 

Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: rob stone
Дата:
Сообщение: Re: [GENERAL] How to get transaction started always in WRITE mode.
Следующее
От: Nick Brennan
Дата:
Сообщение: [GENERAL] Indexes being ignored after upgrade to 9.5