Search PostgreSQL documentation

pg_createsubscriber --publisher-server=connstrCommand-line ToolsPG18-P connstr--publisher-server=connstr The connection string to the publisher. For details see Section 32.1.1.pg_createsubscriber › Options pg_createsubscriber --recovery-timeout=secondsCommand-line ToolsPG18-t 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 › Options pg_createsubscriber --replication-slot=nameCommand-line ToolsPG18--replication-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 o…pg_createsubscriber › Options pg_createsubscriber --socketdir=dirCommand-line ToolsPG18-s dir--socketdir=dir The directory to use for postmaster sockets on target server. The default is current directory.pg_createsubscriber › Options pg_createsubscriber --subscriber-port=portCommand-line ToolsPG18-p 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 connecti…pg_createsubscriber › Options pg_createsubscriber --subscriber-username=usernameCommand-line ToolsPG18-U username--subscriber-username=username The user name to connect as on target server. Defaults to the current operating system user name.pg_createsubscriber › Options pg_createsubscriber --subscription=nameCommand-line ToolsPG18--subscription=name The subscription name to set up the logical replication. Multiple subscriptions can be specified by writing multiple --subscription switches. The number of subscription n…pg_createsubscriber › Options pg_createsubscriber --verboseCommand-line ToolsPG18-v--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 addi…pg_createsubscriber › Options pg_createsubscriber --versionCommand-line ToolsPG18-V--version Print the pg_createsubscriber version and exit.pg_createsubscriber › Options pg_credereumExtensionsExtensionsCryptographically verifiable database auditing backed by blockchain-style transaction blocks. pg_credereum SecuritySecurity · Extensions pg_cronExtensionsExtensionsJob scheduler for PostgreSQL pg_cron Time seriesTime series · Extensions pg_cron_helperExtensionsExtensionsExtension to help functionality of pg_cron pg_cron_helper Time seriesTime series · Extensions pg_cryogenExtensionsExtensionsExperimental append-only compressed table access method for PostgreSQL 12 and later. append-only compression table-access-method pg_cryogen AnalyticsAnalytics · Extensions pg_cryptoExtensionsExtensionsRust cryptography with pgcrypto-compatible and modern primitives cryptography hashing encryption pg_crypto SecuritySecurity · Extensions pg_cryptocurrencyExtensionsExtensionsNative blockchain asset, amount, address, and uint256 types blockchain asset exact-arithmetic pg_cryptocurrency Data typesData types · Extensions pg_csvExtensionsExtensionsFlexible CSV processing for Postgres pg_csv Functions and aggregatesFunctions and aggregates · Extensions pg_ctblmgrExtensionsExtensionsLogical Replication Based, Asynchronous Eager Materialized Views for PostgreSQL pg_ctblmgr FeaturesFeatures · Extensions pg_ctlCommand-line ToolsPG18pg_ctl pg_ctl — initialize, 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 second…pg_ctl pg_ctlManual ChaptersPG18pg_ctl pg_ctl — initialize, 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 second…pg_ctl pg_ctl --core-filesCommand-line ToolsPG18-c--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 debuggin…pg_ctl › Options pg_ctl --helpCommand-line ToolsPG18-?--help Show help about pg_ctl command line arguments, and exit.pg_ctl › Options pg_ctl --log=filenameCommand-line ToolsPG18-l 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 …pg_ctl › Options pg_ctl --mode=modeCommand-line ToolsPG18-m 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 › Options pg_ctl --no-waitCommand-line ToolsPG18-W--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 su…pg_ctl › Options pg_ctl --options=initdb-optionsCommand-line ToolsPG18-o 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. …pg_ctl › Options pg_ctl --options=optionsCommand-line ToolsPG18-o 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 …pg_ctl › Options pg_ctl --pgdata=datadirCommand-line ToolsPG18-D 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 › Options pg_ctl --silentCommand-line ToolsPG18-s--silent Print only errors, no informational messages.pg_ctl › Options pg_ctl --timeout=secondsCommand-line ToolsPG18-t 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 v…pg_ctl › Options pg_ctl --versionCommand-line ToolsPG18-V--version Print the pg_ctl version and exit.pg_ctl › Options pg_ctl --waitCommand-line ToolsPG18-w--wait Wait for the operation to complete. This is supported for the modes start, stop, restart, promote, and register, and is the default for those modes. When waiting, pg_ctl repeatedly …pg_ctl › Options pg_ctl -e sourceCommand-line ToolsPG18-e source Name of the event source for pg_ctl to use for logging to the event log when running as a Windows service. The default is PostgreSQL. Note that this only controls messages sent fro…pg_ctl › Options › Options for Windows pg_ctl -N servicenameCommand-line ToolsPG18-N servicename Name of the system service to register. This name will be used as both the service name and the display name. The default is PostgreSQL.pg_ctl › Options › Options for Windows pg_ctl -P passwordCommand-line ToolsPG18-P password Password for the user to run the service as.pg_ctl › Options › Options for Windows pg_ctl -p pathCommand-line ToolsPG18-p path Specifies the location of the postgres executable. By default the postgres executable is taken from the same directory as pg_ctl, or failing that, the hard-wired installation directo…pg_ctl › Options pg_ctl -S start-typeCommand-line ToolsPG18-S start-type Start type of the system service. start-type can be auto, or demand, or the first letter of one of these two. If this option is omitted, auto is the default.pg_ctl › Options › Options for Windows pg_ctl -U usernameCommand-line ToolsPG18-U username User name for the user to run the service as. For domain users, use the format DOMAIN\username.pg_ctl › Options › Options for Windows pg_curlExtensionsExtensionsRun curl actions for data transfer in URL syntax pg_curl UtilitiesUtilities · Extensions pg_current_logfileFunctionsReferencepg_current_logfile System Information Functions And Operators 10 Primary log file name, or log in the requested format, currently in use by the logging collector pg_current_logfile ( [text] …Functions · System Information Functions And Operators pg_current_snapshotFunctionsReferencepg_current_snapshot System Information Functions And Operators 13 Returns a current snapshot, a data structure showing which transaction IDs are now in-progress. pg_current_snapshot () → pg_…Functions · System Information Functions And Operators