Thread

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

Greg Sabino Mullane <htamfids@gmail.com> — 2025-12-18T13:30:51Z

>
>
>    - 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.