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