Re: PostgreSQL 'Corruption & Fragmentation' detection and resolution/fix

On Mon, Jun 11, 2018 at 6:28 AM, pavan95 <pavan.postgresdba@gmail.com> wrote:
> I'm searching a way to detect postgresql corruption on a daily basis. Please
> provide me

Check out amcheck:

https://github.com/petergeoghegan/amcheck

The version on Github has feature parity with the version from
Postgres 11 (it has the new "heapallindexed" stuff), but it works for
older versions of Postgres. There are official PGDG .deb and RPM
packages available.

-- 
Peter Geoghegan