This tutorial guides users through setting up a complete Change Data Capture (CDC) pipeline using Debezium and Kafka Connect to stream changes from a PostgreSQL database. It covers the prerequisites, infrastructure setup with Docker, PostgreSQL configuration, connector registration, and observing change events in Kafka topics.

Postgres logical replication can struggle with TOAST columns, leading to incomplete change events in Debezium when values remain unchanged. This article examines Debezium's reselect post processor as a solution, alongside more comprehensive approaches using Apache Flink for stateful stream processing to manage TOAST column values effectively.