Block corruption Error.

From: vinod kale <vinod16895(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Block corruption Error.
Date: 2020-06-02 14:19:47
Message-ID: CAD7GeHS5GxTiqgiabjyJdHcaJU=Zujg_4hUuunoH6sjtdYNpGA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello Team,

We have generated one scenario for learning purpose regarding block
corruption.
We have manually corrupt the one table file at disk level and after queried
to that table we got below attached error.
So could you please help me out in below scenario?
What is the best method to resolve below error. ?

PFA screenshot.

Thanks in advance !!!

--
Thanks & Regards,
Vinod Kale

Attachment Content-Type Size
image/jpeg 72.8 KB

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Adam Scott 2020-06-02 15:50:38 Re: Block corruption Error.
Previous Message Rui DeSousa 2020-06-01 18:22:43 Re: pg_stat_database.xact_commit + pg_stat_database.xact_rollback as a reliable metric for xid consumption ?