pg_verify_checksums

A Server utility to verify data page checksums in a PostgreSQL cluster.

pg_verify_checksums is a Server utility which verifies data page checksums in a PostgreSQL cluster.

pg_verify_checksums was introduced in PostgreSQL 11 (release notes; commit 1fde38be). Note it has been replaced in PostgreSQL 12 by the more versatile pg_checksums.

Although data page checksums were introduced in PostgreSQL 9.3, previously no practical method existed for proactively verifying an entire database cluster. pg_verify_checksums provides a means of doing this. Note that it requires that the server is shut down cleanly.

Change history

Categories

Data consistency and forensics, Deprecated, Server utility, Storage

See also

Data page checksums