On Fri, Sep 22, 2023, 12:48 PM OS DB2 <opensourcedb2(at)gmail(dot)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