Re: Database consistency check.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Thank you very much. 

On Thu, Nov 7, 2019, 1:31 PM Peter Geoghegan <pg@xxxxxxx> wrote:
On Thu, Nov 7, 2019 at 11:18 AM Asomba Djala <asombadjala8@xxxxxxxxx> 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

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux