RE: How to change standby node to sync from the new master withoutrebooting the PostgreSQL service?

Поиск
Список
Период
Сортировка
От Scot Kreienkamp
Тема RE: How to change standby node to sync from the new master withoutrebooting the PostgreSQL service?
Дата
Msg-id 17082AAFC33A934082836458CB53494374D693D9@MONDB03.na.lzb.hq
обсуждение исходный текст
Ответ на How to change standby node to sync from the new master withoutrebooting the PostgreSQL service?  (Madan Kumar <madankumar1993@gmail.com>)
Ответы Re: How to change standby node to sync from the new master withoutrebooting the PostgreSQL service?  (Madan Kumar <madankumar1993@gmail.com>)
Список pgsql-general

Point it at a VIP that travels with the master. 

 

Scot Kreienkamp |Senior Systems Engineer | La-Z-Boy Corporate
One La-Z-Boy Drive| Monroe, Michigan 48162 | Office: 734-384-6403 | | Mobile: 7349151444 | Email: Scot.Kreienkamp@la-z-boy.com

From: Madan Kumar [mailto:madankumar1993@gmail.com]
Sent: Tuesday, October 30, 2018 7:20 AM
To: pgsql-general@lists.postgresql.org
Subject: How to change standby node to sync from the new master without rebooting the PostgreSQL service?

 

Hi,

 

Whenever there is a change in master, PostgreSQL service on standby nodes must be restarted (after changing the master IP in the recovery.conf) to ensure it is syncing with the new master.

Is there a way to point to new master without reboot of PostgreSQL on the standby?

 

Warm Regards,

 

"There is no Elevator to Success. You have to take the Stairs"

This message is intended only for the individual or entity to which it is addressed.  It may contain privileged, confidential information which is exempt from disclosure under applicable laws.  If you are not the intended recipient, you are strictly prohibited from disseminating or distributing this information (other than to the intended recipient) or copying this information.  If you have received this communication in error, please notify us immediately by e-mail or by telephone at the above number. Thank you.

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

Предыдущее
От: Marian Forums
Дата:
Сообщение: Question about servicescript for stopping and starting postgresql instance
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Question about servicescript for stopping and starting postgresqlinstance