pg_controldata

displays PostgreSQL cluster control information

TLDR

Show cluster control data
$ pg_controldata [data_dir]
Show with PGDATA environment
$ pg_controldata

SYNOPSIS

pg_controldata [option] [-D] datadir

DESCRIPTION

pg_controldata displays PostgreSQL cluster control information. Shows WAL position, checkpoint info, and database state. Useful for disaster recovery and debugging.

PARAMETERS

-D, --pgdata dir

Data directory.

INSTALL

sudo dnf install postgresql17
sudo apk add postgresql17
sudo zypper install postgresql17

SEE ALSO

pg_resetwal(1), pg_rewind(1)