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

From Peter Geoghegan
Subject Re: Database consistency check.
Date
Msg-id CAH2-Wzk5UXiX2JjtND2h3tzp4m0114QgYJLBSRfxwLGzxfQyVg@mail.gmail.com
Whole thread Raw
In response to Re: Database consistency check.  (Asomba Djala <asombadjala8@gmail.com>)
Responses Re: Database consistency check.  (Asomba Djala <asombadjala8@gmail.com>)
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



pgsql-admin by date:

Previous
From: Asomba Djala
Date:
Subject: Re: Database consistency check.
Next
From: Asomba Djala
Date:
Subject: Re: Database consistency check.