How to change standby node to sync from the new master without rebooting the PostgreSQL service?
Madan Kumar <madankumar1993@gmail.com>
From: Madan Kumar <madankumar1993@gmail.com>
To: pgsql-general@lists.postgresql.org
Date: 2018-10-30T11:19:39Z
Lists: pgsql-general
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, Madan Kumar K <https://about.me/madankumark> *"There is no Elevator to Success. You have to take the Stairs"*