PostgreSQL

Missing data on UPDATE/DELETE operations silently skipped in logical replication

warning
ReplicationUpdated Feb 26, 2026
Technologies:
How to detect:

When logical replication attempts to replicate UPDATE or DELETE operations for rows that don't exist on the subscriber, the operations are silently skipped without producing a conflict or error. This can lead to data inconsistency between publisher and subscriber.

Recommended action:

Monitor replication lag and data consistency between publisher and subscriber. Implement periodic data validation checks comparing publisher and subscriber tables. Consider using initial table synchronization before enabling replication. Track metrics for skipped operations if available.