The primary symptom of this corruption is rows that:
are present on the master, but missing on the replica
have been deleted on the master still appear to be visible on the replica
have been updated, and their old versions appear alongside the new, updated versions on the replica
How can I verify whether I already have this corruption? There is no known way to identify that the issue has affected a standby in the past but comparing the data from the primary with the standby.
So hands up who still think PostgreSQL doesn't need some way of checking the data consistency between master-standby? :)
