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.