May 2018
Intermediate to advanced
576 pages
30h 25m
English
The pg_controldata utility is a PostgreSQL server application that shows the content of a server's control file. The control file is located within the data directory of a server, and it is created at database initialization time. Some of the information within it is updated regularly, and some when certain major events occur.
The full output of pg_controldata looks like the following (the bold values are those that may change over time as the server runs):
pg_control version number: 1002Catalog version number: 201707211Database system identifier: 6320137769675861859Database cluster state: in productionpg_control last modified: Sun 31 Dec 2017 16:17:41 PM GMTLatest checkpoint location: 0/19000728Prior checkpoint location: 0/19000648 ...