Logical Decoding and Change Data Capture
Use logical decoding to stream row-level changes out of PostgreSQL for CDC pipelines and event-driven systems.
What Is Logical Decoding
Logical decoding turns the write-ahead log into a readable stream of logical row changes. It is the foundation of both logical replication and external Change Data Capture (CDC).
Output Plugins
A plugin decides the format of the change stream. Built-in pgoutput powers logical replication; test_decoding emits human-readable text; tools like Debezium use their own.
All lessons in this course
- Cascading Replication
- Multi-Master Replication (BDR)
- Replication Slots and WAL Management
- Logical Decoding and Change Data Capture