Re: Database consistency check. - Mailing list pgsql-admin

On Thu, Nov 7, 2019 at 11:18 AM Asomba Djala <asombadjala8@gmail.com> wrote:
> Thank you. What about already initialized clusters?

There is amcheck, which tests the consistency of B-Tree indexes:

https://www.postgresql.org/docs/current/amcheck.html

Recent versions have a "heapallindexed" option, too, which has the
tool test indexes against the table that they index. This is very
useful as a general purpose tool for detecting corruption.

--
Peter Geoghegan