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