pg_amcheck: PostgreSQL corruption detection tool

Your Hidden Ally in PostgreSQL

When it comes to maintaining a robust PostgreSQL database, pg_amcheck is like Sherlock Holmes: meticulous, thorough, and always on the lookout for anomalies. This utility may not be the most glamorous tool in the shed, but it’s indispensable for those who value data integrity.

Data corruption can stem from various sources, such as hardware failures, software bugs or unexpected system crashes. pg_amcheck helps in early detection of such issues, allowing administrators to take corrective action before significant problems.

You may also run it parallel.

osmandinc@192 ~ % pg_amcheck -d postgres --jobs=8 --verbose

Hope it helps.