↑↓ select↵ open⌫ change scopeOpen full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Wiki / Command-line Tools

pg_controldata

pg_controldata — display control information of a PostgreSQL database cluster

Reading PG 18·Select a recorded version

Documented executable
pg_controldata
Executable version
18.6
Reference inventory
Server applications
Option definition groups
0
environment
map[description:Default data directory location name:PGDATA], map[description:Specifies whether to use color in diagnostic messages. Possible values are always , auto and never . name:PG_COLOR]
manual path
app-pgcontroldata.html
options
Unknown
signature
pg_controldata [ option ] [[ -D | --pgdata ] datadir ]
synopsis
pg_controldata [ option ] [[ -D | --pgdata ] datadir ]

Definition PG 18

pg_controldata

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. This utility supports the options -V and --version, which print the pg_controldata version and exit. It also supports options -? and --help, which output the supported arguments.

Environment

PGDATA

Default data directory location

PG_COLOR

Specifies whether to use color in diagnostic messages. Possible values are always, auto and never.

Documented options

Option and argumentsDescription

Environment variables

VariableMeaning
PGDATADefault data directory location
PG_COLORSpecifies whether to use color in diagnostic messages. Possible values are always , auto and never .

Compare versions

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8

Text language: en · ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8