No video of the event yet, sorry!

Logical replication continues to evolve as a key mechanism for data distribution in PostgreSQL. However, when multiple nodes modify the same data, inconsistencies/conflicts can arise. PostgreSQL 18 takes a major step forward by introducing built-in conflict detection, laying the groundwork for automated conflict management in future releases.

This talk will cover:

• How and why conflicts occur in logical replication setups
• The new conflict detection framework introduced in PostgreSQL 18
• Supported conflict types, including update_deleted (planned for PG19)
• Proposed conflict resolution capabilities and roadmap

Attendees will gain insights into the internal design and user-facing behavior of Conflict Detection and Resolution (CDR) in PostgreSQL logical replication.