This may be a silly question, but can anyone tell me the difference between the Postgres Source and Postgres CDC Source Connectors in Confluent Cloud?
Great question! As I understand it one offers query-based CDC, whilst the other offers log-based CDC.
- PostgreSQL CDC Source Connector (Debezium) for Confluent Cloud is built on the Debezium project and uses log-based CDC
- PostgreSQL Source Connector for Confluent Cloud is built on the JDBC Source connector, and offers query-based CDC
For the difference between log-based and query-based CDC see No More Silos: Integrating Databases and Apache Kafka
Awesome, thanks for the help and thanks for providing those links!
1 Like
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.