Re: [BUG] PostgreSQL 14.5: Data corruption in table tb_workstation_message (possible fstrim-related on eMMC)

Greg Sabino Mullane <htamfids@gmail.com>

From: Greg Sabino Mullane <htamfids@gmail.com>
To: 第108次明天 <87326549@qq.com>
Cc: pgsql-bugs <pgsql-bugs@postgresql.org>
Date: 2025-12-18T13:30:51Z
Lists: pgsql-bugs
>
>
>    - PostgreSQL Version: 14.5
>
>
That is way too old. Upgrade to 14.20

or guide further troubleshooting?


Run the pg_checksums program to get a handle on the extent of the corruption

https://www.postgresql.org/docs/14/app-pgchecksums.html

Database backups are affected by corrupted data.


I assume you are not using a good backup system then. pgBackRest, for
example, will not only check for corrupted pages during the backup, but
report on it and allow the backup to proceed.