pg_controldata

Supported versions: Current (18) / 17 / 16 / 15 / 14

Development versions: 19 / 20devel

Unsupported versions: 13 / 12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3 / 8.2 / 8.1 / 8.0 / 7.4 / 7.3

Development snapshot. PostgreSQL 20devel has not been released. Content may change.

pg_controldata
Prev	Up	PostgreSQL Server Applications	Home	Next

pg_controldata — display control information of a PostgreSQL database cluster

Synopsis

pg_controldata [option] [ [ -D | --pgdata ] datadir ]

Description

pg_controldata prints information initialized during initdb, such as the catalog version. It also shows information about write-ahead logging and checkpoint processing. This information is cluster-wide, and not specific to any one database.

This utility can only be run by the user who initialized the cluster because it requires read access to the data directory. You can specify the data directory on the command line, or use the environment variable PGDATA.

Options

-D datadir --pgdata=datadir: Specifies the directory where the database cluster is stored.
-V --version: Print the pg_controldata version and exit.
-? --help: Show help about pg_controldata command line arguments, and exit.

Environment

PGDATA: Default data directory location
PG_COLOR: Specifies whether to use color in diagnostic messages. Possible values are always, auto and never.

Prev	Up	Next
pg_checksums	Home	pg_createsubscriber

Report a documentation issue

Read the upstream documentation. For corrections, first check the current manual.