Corruption issue

From: OS DB2 <opensourcedb2(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Corruption issue
Date: 2023-09-22 12:33:34
Message-ID: CAM==JRGCwoupcQsrggE7cSca0J8HtCfG3hTx+L=aHGB6dsMe-A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

In one of the our production database when we are trying to fetch the
records from one of the table, we are getting below error.

*Compressed data is corrupted*

Os - linux
Postgresql version - 9.5

We have restored data somehow using secondary node but still please let me
know how we can find out the root cause and avoid such scenarios in future.

Regards,
Nikhil

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Dan Smith 2023-09-22 16:55:14 Re: Corruption issue
Previous Message Erik Wienhold 2023-09-21 10:25:31 Re: Pg_cron not working