PostgreSQL

PostgreSQL Elephant Logo

pg_verify_checksums

pg_verify_checksums — verify data checksums in a PostgreSQL database cluster

Synopsis

pg_verify_checksums [`option…​] [[ `-D | --pgdata ] `datadir`]

Description

pg_verify_checksums verifies data checksums in a PostgreSQL cluster. The server must be shut down cleanly before running pg_verify_checksums. The exit status is zero if there are no checksum errors, otherwise nonzero.

Options

The following command-line options are available:

+-D +`+directory+
#[.term]
+--pgdata=`_`+directory:: Specifies the directory where the database cluster is stored. [.term]-v`
[.term]--verbose:: Enable verbose output. Lists all checked files. [.term]+-r +`
+relfilenode+_#:: Only validate checksums in the relation with specified relfilenode. +-V+`
#[.term]--version:: Print the pg_verify_checksums version and exit. [.term]-?
[.term]--help#:: Show help about pg_verify_checksums command line arguments, and exit.

Environment

PGDATA

Specifies the directory where the database cluster is stored; can be overridden using the -D option.


Prev Up Next

pg_upgrade

Home

pg_waldump

Copyright © 1996-2023 The PostgreSQL Global Development Group