test_decoding
An example logical decoding output plugin shipped with PostgreSQL that prints each change as a line of readable text.
In more detail
It is meant for learning and testing. Production CDC tools use other plugins, such as pgoutput, that produce structured output.
Related terms
- logical decoding — The PostgreSQL feature that turns write-ahead log entries into readable row changes, such as inserts and updates with their values.
- replication slot — A PostgreSQL object that remembers how far a consumer of the change stream has read, so no changes are lost between reads.
- plugin — An add-on package that extends a tool with extra features without changing the tool itself.
Taught in
- Change Data Capture In Principle — Apache Kafka & Event Streaming