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_checksums — enable, disable or check data checksums in a PostgreSQL database cluster
- 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_waldump — display a human-readable rendering of the write-ahead log of a PostgreSQL database cluster
- postgres — PostgreSQL database server
- pg_archivecleanup — clean up PostgreSQL WAL archive files