Wiki / Command-line Tools / Server applications
pg_controldata
pg_controldata — display control information of a PostgreSQL database cluster
Reading PostgreSQL 18.6.
Description
pg_controldata — display control information of a PostgreSQL database cluster
- Documented executable
- pg_controldata
- Executable version
- 18.6
- Reference inventory
- Server applications
- Option definition groups
- 0
Usage
pg_controldata [ option ] [[ -D | --pgdata ] datadir ]Documented options
| Option and arguments | Description |
|---|---|
| No entries recorded. | |
Environment variables
| Variable | Meaning |
|---|---|
| PGDATA | Default data directory location |
| PG_COLOR | Specifies whether to use color in diagnostic messages. Possible values are always , auto and never . |
Manual definition
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,autoandnever.
Documentation and source
Source build
- Version
- 18.6
- Build
- https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2
- Source fingerprint
ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8
Compare versions
PostgreSQL 11 → 12: changed.
--- PostgreSQL 11
+++ PostgreSQL 12
@@ -3,6 +3,10 @@
{
"description": "Default data directory location",
"name": "PGDATA"
+ },
+ {
+ "description": "Specifies whether to use color in diagnostic messages. Possible values are always , auto and never .",
+ "name": "PG_COLOR"
}
],
"options": [],Compares recorded interfaces and attributes. Source fingerprints and build metadata are excluded; an absent sample is not proof of the introduction or removal release.
Related entries
Export JSON · Back to Command-line Tools · Recorded in PostgreSQL 10 through 20; the first sample is not necessarily its introduction.