Presented by:

Mason Sharp

pgEdge

Mason Sharp has been an active developer of multiple PostgreSQL cluster projects, including Postgres-XL and Postgres-XC.

No video of the event yet, sorry!

Logical replication in Postgres is powerful: enabling selective table replication, cross-version upgrades, and real-time data distribution. But unlike physical replication, there's no guarantee your subscriber actually matches your publisher. Constraint violations, permission failures, skipped transactions, and schema drift can all cause silent divergence. This session demonstrates a practical approach to validating data consistency across logical replication topologies. We'll walk through the complete workflow: efficiently comparing tables across nodes and interpreting diff reports to prepare a repair plan. We'll also cover how to automate regular consistency checks as part of your operational baseline, because in logical replication, trust without verification is just hope.

Date:
Duration:
20 min
Room:
Conference:
Postgres Conference: 2026
Language:
Track:
Postgres Extensions Day
Difficulty:
Medium