pg_amcheck

checks PostgreSQL database corruption using Access Method verification

TLDR

Check all databases

$ pg_amcheck --all

Check specific database

$ pg_amcheck -d [database]

Check with verbose output

$ pg_amcheck -v -d [database]

SYNOPSIS

pg_amcheck [options] [dbname]

DESCRIPTION

pg_amcheck checks PostgreSQL database corruption using Access Method verification. Detects physical corruption in tables and indexes. Run for database integrity verification.

PARAMETERS

-a, --all

Check all databases.

-d, --database name

Database to check.

-t, --table table

Check specific table.

-i, --index index

Check specific index.

-v, --verbose

Verbose output.

--heapallindexed

Check heap for indexed values.