Re: Corruption issue

Hi,

Os version is suse12 sp5

On Wed, 27 Sept 2023, 13:22 Laurenz Albe, <laurenz(dot)albe(at)cybertec(dot)at> wrote:

> On Wed, 2023-09-27 at 11:16 +0530, OS DB2 wrote:
> > > > > On Fri, Sep 22, 2023, 12:48 PM OS DB2 <opensourcedb2(at)gmail(dot)com>
> wrote:
> > > > > > 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
> >
> > What can be the cause of corruption?
>
> You wrote 9.5, but you didn't disclose how old your hardware or
> your operating system are.
>
> Most often the cause is bad hardware, but it could be a bug in the file
> system
> or the Linux kernel or one of the numerous bugs that have been fixed in
> PostgreSQL since 9.5 went out of commission.
>
> Yours,
> Laurenz Albe
>