Postgres Pro
Downloads
Home   >   mailing lists

How to change standby node to sync from the new master withoutrebooting the PostgreSQL service? - Mailing list pgsql-general

From Madan Kumar
Subject How to change standby node to sync from the new master withoutrebooting the PostgreSQL service?
Date
Msg-id CAMtsaPG3e=kzgvqCfmV80acqDCK4Yi5Zko4XbX+CEZ+rfyS0Ww@mail.gmail.com
Whole thread Raw
Responses RE: How to change standby node to sync from the new master withoutrebooting the PostgreSQL service?  (Scot Kreienkamp <Scot.Kreienkamp@la-z-boy.com>)
List pgsql-general
Tree view
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"

pgsql-general by date:

Previous
From: Mike Martin
Date:
Subject: Problem with commit in function
Next
From: Christoph Moench-Tegeder
Date:
Subject: Re: Problem with commit in function