pg_control_recovery()

A function exposing a subset of pg_control data about the recovery state

pg_control_recovery() is a system function exposing a subset of pg_control data about the recovery state.

pg_control_recovery() was added in PostgreSQL 9.6.

Usage

pg_control_recovery() → record

Change history

Examples

postgres=# SELECT * FROM pg_control_recovery()\gx
-[ RECORD 1 ]-----------------+-----------
min_recovery_end_lsn          | 2/BDFE0260
min_recovery_end_timeline     | 1
backup_start_lsn              | 0/0
backup_end_lsn                | 0/0
end_of_backup_record_required | f

Categories

PostgreSQL internals, System function

See also

pg_controldata, pg_control_system(), pg_control_checkpoint(), pg_control_init()