PostgreSQL Server Applications
This part contains reference information for PostgreSQL server applications and support utilities. These commands can only be run usefully on the host where the database server resides. Other utility programs are listed in PostgreSQL Client Applications.
Table of Contents
- initdb — create a new PostgreSQL database cluster
- pg_archivecleanup — clean up PostgreSQL WAL archive files
- pg_controldata — display control information of a PostgreSQL database cluster
- pg_ctl — initialize, start, stop, or control a 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_test_fsync — determine fastest
wal_sync_method
for PostgreSQL- pg_test_timing — measure timing overhead
- pg_upgrade — upgrade a PostgreSQL server instance
- pg_verify_checksums — verify data checksums in a PostgreSQL database cluster
- pg_waldump — display a human-readable rendering of the write-ahead log of a PostgreSQL database cluster
- postgres — PostgreSQL database server
- postmaster — PostgreSQL database server
- pg_archivecleanup — clean up PostgreSQL WAL archive files