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

From: Peter Geoghegan <pg(at)bowt(dot)ie>
To: pavan95 <pavan(dot)postgresdba(at)gmail(dot)com>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: PostgreSQL 'Corruption & Fragmentation' detection and resolution/fix
Date: 2018-06-11 17:02:39
Message-ID: CAH2-Wz=bYZtkmZ1Tg-jiH0bh8GMgDT1Y8oKyq+19hQ42CJ8HPA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Mon, Jun 11, 2018 at 6:28 AM, pavan95 <pavan(dot)postgresdba(at)gmail(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Pavan Teja 2018-06-11 17:07:05 Re: pg_stat_activity
Previous Message Pavan Teja 2018-06-11 16:58:51 Re: PostgreSQL 'Corruption & Fragmentation' detection and resolution/fix