A Server utility to verify data page checksums in a PostgreSQL cluster.
This entry relates to a PostgreSQL feature which is deprecated and may be desupported in future releases.

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


Data consistency and forensics, Deprecated, Server utility, Storage

See also

Data page checksums