PostgreSQL

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

postmaster — PostgreSQL database server

If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.

Privacy Policy | Code of Conduct | About PostgreSQL | Contact

Copyright © 1996-2023 The PostgreSQL Global Development Group