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_waldump — display a human-readable rendering of the write-ahead log of a PostgreSQL database cluster

  • postgres — PostgreSQL database server

  • postmaster — PostgreSQL database server