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

From Michael Paquier
Subject Re: Function to promote standby servers
Date
Msg-id 20180921052709.GL1338@paquier.xyz
Whole thread Raw
In response to Function to promote standby servers  (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses Re: Function to promote standby servers  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-hackers
On Thu, Sep 20, 2018 at 07:59:02AM +0200, Laurenz Albe wrote:
> Providing SQL access for administrative tasks seems to be a
> good thing, see ALTER SYSTEM and pg_reload_conf().
>
> 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.
--
Michael

Attachment

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Unclear error message
Next
From: Michael Paquier
Date:
Subject: Re: transction_timestamp() inside of procedures