Search PostgreSQL documentation

pg_combinebackup --dry-runCommand-line ToolsPG18-n--dry-run The -n/--dry-run option instructs pg_combinebackup to figure out what would be done without actually creating the target directory or any output files. It is particularly useful …pg_combinebackup › Options pg_combinebackup --helpCommand-line ToolsPG18-?--help Shows help about pg_combinebackup command line arguments, and exits.pg_combinebackup › Options pg_combinebackup --linkCommand-line ToolsPG18-k--link Use hard links instead of copying files to the synthetic backup. Reconstruction of the synthetic backup might be faster (no file copying) and use less disk space, but care must be t…pg_combinebackup › Options pg_combinebackup --manifest-checksums=algorithmCommand-line ToolsPG18--manifest-checksums=algorithm Like pg_basebackup, pg_combinebackup writes a backup manifest in the output directory. This option specifies the checksum algorithm that should be applied to e…pg_combinebackup › Options pg_combinebackup --no-manifestCommand-line ToolsPG18--no-manifest Disables generation of a backup manifest. If this option is not specified, a backup manifest for the reconstructed backup will be written to the output directory.pg_combinebackup › Options pg_combinebackup --no-syncCommand-line ToolsPG18-N--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 …pg_combinebackup › Options pg_combinebackup --output=outputdirCommand-line ToolsPG18-o outputdir--output=outputdir Specifies the output directory to which the synthetic full backup should be written. Currently, this argument is required.pg_combinebackup › Options pg_combinebackup --sync-method=methodCommand-line ToolsPG18--sync-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 sea…pg_combinebackup › Options pg_combinebackup --tablespace-mapping=olddir=newdirCommand-line ToolsPG18-T 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 › Options pg_combinebackup --versionCommand-line ToolsPG18-V--version Prints the pg_combinebackup version and exits.pg_combinebackup › Options pg_command_fwExtensionsExtensionsDDL and utility command firewall for PostgreSQL pg_command_fw SecuritySecurity · Extensions pg_comment_statsExtensionsExtensionsAggregate resource usage by key-value annotations in SQL comments statistics query comments pg_comment_stats MonitoringMonitoring · Extensions pg_concurrency_controlExtensionsExtensionsConcurrency control plug-in for Alibaba Cloud ApsaraDB RDS PostgreSQL pg_concurrency_control AdministrationAdministration · Extensions pg_condaExtensionsExtensionsPostgreSQL extension adding conda ecosystem version types, aggregates, and functions. conda data-type pgrx pg_conda Data typesData types · Extensions pg_conf_load_timeFunctionsReferencepg_conf_load_time System Information Functions And Operators 10 configuration load time pg_conf_load_time ( ) → timestamp with time zone configuration load time 11 12 13 Returns the time whe…Functions · System Information Functions And Operators pg_configCommand-line ToolsPG18pg_config pg_config — retrieve information about the installed version of PostgreSQL Synopsis pg_config [option...]pg_config pg_configManual ChaptersPG18pg_config pg_config — retrieve information about the installed version of PostgreSQL Synopsis pg_config [option...]pg_config pg_configManual ChaptersPG1853.6. pg_config The 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 p…pg_config pg_configCatalogs & ViewsReferencepg_config System views 10 The 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 …System Catalogs · System views pg_config --bindirCommand-line ToolsPG18--bindir 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 › Options pg_config --ccCommand-line ToolsPG18--cc Print the value of the CC variable that was used for building PostgreSQL. This shows the C compiler used.pg_config › Options pg_config --cflagsCommand-line ToolsPG18--cflags Print the value of the CFLAGS variable that was used for building PostgreSQL. This shows C compiler switches.pg_config › Options pg_config --cflags_slCommand-line ToolsPG18--cflags_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 › Options pg_config --configureCommand-line ToolsPG18--configure 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 w…pg_config › Options pg_config --cppflagsCommand-line ToolsPG18--cppflags 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 › Options pg_config --docdirCommand-line ToolsPG18--docdir Print the location of documentation files.pg_config › Options pg_config --helpCommand-line ToolsPG18-?--help Show help about pg_config command line arguments, and exit.pg_config › Options pg_config --htmldirCommand-line ToolsPG18--htmldir Print the location of HTML documentation files.pg_config › Options pg_config --includedirCommand-line ToolsPG18--includedir Print the location of C header files of the client interfaces.pg_config › Options pg_config --includedir-serverCommand-line ToolsPG18--includedir-server Print the location of C header files for server programming.pg_config › Options pg_config --ldflagsCommand-line ToolsPG18--ldflags Print the value of the LDFLAGS variable that was used for building PostgreSQL. This shows linker switches.pg_config › Options 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