Wiki / Command-line Tools

Client and server programs, command options, environment variables and operational examples.

Reading PostgreSQL 18.6.

Find an entry GroupAll groupsClient applications (21)Server applications (16) Apply

37 entries; 35 recorded in PostgreSQL 18.6.

• clusterdb Client applications

  clusterdb — cluster a PostgreSQL database

  1011121314151617181920
• createdb Client applications

  createdb — create a new PostgreSQL database

  1011121314151617181920
• createuser Client applications

  createuser — define a new PostgreSQL user account

  1011121314151617181920
• dropdb Client applications

  dropdb — remove a PostgreSQL database

  1011121314151617181920
• dropuser Client applications

  dropuser — remove a PostgreSQL user account

  1011121314151617181920
• ecpg Client applications

  ecpg — embedded SQL C preprocessor

  1011121314151617181920
• pg_amcheck Client applications

  pg_amcheck — checks for corruption in one or more PostgreSQL databases

  1011121314151617181920
• pg_basebackup Client applications

  pg_basebackup — take a base backup of a PostgreSQL cluster

  1011121314151617181920
• pg_combinebackup Client applications

  pg_combinebackup — reconstruct a full backup from an incremental backup and dependent backups

  1011121314151617181920
• pg_config Client applications

  pg_config — retrieve information about the installed version of PostgreSQL

  1011121314151617181920
• pg_dump Client applications

  pg_dump — export a PostgreSQL database as an SQL script or to other formats

  1011121314151617181920
• pg_dumpall Client applications

  pg_dumpall — extract a PostgreSQL database cluster into a script file

  1011121314151617181920
• pg_isready Client applications

  pg_isready — check the connection status of a PostgreSQL server

  1011121314151617181920
• pg_receivewal Client applications

  pg_receivewal — stream write-ahead logs from a PostgreSQL server

  1011121314151617181920
• pg_recvlogical Client applications

  pg_recvlogical — control PostgreSQL logical decoding streams

  1011121314151617181920
• pg_restore Client applications

  pg_restore — restore a PostgreSQL database from an archive file created by pg_dump

  1011121314151617181920
• pg_verifybackup Client applications

  pg_verifybackup — verify the integrity of a base backup of a PostgreSQL cluster

  1011121314151617181920
• pgbench Client applications

  pgbench — run a benchmark test on PostgreSQL

  1011121314151617181920
• psql Client applications

  psql — PostgreSQL interactive terminal

  1011121314151617181920
• reindexdb Client applications

  reindexdb — reindex a PostgreSQL database

  1011121314151617181920
• vacuumdb Client applications

  vacuumdb — garbage-collect and analyze a PostgreSQL database

  1011121314151617181920
• initdb Server applications

  initdb — create a new PostgreSQL database cluster

  1011121314151617181920
• pg_archivecleanup Server applications

  pg_archivecleanup — clean up PostgreSQL WAL archive files

  1011121314151617181920
• pg_checksums Server applications

  pg_checksums — enable, disable or check data checksums in a PostgreSQL database cluster

  1011121314151617181920
• pg_controldata Server applications

  pg_controldata — display control information of a PostgreSQL database cluster

  1011121314151617181920
• pg_createsubscriber Server applications

  pg_createsubscriber — convert a physical replica into a new logical replica

  1011121314151617181920
• pg_ctl Server applications

  pg_ctl — initialize, start, stop, or control a PostgreSQL server

  1011121314151617181920
• pg_resetwal Server applications

  pg_resetwal — reset the write-ahead log and other control information of a PostgreSQL database cluster

  1011121314151617181920
• pg_rewind Server applications

  pg_rewind — synchronize a PostgreSQL data directory with another data directory that was forked from it

  1011121314151617181920
• pg_test_fsync Server applications

  pg_test_fsync — determine fastest wal_sync_method for PostgreSQL

  1011121314151617181920
• pg_test_timing Server applications

  pg_test_timing — measure timing overhead

  1011121314151617181920
• pg_upgrade Server applications

  pg_upgrade — upgrade a PostgreSQL server instance

  1011121314151617181920
• pg_verify_checksums Server applications not in 18

  Not recorded in the selected version.

  1011121314151617181920
• pg_waldump Server applications

  pg_waldump — display a human-readable rendering of the write-ahead log of a PostgreSQL database cluster

  1011121314151617181920
• pg_walsummary Server applications

  pg_walsummary — print contents of WAL summary files

  1011121314151617181920
• postgres Server applications

  postgres — PostgreSQL database server

  1011121314151617181920
• postmaster Server applications not in 18

  Not recorded in the selected version.

  1011121314151617181920

RecordedFirst recordedInterface or attribute changeNo longer recorded

Squares indicate presence in sampled builds, not first introduction. Select a square for the same-version definition and sources.

Changes in PostgreSQL 18.6 · Export JSON

Reading this collection

Options and examples belong to the selected program build. Client and server versions can differ; read the same-version compatibility notes before using a tool against another server.