Re: Pg analog to DBCC CCHECKDB?

There is amcheck:

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

"When the heapallindexed argument to verification functions is true, an
additional phase of verification is performed against the table associated
with the target index relation. This consists of a “dummy” CREATE INDEX
operation, which checks for the presence of all hypothetical new index
tuples against a temporary, in-memory summarizing structure (this is built
when needed during the basic first phase of verification). The summarizing
structure “fingerprints” every tuple found within the target index. The
high level principle behind heapallindexed verification is that a new index
that is equivalent to the existing, target index must only have entries
that can be found in the existing structure."

I haven't used this tool but it looks promising:

https://github.com/tvondra/pg_check

On Fri, Apr 5, 2019 at 7:34 AM Ron <ronljohnsonjr(at)gmail(dot)com> wrote:

> Hi,
>
> In 9.6, does such a thing exist? (We just restored a VM from snapshot and
> I
> want to verify the cluster sanity.)
>
> Thanks
>
> --
> Angular momentum makes the world go 'round.
>
>
>