Contents

pg_control_system()

A function exposing data about the current pg_control file state

pg_control_system() is a system function exposing a subset of pg_control data about the current control file state.

pg_control_system() was added in PostgreSQL 9.6.

Usage

pg_control_system () → record

Change history

Examples

postgres=# SELECT * FROM pg_control_system();
 pg_control_version | catalog_version_no |  system_identifier  | pg_control_last_modified
--------------------+--------------------+---------------------+--------------------------
               1201 |          201907142 | 6713788894984179264 | 2019-07-17 15:23:19+01
(1 row)

Categories

PostgreSQL internals, System function

See also

pg_controldata, pg_control_checkpoint(), pg_control_init(), pg_control_recovery()