PG_CONTROLDATA(1)

πŸ“¦ version 14.24, in opensuse-leap 16.0

✨ NAME ✨

okay bestie, this is the PG_CONTROLDATA(1) man page for the pg_controldata command, straight from the PostgreSQL 14.24 docs πŸ’–. It displays control information of a PostgreSQL database cluster β€” like the cluster-wide lore, not one single database’s business. πŸ’…

πŸ¦‹ SYNOPSIS πŸ¦‹

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

πŸ’– DESCRIPTION πŸ’–

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

This utility can only be run by the user who initialized the cluster, because it requires read access to the data directory. Permission vibe check: passed or nope. πŸ™ˆ You can specify the data directory on the command line, or use the environment variable PGDATA.

It also supports these options:

  • -V, --version β€” print the pg_controldata version and exit. Literally version info and dip πŸ‘‹
  • -?, --help β€” output the supported arguments. Helpful icon behavior πŸŽ€

πŸŽ€ ENVIRONMENT πŸŽ€

  • PGDATA β€” default data directory location. The classic default spot, no cap 🏠
  • PG_COLOR β€” specifies whether to use color in diagnostic messages. Possible values are always, auto and never. Color me obsessed 🌈

with love, proper read access, and main character energy: PostgreSQL 14.24, dated 2026, for PG_CONTROLDATA(1) πŸ’…πŸ«ΆπŸ“