recovery_target_action is a configuration parameter determining an action to be taken when the recovery target is reached
recovery_target_action was added in PostgreSQL 9.5.
If one of the following recovery targets is set:
the action specified in
recovery_target_action will be carried out; this can be one of:
The default value for
- PostgreSQL 12
- PostgreSQL 9.5
Note: initially added as
action_at_recovery_target, renamed to
recovery_target_action in commit b8e33a85).
Sample log output with a recovery target set and
recovery_target_action set to
[2020-12-23 11:12:56 CET] LOG: 00000: consistent recovery state reached at 0/2000100 [2020-12-23 11:12:56 CET] LOG: 00000: recovery stopping after reaching consistency [2020-12-23 11:12:56 CET] LOG: 00000: pausing at the end of recovery [2020-12-23 11:12:56 CET] HINT: Execute pg_wal_replay_resume() to promote. [2020-12-23 11:12:56 CET] LOG: 00000: database system is ready to accept read only connections