Contents

pg_control_recovery()

A system 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 (commit dc7d70ea).

Examples

postgres=# SELECT * FROM pg_control_recovery();
-[ RECORD 1 ]-----------------+----
min_recovery_end_lsn          | 0/0
min_recovery_end_timeline     | 0
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()