Contents
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.
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
References
- PostgreSQL documentation: pg_control_recovery()