Wiki / Command-line Tools

Definitions for PostgreSQL 18

• clusterdbClient applications10 – 20

  clusterdb — cluster a PostgreSQL database

  1011121314151617181920
• createdbClient applications10 – 20

  createdb — create a new PostgreSQL database

  1011121314151617181920
• createuserClient applications10 – 20

  createuser — define a new PostgreSQL user account

  1011121314151617181920
• dropdbClient applications10 – 20

  dropdb — remove a PostgreSQL database

  1011121314151617181920
• dropuserClient applications10 – 20

  dropuser — remove a PostgreSQL user account

  1011121314151617181920
• ecpgClient applications10 – 20

  ecpg — embedded SQL C preprocessor

  1011121314151617181920
• initdbServer applications10 – 20

  initdb — create a new PostgreSQL database cluster

  1011121314151617181920
• pg_amcheckClient applications14 – 20

  pg_amcheck — checks for corruption in one or more PostgreSQL databases

  1011121314151617181920
• pg_archivecleanupServer applications10 – 20

  pg_archivecleanup — clean up PostgreSQL WAL archive files

  1011121314151617181920
• pg_basebackupClient applications10 – 20

  pg_basebackup — take a base backup of a PostgreSQL cluster

  1011121314151617181920
• pg_checksumsServer applications12 – 20

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

  1011121314151617181920
• pg_combinebackupClient applications17 – 20

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

  1011121314151617181920
• pg_configClient applications10 – 20

  pg_config — retrieve information about the installed version of PostgreSQL

  1011121314151617181920
• pg_controldataServer applications10 – 20

  pg_controldata — display control information of a PostgreSQL database cluster

  1011121314151617181920
• pg_createsubscriberServer applications17 – 20

  pg_createsubscriber — convert a physical replica into a new logical replica

  1011121314151617181920
• pg_ctlServer applications10 – 20

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

  1011121314151617181920
• pg_dumpClient applications10 – 20

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

  1011121314151617181920
• pg_dumpallClient applications10 – 20

  pg_dumpall — extract a PostgreSQL database cluster into a script file

  1011121314151617181920
• pg_isreadyClient applications10 – 20

  pg_isready — check the connection status of a PostgreSQL server

  1011121314151617181920
• pg_receivewalClient applications10 – 20

  pg_receivewal — stream write-ahead logs from a PostgreSQL server

  1011121314151617181920
• pg_recvlogicalClient applications10 – 20

  pg_recvlogical — control PostgreSQL logical decoding streams

  1011121314151617181920
• pg_resetwalServer applications10 – 20

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

  1011121314151617181920
• pg_restoreClient applications10 – 20

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

  1011121314151617181920
• pg_rewindServer applications10 – 20

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

  1011121314151617181920
• pg_test_fsyncServer applications10 – 20

  pg_test_fsync — determine fastest wal_sync_method for PostgreSQL

  1011121314151617181920
• pg_test_timingServer applications10 – 20

  pg_test_timing — measure timing overhead

  1011121314151617181920
• pg_upgradeServer applications10 – 20

  pg_upgrade — upgrade a PostgreSQL server instance

  1011121314151617181920
• pg_verifybackupClient applications13 – 20

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

  1011121314151617181920
• pg_waldumpServer applications10 – 20

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

  1011121314151617181920
• pg_walsummaryServer applications17 – 20

  pg_walsummary — print contents of WAL summary files

  1011121314151617181920
• pgbenchClient applications10 – 20

  pgbench — run a benchmark test on PostgreSQL

  1011121314151617181920
• postgresServer applications10 – 20

  postgres — PostgreSQL database server

  1011121314151617181920
• psqlClient applications10 – 20

  psql — PostgreSQL interactive terminal

  1011121314151617181920
• reindexdbClient applications10 – 20

  reindexdb — reindex a PostgreSQL database

  1011121314151617181920
• vacuumdbClient applications10 – 20

  vacuumdb — garbage-collect and analyze a PostgreSQL database

  1011121314151617181920