How can I stop it from recurring?On Sat, 23 Sept 2023, 15:04 Holger Jakobs, <holger@jakobs.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.daniel.smith1@gmail.com>: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 corruptedOs - linuxPostgresql version - 9.5We 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,NikhilRecommend running chkdsk and upgrade the cluster (9.5 is EOL).Best regards,Dan Smith
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.daniel.smith1@gmail.com>: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 corruptedOs - linuxPostgresql version - 9.5We 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,NikhilRecommend running chkdsk and upgrade the cluster (9.5 is EOL).Best regards,Dan Smith
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 corruptedOs - linuxPostgresql version - 9.5We 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,NikhilRecommend running chkdsk and upgrade the cluster (9.5 is EOL).Best regards,Dan Smith
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 corruptedOs - linuxPostgresql version - 9.5We 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
pgsql-admin by date:
Соглашаюсь с условиями обработки персональных данных
