PostgreSQL Server Applications

Table of Contents

initdb — create a new PostgreSQL database cluster

pg_archivecleanup — clean up PostgreSQL WAL archive files

pg_checksums — enable, disable or check data checksums in a PostgreSQL database cluster

pg_controldata — display control information of a PostgreSQL database cluster

pg_createsubscriber — convert a physical replica into a new logical replica

pg_ctl — initialize, start, stop, or control a PostgreSQL server

pg_keytool — derive cluster encryption key and/or send it to the PostgreSQL server

pg_resetwal — reset the write-ahead log and other control information of a PostgreSQL database cluster

pg_rewind — synchronize a PostgreSQL data directory with another data directory that was forked from it

pg_syslog — read PostgreSQL syslogger output from a named pipe and write it to a file

pg_test_fsync — determine fastest wal_sync_method for PostgreSQL

pg_test_timing — measure timing overhead

pg_upgrade — upgrade a PostgreSQL server instance

pg_waldump — display a human-readable rendering of the write-ahead log of a PostgreSQL database cluster

pg_walsummary — print contents of WAL summary files

postgres — PostgreSQL database server