Re: Database consistency check.
Asomba Djala <[email protected]> Thu, 7 Nov 2019 13:32:06 -0600
| Newsgroups | gmane.comp.db.postgresql.admin |
|---|---|
| Message-ID | <CAOdgZeQ4-_gpkFHjHQgmQE5Fd8g5Oeac8B5MOL+aXD5ZWFeJTA@mail.gmail.com> |
Thank you very much. On Thu, Nov 7, 2019, 1:31 PM Peter Geoghegan <[email protected]> wrote: > 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 >