Hi, Unless I'm missing something recovery_target_action = promote/pause don't work.
There's the following block of code in readRecoveryCommandFile(): /* * Override any inconsistent requests. Not that this is a change * of behaviour in 9.5; prior to this we simply ignored a request * to pause if hot_standby = off, which was surprising behaviour. */ if (recoveryTargetAction == RECOVERY_TARGET_ACTION_PAUSE && recoveryTargetActionSet && standbyState == STANDBY_DISABLED) recoveryTargetAction = RECOVERY_TARGET_ACTION_SHUTDOWN; the problem is that when the recovery command file is read standbyState will always still be STANDBY_DISABLED. Which makes sense, because we can't even know we're in recovery before readRecoveryCommandFile(). I guess what you actually intended to test was StandbyModeRequested? Greetings, Andres Freund -- Andres Freund http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers