Re: Database consistency check.
Peter Geoghegan <[email protected]> Thu, 7 Nov 2019 11:31:12 -0800
| Newsgroups | gmane.comp.db.postgresql.admin |
|---|---|
| Message-ID | <CAH2-Wzk5UXiX2JjtND2h3tzp4m0114QgYJLBSRfxwLGzxfQyVg@mail.gmail.com> |
On Thu, Nov 7, 2019 at 11:18 AM Asomba Djala <[email protected]> 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