Search PostgreSQL documentation

pg_config --ldflags_exCommand-line ToolsPG18--ldflags_ex Print the value of the LDFLAGS_EX variable that was used for building PostgreSQL. This shows linker switches used for building executables only.pg_config › Options pg_config --ldflags_slCommand-line ToolsPG18--ldflags_sl Print the value of the LDFLAGS_SL variable that was used for building PostgreSQL. This shows linker switches used for building shared libraries only.pg_config › Options pg_config --libdirCommand-line ToolsPG18--libdir Print the location of object code libraries.pg_config › Options pg_config --libsCommand-line ToolsPG18--libs Print the value of the LIBS variable that was used for building PostgreSQL. This normally contains -l switches for external libraries linked into PostgreSQL.pg_config › Options pg_config --localedirCommand-line ToolsPG18--localedir Print the location of locale support files. (This will be an empty string if locale support was not configured when PostgreSQL was built.)pg_config › Options pg_config --mandirCommand-line ToolsPG18--mandir Print the location of manual pages.pg_config › Options pg_config --pgxsCommand-line ToolsPG18--pgxs Print the location of extension makefiles.pg_config › Options pg_config --pkgincludedirCommand-line ToolsPG18--pkgincludedir Print the location of other C header files.pg_config › Options pg_config --pkglibdirCommand-line ToolsPG18--pkglibdir Print the location of dynamically loadable modules, or where the server would search for them. (Other architecture-dependent data files might also be installed in this directory.…pg_config › Options pg_config --sharedirCommand-line ToolsPG18--sharedir Print the location of architecture-independent support files.pg_config › Options pg_config --sysconfdirCommand-line ToolsPG18--sysconfdir Print the location of system-wide configuration files.pg_config › Options pg_config --versionCommand-line ToolsPG18--version Print the version of PostgreSQL.pg_config › Options pg_controldataCommand-line ToolsPG18pg_controldata pg_controldata — display control information of a PostgreSQL database cluster Synopsis pg_controldata [option] [[ -D | --pgdata ]datadir]pg_controldata pg_createsubscriberCommand-line ToolsPG18pg_createsubscriber pg_createsubscriber — convert a physical replica into a new logical replica Synopsis pg_createsubscriber [option...] { -d | --database }dbname { -D | --pgdata }datadir { …pg_createsubscriber pg_createsubscriber --allCommand-line ToolsPG18-a--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, connec…pg_createsubscriber › Options pg_createsubscriber --clean=objtypeCommand-line ToolsPG18--clean=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…pg_createsubscriber › Options pg_createsubscriber --config-file=filenameCommand-line ToolsPG18--config-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 ser…pg_createsubscriber › Options pg_createsubscriber --database=dbnameCommand-line ToolsPG18-d 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 › Options pg_createsubscriber --dry-runCommand-line ToolsPG18-n--dry-run Do everything except actually modifying the target directory.pg_createsubscriber › Options pg_createsubscriber --enable-two-phaseCommand-line ToolsPG18-T--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 …pg_createsubscriber › Options pg_createsubscriber --helpCommand-line ToolsPG18-?--help Show help about pg_createsubscriber command line arguments, and exit.pg_createsubscriber › Options pg_createsubscriber --pgdata=directoryCommand-line ToolsPG18-D directory--pgdata=directory The target directory that contains a cluster directory from a physical replica.pg_createsubscriber › Options pg_createsubscriber --publication=nameCommand-line ToolsPG18--publication=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 …pg_createsubscriber › Options 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_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_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