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.