Search PostgreSQL documentation

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_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_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… pg_ctl --core-filesCommand-line ToolsPG18pg_ctl › Optionsc--core-files Attempt to allow server crashes to produce core files, on platforms where this is possible, by lifting any soft resource limit placed on core files. This is useful in debugging… pg_ctl --helpCommand-line ToolsPG18pg_ctl › Options?--help Show help about pg_ctl command line arguments, and exit. pg_ctl --log=filenameCommand-line ToolsPG18pg_ctl › Optionsl filename--log=filename Append the server log output to filename. If the file does not exist, it is created. By default, only the cluster owner can access the log file. If group access is e… pg_ctl --mode=modeCommand-line ToolsPG18pg_ctl › Optionsm mode--mode=mode Specifies the shutdown mode. mode can be smart, fast, or immediate, or the first letter of one of these three. If this option is omitted, fast is the default. pg_ctl --no-waitCommand-line ToolsPG18pg_ctl › OptionsW--no-wait Do not wait for the operation to complete. This is the opposite of the option -w. If waiting is disabled, the requested action is triggered, but there is no feedback about its suc… pg_ctl --options=initdb-optionsCommand-line ToolsPG18pg_ctl › Optionso initdb-options--options=initdb-options Specifies options to be passed directly to the initdb command. -o can be specified multiple times, with all the given options being passed through. T… pg_ctl --options=optionsCommand-line ToolsPG18pg_ctl › Optionso options--options=options Specifies options to be passed directly to the postgres command. -o can be specified multiple times, with all the given options being passed through. The options s… pg_ctl --pgdata=datadirCommand-line ToolsPG18pg_ctl › OptionsD datadir--pgdata=datadir Specifies the file system location of the database configuration files. If this option is omitted, the environment variable PGDATA is used. pg_ctl --silentCommand-line ToolsPG18pg_ctl › Optionss--silent Print only errors, no informational messages. pg_ctl --timeout=secondsCommand-line ToolsPG18pg_ctl › Optionst seconds--timeout=seconds Specifies the maximum number of seconds to wait when waiting for an operation to complete (see option -w). Defaults to the value of the PGCTLTIMEOUT environment va…