Re: Function to promote standby servers - Mailing list pgsql-hackers

From Laurenz Albe
Subject Re: Function to promote standby servers
Date
Msg-id e1f788f76240023dd5a7f9529bfa4a93edea2f77.camel@cybertec.at
Whole thread Raw
In response to Re: Function to promote standby servers  (Michael Paquier <michael@paquier.xyz>)
Responses Re: Function to promote standby servers  (Masahiko Sawada <sawada.mshk@gmail.com>)
List pgsql-hackers
Michael Paquier wrote:
> > In that vein, I propose a function pg_promote() to promote
> > physical standby servers.
> 
> No fundamental issues from me regarding the concept of being able to
> trigger a promotion remotely, so +1.  Do we want this capability as well
> for fallback_promote?  My gut tells me no, and that we ought to drop
> this option at some point in the future, still that's worth mentioning.
> 
> You may want to move PROMOTE_SIGNAL_FILE in a position where xlogfuncs.c
> could use it.

Good, idea; updated patch attached.

Yours,
Laurenz Albe

Attachment

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: [HACKERS] Optional message to user when terminating/cancellingbackend
Next
From: Chris Travers
Date:
Subject: Possible important data point on stats collection, wondering aboutpossible improvement