Search PostgreSQL documentation

pg_verifybackupCommand-line ToolsPG18pg_verifybackup pg_verifybackup — verify the integrity of a base backup of a PostgreSQL cluster Synopsis pg_verifybackup [option...]pg_verifybackup pg_verifybackup --exit-on-errorCommand-line ToolsPG18-e--exit-on-error Exit as soon as a problem with the backup is detected. If this option is not specified, pg_verifybackup will continue checking the backup even after a problem has been dete…pg_verifybackup › Options pg_verifybackup --format=formatCommand-line ToolsPG18-F format--format=format Specifies the format of the backup. format can be one of the following: pplain Backup consists of plain files with the same layout as the source server's data direct…pg_verifybackup › Options pg_verifybackup --helpCommand-line ToolsPG18-?--help Show help about pg_verifybackup command line arguments, and exit.pg_verifybackup › Options pg_verifybackup --ignore=pathCommand-line ToolsPG18-i path--ignore=path Ignore the specified file or directory, which should be expressed as a relative path name, when comparing the list of data files actually present in the backup to those …pg_verifybackup › Options pg_verifybackup --manifest-path=pathCommand-line ToolsPG18-m path--manifest-path=path Use the manifest file at the specified path, rather than one located in the root of the backup directory.pg_verifybackup › Options pg_verifybackup --no-parse-walCommand-line ToolsPG18-n--no-parse-wal Don't attempt to parse write-ahead log data that will be needed to recover from this backup.pg_verifybackup › Options pg_verifybackup --progressCommand-line ToolsPG18-P--progress Enable progress reporting. Turning this on will deliver a progress report while verifying checksums. This option cannot be used together with the option --quiet.pg_verifybackup › Options pg_verifybackup --quietCommand-line ToolsPG18-q--quiet Don't print anything when a backup is successfully verified.pg_verifybackup › Options pg_verifybackup --skip-checksumsCommand-line ToolsPG18-s--skip-checksums Do not verify data file checksums. The presence or absence of files and the sizes of those files will still be checked. This is much faster, because the files themselves d…pg_verifybackup › Options pg_verifybackup --versionCommand-line ToolsPG18-V--version Print the pg_verifybackup version and exit.pg_verifybackup › Options pg_verifybackup --wal-directory=pathCommand-line ToolsPG18-w path--wal-directory=path Try to parse WAL files stored in the specified directory, rather than in pg_wal. This may be useful if the backup is stored in a separate location from the WAL ar…pg_verifybackup › Options pg_walsummaryCommand-line ToolsPG18pg_walsummary pg_walsummary — print contents of WAL summary files Synopsis pg_walsummary [option...] [file...]pg_walsummary pg_walsummary --helpCommand-line ToolsPG18-?--help Shows help about pg_walsummary command line arguments, and exits.pg_walsummary › Options pg_walsummary --individualCommand-line ToolsPG18-i--individual By default, pg_walsummary prints one line of output for each range of one or more consecutive modified blocks. This can make the output a lot briefer, since a relation where a…pg_walsummary › Options pg_walsummary --quietCommand-line ToolsPG18-q--quiet Do not print any output, except for errors. This can be useful when you want to know whether a WAL summary file can be successfully parsed but don't care about the contents.pg_walsummary › Options pg_walsummary --versionCommand-line ToolsPG18-V--version Display version information, then exit.pg_walsummary › Options PGAPPNAMECommand-line ToolsPG18PGAPPNAME behaves the same as the application_name connection parameter.Environment Variables PGCHANNELBINDINGCommand-line ToolsPG18PGCHANNELBINDING behaves the same as the channel_binding connection parameter.Environment Variables PGCLIENTENCODINGCommand-line ToolsPG18PGCLIENTENCODING behaves the same as the client_encoding connection parameter.Environment Variables PGCONNECT_TIMEOUTCommand-line ToolsPG18PGCONNECT_TIMEOUT behaves the same as the connect_timeout connection parameter.Environment Variables PGDATABASECommand-line ToolsPG18PGDATABASE behaves the same as the dbname connection parameter.Environment Variables PGDATESTYLECommand-line ToolsPG18PGDATESTYLE sets the default style of date/time representation. (Equivalent to SET datestyle TO ....)Environment Variables PGGEQOCommand-line ToolsPG18PGGEQO sets the default mode for the genetic query optimizer. (Equivalent to SET geqo TO ....)Environment Variables PGGSSDELEGATIONCommand-line ToolsPG18PGGSSDELEGATION behaves the same as the gssdelegation connection parameter.Environment Variables PGGSSENCMODECommand-line ToolsPG18PGGSSENCMODE behaves the same as the gssencmode connection parameter.Environment Variables PGGSSLIBCommand-line ToolsPG18PGGSSLIB behaves the same as the gsslib connection parameter.Environment Variables PGHOSTCommand-line ToolsPG18PGHOST behaves the same as the host connection parameter.Environment Variables PGHOSTADDRCommand-line ToolsPG18PGHOSTADDR behaves the same as the hostaddr connection parameter. This can be set instead of or in addition to PGHOST to avoid DNS lookup overhead.Environment Variables PGKRBSRVNAMECommand-line ToolsPG18PGKRBSRVNAME behaves the same as the krbsrvname connection parameter.Environment Variables PGLOADBALANCEHOSTSCommand-line ToolsPG18PGLOADBALANCEHOSTS behaves the same as the load_balance_hosts connection parameter.Environment Variables PGLOCALEDIRCommand-line ToolsPG18PGLOCALEDIR sets the directory containing the locale files for message localization.Environment Variables PGMAXPROTOCOLVERSIONCommand-line ToolsPG18PGMAXPROTOCOLVERSION behaves the same as the max_protocol_version connection parameter.Environment Variables PGMINPROTOCOLVERSIONCommand-line ToolsPG18PGMINPROTOCOLVERSION behaves the same as the min_protocol_version connection parameter.Environment Variables PGOPTIONSCommand-line ToolsPG18PGOPTIONS behaves the same as the options connection parameter.Environment Variables PGPASSFILECommand-line ToolsPG18PGPASSFILE behaves the same as the passfile connection parameter.Environment Variables PGPASSWORDCommand-line ToolsPG18PGPASSWORD behaves the same as the password connection parameter. Use of this environment variable is not recommended for security reasons, as some operating systems allow non-root users to …Environment Variables PGPORTCommand-line ToolsPG18PGPORT behaves the same as the port connection parameter.Environment Variables PGREQUIREAUTHCommand-line ToolsPG18PGREQUIREAUTH behaves the same as the require_auth connection parameter.Environment Variables PGREQUIREPEERCommand-line ToolsPG18PGREQUIREPEER behaves the same as the requirepeer connection parameter.Environment Variables