Search PostgreSQL documentation

pg_combinebackup --no-syncCommand-line ToolsPG18pg_combinebackup › OptionsN--no-sync By default, pg_combinebackup will wait for all files to be written safely to disk. This option causes pg_combinebackup to return without waiting, which is faster, but means that a… pg_combinebackup --output=outputdirCommand-line ToolsPG18pg_combinebackup › Optionso outputdir--output=outputdir Specifies the output directory to which the synthetic full backup should be written. Currently, this argument is required. pg_combinebackup --sync-method=methodCommand-line ToolsPG18pg_combinebackup › Optionssync-method=method When set to fsync, which is the default, pg_combinebackup will recursively open and synchronize all files in the backup directory. When the plain format is used, the searc… pg_combinebackup --tablespace-mapping=olddir=newdirCommand-line ToolsPG18pg_combinebackup › OptionsT olddir=newdir--tablespace-mapping=olddir=newdir Relocates the tablespace in directory olddir to newdir during the backup. olddir is the absolute path of the tablespace as it exists in the … pg_combinebackup --versionCommand-line ToolsPG18pg_combinebackup › OptionsV--version Prints the pg_combinebackup version and exits. pg_command_fwExtensionsExtensionsSecurity · ExtensionsDDL and utility command firewall for PostgreSQL pg_command_fw Security pg_comment_statsExtensionsExtensionsMonitoring · ExtensionsAggregate resource usage by key-value annotations in SQL comments statistics query comments pg_comment_stats Monitoring pg_concurrency_controlExtensionsExtensionsAdministration · ExtensionsConcurrency control plug-in for Alibaba Cloud ApsaraDB RDS PostgreSQL pg_concurrency_control Administration pg_condaExtensionsExtensionsData types · ExtensionsPostgreSQL extension adding conda ecosystem version types, aggregates, and functions. conda data-type pgrx pg_conda Data types pg_configCommand-line ToolsPG18retrieve information about the installed version of PostgreSQL Synopsis pg_config [option...] pg_configManual ChaptersPG18retrieve information about the installed version of PostgreSQL Synopsis pg_config [option...] pg_configManual ChaptersPG18The view pg_config describes the compile-time configuration parameters of the currently installed version of PostgreSQL. It is intended, for example, to be used by software packages that wan… pg_config --bindirCommand-line ToolsPG18pg_config › Optionsbindir Print the location of user executables. Use this, for example, to find the psql program. This is normally also the location where the pg_config program resides. pg_config --ccCommand-line ToolsPG18pg_config › Optionscc Print the value of the CC variable that was used for building PostgreSQL. This shows the C compiler used. pg_config --cflagsCommand-line ToolsPG18pg_config › Optionscflags Print the value of the CFLAGS variable that was used for building PostgreSQL. This shows C compiler switches. pg_config --cflags_slCommand-line ToolsPG18pg_config › Optionscflags_sl Print the value of the CFLAGS_SL variable that was used for building PostgreSQL. This shows extra C compiler switches used for building shared libraries. pg_config --configureCommand-line ToolsPG18pg_config › Optionsconfigure Print the options that were given to the configure script when PostgreSQL was configured for building. This can be used to reproduce the identical configuration, or to find out wit… pg_config --cppflagsCommand-line ToolsPG18pg_config › Optionscppflags Print the value of the CPPFLAGS variable that was used for building PostgreSQL. This shows C compiler switches needed at preprocessing time (typically, -I switches). pg_config --docdirCommand-line ToolsPG18pg_config › Optionsdocdir Print the location of documentation files. pg_config --helpCommand-line ToolsPG18pg_config › Options?--help Show help about pg_config command line arguments, and exit. pg_config --htmldirCommand-line ToolsPG18pg_config › Optionshtmldir Print the location of HTML documentation files. pg_config --includedirCommand-line ToolsPG18pg_config › Optionsincludedir Print the location of C header files of the client interfaces. pg_config --includedir-serverCommand-line ToolsPG18pg_config › Optionsincludedir-server Print the location of C header files for server programming. pg_config --ldflagsCommand-line ToolsPG18pg_config › Optionsldflags Print the value of the LDFLAGS variable that was used for building PostgreSQL. This shows linker switches. pg_config --ldflags_exCommand-line ToolsPG18pg_config › Optionsldflags_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 --ldflags_slCommand-line ToolsPG18pg_config › Optionsldflags_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 --libdirCommand-line ToolsPG18pg_config › Optionslibdir Print the location of object code libraries. pg_config --libsCommand-line ToolsPG18pg_config › Optionslibs 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 --localedirCommand-line ToolsPG18pg_config › Optionslocaledir 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 --mandirCommand-line ToolsPG18pg_config › Optionsmandir Print the location of manual pages. pg_config --pgxsCommand-line ToolsPG18pg_config › Optionspgxs Print the location of extension makefiles. pg_config --pkgincludedirCommand-line ToolsPG18pg_config › Optionspkgincludedir Print the location of other C header files. pg_config --pkglibdirCommand-line ToolsPG18pg_config › Optionspkglibdir 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 --sharedirCommand-line ToolsPG18pg_config › Optionssharedir Print the location of architecture-independent support files. pg_config --sysconfdirCommand-line ToolsPG18pg_config › Optionssysconfdir Print the location of system-wide configuration files. pg_config --versionCommand-line ToolsPG18pg_config › Optionsversion Print the version of PostgreSQL. pg_conn2ExtensionsExtensionsForeign data wrappers · ExtensionsManage separate PostgreSQL database connections from SQL code pg_conn2 Foreign data wrappers pg_connlimitExtensionsExtensionsAdministration · ExtensionsLimits per-role connection counts from filesystem configuration without catalog access. pg_connlimit Administration pg_constraintManual ChaptersPG18The catalog pg_constraint stores check, not-null, primary key, unique, foreign key, and exclusion constraints on tables. (Column constraints are not treated specially. Every column constrain… pg_consulExtensionsExtensionsUtilities · ExtensionsC++ PostgreSQL extension exposing SQL functions for Consul status, catalog, and key-value APIs. consul key-value service-discovery pg_consul Utilities