How to change standby node to sync from the new master without rebooting the PostgreSQL service?

From: Madan Kumar <madankumar1993(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: How to change standby node to sync from the new master without rebooting the PostgreSQL service?
Date: 2018-10-30 11:19:39
Message-ID: CAMtsaPG3e=kzgvqCfmV80acqDCK4Yi5Zko4XbX+CEZ+rfyS0Ww@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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"*

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christoph Moench-Tegeder 2018-10-30 11:31:12 Re: Problem with commit in function
Previous Message Mike Martin 2018-10-30 10:51:17 Problem with commit in function