Postgres Pro
Downloads
Home   >   mailing lists

Re: Corruption issue - Mailing list pgsql-admin

From Dan Smith
Subject Re: Corruption issue
Date
Msg-id CAK50JryUP_gFkxPR=T=TDegZmCRFk21tzWybChX8a8pZY=viqA@mail.gmail.com
Whole thread Raw
In response to Corruption issue  (OS DB2 <opensourcedb2@gmail.com>)
Responses Re: Corruption issue
List pgsql-admin
Tree view
On Fri, Sep 22, 2023, 12:48 PM OS DB2 <opensourcedb2@gmail.com> wrote:
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


Recommend running chkdsk and upgrade the cluster (9.5 is EOL).


Best regards,

Dan Smith

pgsql-admin by date:

Previous
From: OS DB2
Date:
Subject: Corruption issue
Next
From: Holger Jakobs
Date:
Subject: Re: Corruption issue