Search PostgreSQL documentation

pg_checksumsCommand-line ToolsPG18pg_checksums pg_checksums — enable, disable or check data checksums in a PostgreSQL database cluster Synopsis pg_checksums [option...] [[ -D | --pgdata ]datadir]pg_checksums pg_checksums --checkCommand-line ToolsPG18-c--check Checks checksums. This is the default mode if nothing else is specified.pg_checksums › Options pg_checksums --disableCommand-line ToolsPG18-d--disable Disables checksums.pg_checksums › Options pg_checksums --enableCommand-line ToolsPG18-e--enable Enables checksums.pg_checksums › Options pg_checksums --filenode=filenodeCommand-line ToolsPG18-f filenode--filenode=filenode Only validate checksums in the relation with filenode filenode.pg_checksums › Options pg_checksums --helpCommand-line ToolsPG18-?--help Show help about pg_checksums command line arguments, and exit.pg_checksums › Options pg_checksums --no-syncCommand-line ToolsPG18-N--no-sync By default, pg_checksums will wait for all files to be written safely to disk. This option causes pg_checksums to return without waiting, which is faster, but means that a subseq…pg_checksums › Options pg_checksums --pgdata=directoryCommand-line ToolsPG18-D directory--pgdata=directory Specifies the directory where the database cluster is stored.pg_checksums › Options pg_checksums --progressCommand-line ToolsPG18-P--progress Enable progress reporting. Turning this on will deliver a progress report while checking or enabling checksums.pg_checksums › Options pg_checksums --sync-method=methodCommand-line ToolsPG18--sync-method=method When set to fsync, which is the default, pg_checksums will recursively open and synchronize all files in the data directory. The search for files will follow symbolic li…pg_checksums › Options pg_checksums --verboseCommand-line ToolsPG18-v--verbose Enable verbose output. Lists all checked files.pg_checksums › Options pg_checksums --versionCommand-line ToolsPG18-V--version Print the pg_checksums version and exit.pg_checksums › Options pg_combinebackupCommand-line ToolsPG18pg_combinebackup pg_combinebackup — reconstruct a full backup from an incremental backup and dependent backups Synopsis pg_combinebackup [option...] [backup_directory...]pg_combinebackup pg_combinebackup --cloneCommand-line ToolsPG18--clone Use efficient file cloning (also known as “reflinks” on some systems) instead of copying files to the new data directory, which can result in near-instantaneous copying of the data f…pg_combinebackup › Options pg_combinebackup --copyCommand-line ToolsPG18--copy Perform regular file copy. This is the default. (See also --copy-file-range, --clone, and -k/--link.)pg_combinebackup › Options pg_combinebackup --copy-file-rangeCommand-line ToolsPG18--copy-file-range Use the copy_file_range system call for efficient copying. On some file systems this gives results similar to --clone, sharing physical disk blocks, while on others it may …pg_combinebackup › Options pg_combinebackup --debugCommand-line ToolsPG18-d--debug Print lots of debug logging output on stderr.pg_combinebackup › Options 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_configCommand-line ToolsPG18pg_config pg_config — retrieve information about the installed version of PostgreSQL Synopsis pg_config [option...]pg_config 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