Search PostgreSQL documentation

pg_contextdumpExtensionsExtensionsMonitoring · ExtensionsReports allocated-memory statistics for PostgreSQL memory contexts. pg_memorydump Monitoring pg_control_priorityExtensionsExtensionsAdministration · ExtensionsControls scheduling priorities (nice values) of PostgreSQL server processes. process-control resource-management pg_control_priority Administration pg_controldataCommand-line ToolsPG18display control information of a PostgreSQL database cluster Synopsis pg_controldata [option] [[ -D | --pgdata ]datadir] pg_controldataManual ChaptersPG18display control information of a PostgreSQL database cluster Synopsis pg_controldata [option] [[ -D | --pgdata ]datadir] pg_conversionManual ChaptersPG18The catalog pg_conversion describes encoding conversion functions. See CREATE CONVERSION for more information. Table 52.14. pg_conversion Columns Column Type Description oid oid Row identifi… pg_cooldownExtensionsExtensionsAdministration · Extensionsremove buffered pages for specific relations pg_cooldown Administration pg_coredumpExtensionsExtensionsAdministration · ExtensionsEasier core dump collection for PostgreSQL pg_coredump Administration pg_crashExtensionsExtensionsAdministration · ExtensionsSend random signals to random processes pg_crash Administration pg_crasherExtensionsExtensionsFeatures · ExtensionsProvides a function that intentionally crashes a PostgreSQL backend for client error-handling tests. crash error-handling testing pg_crasher Features pg_crdt_jsonbExtensionsExtensionsData types · ExtensionsConflict-free replicated data type operations for PostgreSQL jsonb values. pg_crdt_jsonb Data types pg_createsubscriberCommand-line ToolsPG18convert a physical replica into a new logical replica Synopsis pg_createsubscriber [option...] { -d | --database }dbname { -D | --pgdata }datadir { -P | --publisher-server }connstr pg_createsubscriberManual ChaptersPG18convert a physical replica into a new logical replica Synopsis pg_createsubscriber [option...] { -d | --database }dbname { -D | --pgdata }datadir { -P | --publisher-server }connstr pg_createsubscriber --allCommand-line ToolsPG18pg_createsubscriber › Optionsa--all Create one subscription per database on the target server. Exceptions are template databases and databases that don't allow connections. To discover the list of all databases, connect… pg_createsubscriber --clean=objtypeCommand-line ToolsPG18pg_createsubscriber › Optionsclean=objtype Drop all objects of the specified type from specified databases on the target server. publications: The FOR ALL TABLES publications established for this subscriber are always d… pg_createsubscriber --config-file=filenameCommand-line ToolsPG18pg_createsubscriber › Optionsconfig-file=filename Use the specified main server configuration file for the target data directory. pg_createsubscriber internally uses the pg_ctl command to start and stop the target serve… pg_createsubscriber --database=dbnameCommand-line ToolsPG18pg_createsubscriber › Optionsd dbname--database=dbname The name of the database in which to create a subscription. Multiple databases can be selected by writing multiple -d switches. This option cannot be used together … pg_createsubscriber --dry-runCommand-line ToolsPG18pg_createsubscriber › Optionsn--dry-run Do everything except actually modifying the target directory. pg_createsubscriber --enable-two-phaseCommand-line ToolsPG18pg_createsubscriber › OptionsT--enable-two-phase Enables two_phase commit for the subscription. When multiple databases are specified, this option applies uniformly to all subscriptions created on those databases. The d… pg_createsubscriber --helpCommand-line ToolsPG18pg_createsubscriber › Options?--help Show help about pg_createsubscriber command line arguments, and exit. pg_createsubscriber --pgdata=directoryCommand-line ToolsPG18pg_createsubscriber › OptionsD directory--pgdata=directory The target directory that contains a cluster directory from a physical replica. pg_createsubscriber --publication=nameCommand-line ToolsPG18pg_createsubscriber › Optionspublication=name The publication name to set up the logical replication. Multiple publications can be specified by writing multiple --publication switches. The number of publication names mu… pg_createsubscriber --publisher-server=connstrCommand-line ToolsPG18pg_createsubscriber › OptionsP connstr--publisher-server=connstr The connection string to the publisher. For details see Section 32.1.1. pg_createsubscriber --recovery-timeout=secondsCommand-line ToolsPG18pg_createsubscriber › Optionst seconds--recovery-timeout=seconds The maximum number of seconds to wait for recovery to end. Setting to 0 disables. The default is 0. pg_createsubscriber --replication-slot=nameCommand-line ToolsPG18pg_createsubscriber › Optionsreplication-slot=name The replication slot name to set up the logical replication. Multiple replication slots can be specified by writing multiple --replication-slot switches. The number of … pg_createsubscriber --socketdir=dirCommand-line ToolsPG18pg_createsubscriber › Optionss dir--socketdir=dir The directory to use for postmaster sockets on target server. The default is current directory. pg_createsubscriber --subscriber-port=portCommand-line ToolsPG18pg_createsubscriber › Optionsp port--subscriber-port=port The port number on which the target server is listening for connections. Defaults to running the target server on port 50432 to avoid unintended client connectio… pg_createsubscriber --subscriber-username=usernameCommand-line ToolsPG18pg_createsubscriber › OptionsU username--subscriber-username=username The user name to connect as on target server. Defaults to the current operating system user name. pg_createsubscriber --subscription=nameCommand-line ToolsPG18pg_createsubscriber › Optionssubscription=name The subscription name to set up the logical replication. Multiple subscriptions can be specified by writing multiple --subscription switches. The number of subscription nam… pg_createsubscriber --verboseCommand-line ToolsPG18pg_createsubscriber › Optionsv--verbose Enables verbose mode. This will cause pg_createsubscriber to output progress messages and detailed information about each step to standard error. Repeating the option causes addit… pg_createsubscriber --versionCommand-line ToolsPG18pg_createsubscriber › OptionsV--version Print the pg_createsubscriber version and exit. pg_credereumExtensionsExtensionsSecurity · ExtensionsCryptographically verifiable database auditing backed by blockchain-style transaction blocks. pg_credereum Security pg_cronExtensionsExtensionsTime series · ExtensionsJob scheduler for PostgreSQL pg_cron Time series pg_cron_helperExtensionsExtensionsTime series · ExtensionsExtension to help functionality of pg_cron pg_cron_helper Time series pg_cryogenExtensionsExtensionsAnalytics · ExtensionsExperimental append-only compressed table access method for PostgreSQL 12 and later. append-only compression table-access-method pg_cryogen Analytics pg_cryptoExtensionsExtensionsSecurity · ExtensionsRust cryptography with pgcrypto-compatible and modern primitives cryptography hashing encryption pg_crypto Security pg_cryptocurrencyExtensionsExtensionsData types · ExtensionsNative blockchain asset, amount, address, and uint256 types blockchain asset exact-arithmetic pg_cryptocurrency Data types pg_csvExtensionsExtensionsFunctions and aggregates · ExtensionsFlexible CSV processing for Postgres pg_csv Functions and aggregates pg_ctblmgrExtensionsExtensionsFeatures · ExtensionsLogical Replication Based, Asynchronous Eager Materialized Views for PostgreSQL pg_ctblmgr Features pg_ctlCommand-line ToolsPG18initialize, start, stop, or control a PostgreSQL server Synopsis pg_ctl init[db] [-D datadir] [-s] [-o initdb-options] pg_ctl start [-D datadir] [-l filename] [-W] [-t seconds] [-s] [-o opti… pg_ctlManual ChaptersPG18initialize, start, stop, or control a PostgreSQL server Synopsis pg_ctl init[db] [-D datadir] [-s] [-o initdb-options] pg_ctl start [-D datadir] [-l filename] [-W] [-t seconds] [-s] [-o opti…