Production-grade PostgreSQL Logical Replication & CDC

A reference for database engineers, data platform teams, Python ETL developers, and DevOps practitioners running real-time data synchronization on PostgreSQL 15, 16, and 17. Learn how logical decoding, replication slots, and publications fit together — and how to operate them safely at scale.

Go from the architecture of the write-ahead log through slot lifecycle management, publication and subscription design, and Python & Debezium change data capture pipelines — with monitoring, conflict resolution, schema sync, and failover automation throughout.

Explore the reference

Three connected pillars take you from first principles to a running, observable CDC pipeline. Each pillar links to focused guides and step-by-step procedures.

What this site covers

Every page is a self-contained, SEO-friendly technical guide with copy-ready code, responsive tables, and cross-links to related material. The content is organized so you can read top-down or jump straight to the procedure you need — fully usable offline as an installable app.