PostgreSQL Client Applications
This part contains reference information for
PostgreSQL client applications and
utilities. Not all of these commands are of general utility; some
might require special privileges. The common feature of these
applications is that they can be run on any host, independent of
where the database server resides.
When specified on the command line, user and database names have
their case preserved — the presence of spaces or special
characters might require quoting. Table names and other identifiers
do not have their case preserved, except where documented, and
might require quoting.
Table of Contents
- clusterdb — cluster a PostgreSQL database
- createdb — create a new PostgreSQL database
- createuser — define a new PostgreSQL user account
- dropdb — remove a PostgreSQL database
- dropuser — remove a PostgreSQL user account
- ecpg — embedded SQL C preprocessor
- pg_amcheck — checks for corruption in one or more
PostgreSQL databases
- pg_basebackup — take a base backup of a PostgreSQL cluster
- pgbench — run a benchmark test on PostgreSQL
- pg_combinebackup — reconstruct a full backup from an incremental backup and dependent backups
- pg_config — retrieve information about the installed version of PostgreSQL
- pg_dump —
export a PostgreSQL database as an SQL script or to other formats
- pg_dumpall —
export a PostgreSQL database cluster as an SQL script or to other formats
- pg_isready — check the connection status of a PostgreSQL server
- pg_password —
change user password
- pg_receivewal — stream write-ahead logs from a PostgreSQL server
- pg_recvlogical — control PostgreSQL logical decoding streams
- pg_restore —
restore PostgreSQL databases from archives
created by pg_dump or
pg_dumpall
- pg_verifybackup — verify the integrity of a base backup of a
PostgreSQL cluster
- psql —
PostgreSQL interactive terminal
- reindexdb — reindex a PostgreSQL database
- vacuumdb — garbage-collect and analyze a PostgreSQL database