Re: Pg analog to DBCC CCHECKDB?

2019-04-05 Thread Peter Geoghegan
On Fri, Apr 5, 2019 at 7:33 AM Ron wrote: > In 9.6, does such a thing exist? (We just restored a VM from snapshot and I > want to verify the cluster sanity.) amcheck is available for versions 9.4+, though it only appears in contrib in Postgres 10. There are both yum and deb packages available. S

Re: Pg analog to DBCC CCHECKDB?

2019-04-05 Thread Michel Pelletier
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 operati

Pg analog to DBCC CCHECKDB?

2019-04-05 Thread Ron
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.