PostgreSQL Server Applications
This part contains reference information forPostgreSQL 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 inPostgreSQL Client Applications.
Table of Contents
- initdb — create a newPostgreSQL database cluster
- pg_archivecleanup — clean upPostgreSQL WAL archive files
- pg_checksums — enable, disable or check data checksums in aPostgreSQL database cluster
- pg_controldata — display control information of aPostgreSQL database cluster
- pg_createsubscriber — convert a physical replica into a new logical replica
- pg_ctl — initialize, start, stop, or control aPostgreSQL server
- pg_resetwal — reset the write-ahead log and other control information of aPostgreSQL database cluster
- pg_rewind — synchronize aPostgreSQL data directory with another data directory that was forked from it
- pg_test_fsync — determine fastest
wal_sync_method
forPostgreSQL- pg_test_timing — measure timing overhead
- pg_upgrade — upgrade aPostgreSQL server instance
- pg_waldump — display a human-readable rendering of the write-ahead log of aPostgreSQL database cluster
- pg_walsummary — print contents of WAL summary files
- postgres —PostgreSQL database server
- pg_archivecleanup — clean upPostgreSQL WAL archive files