- publishing free software manuals
The PostgreSQL 9.0 Reference Manual - Volume 1B - SQL Command Reference
by The PostgreSQL Global Development Group
Paperback (6"x9"), 488 pages
ISBN 9781906966058
RRP £14.95 ($19.95)

Sales of this book support the PostgreSQL project! Get a printed copy>>>

3.2 pg_controldata

Name

pg_controldata -- display control information of a PostgreSQL database cluster

Synopsis

pg_controldata [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
ISBN 9781906966058The PostgreSQL 9.0 Reference Manual - Volume 1B - SQL Command ReferenceSee the print edition