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 https://rmoff.dev/no-more-silos
Awesome, thanks for the help and thanks for providing those links!