Re: Corruption issue

What can be the cause of corruption?

On Sun, 24 Sept 2023, 09:56 OS DB2, <opensourcedb2(at)gmail(dot)com> wrote:

> How can I stop it from recurring?
>
> On Sat, 23 Sept 2023, 15:04 Holger Jakobs, <holger(at)jakobs(dot)com> wrote:
>
>> chkdsk is a Windows program, but the original poster wrote her is using
>> Linux.
>>
>> So, badblocks could be the appropriate program.
>>
>>
>> Am 22. September 2023 18:55:14 MESZ schrieb Dan Smith <
>> j(dot)daniel(dot)smith1(at)gmail(dot)com>:
>>
>>> 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
>>>
>>>