# Debezium CDC connector

**URL:** <https://forum.confluent.io/t/debezium-cdc-connector/12371>\
**Category:** Kafka Connect\
**Created:** [16 October 2024 14:18 UTC](https://forum.confluent.io/t/debezium-cdc-connector/12371 "2024-10-16T14:18:42Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Anil](https://avatars.discourse-cdn.com/v4/letter/a/da6949/32.png) [@Anil](https://forum.confluent.io/u/Anil)\
**Post date:** [16 October 2024 14:18 UTC](https://forum.confluent.io/t/debezium-cdc-connector/12371/1 "2024-10-16T14:18:42Z")

</div>

Hi,

I am working with Debezium cdc Connector.

Below is my code,

name=mes\_po-info123  
connector.class= io.debezium.connector.postgresql.PostgresConnector  
tasks.max= 1  
plugin.name= pgoutput  
database.hostname= XXXXXX  
database.port= 5432  
database.user= XXXXX  
database.password= XXXXX  
database.dbname= XXXXX  
database.server.name= XXXXXX  
table.include.list= Chk.mes\_po\_info  
include.schema.changes=true  
database.history.kafka.bootstrap.servers= 127.0.0.1:9092  
topic.prefix=chk1234  
slot.name=110585  
key.converter=org.apache.kafka.connect.json.JsonConverter  
key.converter.schemas.enable=false  
value.converter=org.apache.kafka.connect.json.JsonConverter  
value.converter.schemas.enable=false

I am not sure, How can we declare or write Postgres Table Primary Key values in debezium cdc…

whenever I am not using DB constraints, I can see Data was pushing into topic and committed offset as below.

[2024-10-16 17:59:43,206] INFO [vjn\_mes\_insp|task-0|offsets] WorkerSourceTask{id=vjn\_mes\_insp-0} Committing offsets for 1 acknowledged messages (org.apache.kafka.connect.runtime.WorkerSourceTask:235)

while using DB Constraints its not committing offset, its retriving all rows (like jdbc source connector bulk) but later, it seems replication slots are skipping.

getting below error and not moving further.

[2024-10-16 19:20:02,817] INFO [mes\_po-info123|task-0] Searching for WAL resume position (io.debezium.connector.postgresql.PostgresStreamingChangeEventSource:342)

 ![Check](https://us1.discourse-cdn.com/flex019/uploads/confluentcommunity/original/2X/5/50704689945983c7f2361a0603a060c68103a3c5.jpeg)

---

<div class="post-metadata">

**Author:** ![Rithy125](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.confluent.io/rithy125/32/3870_2.png) [@Rithy125](https://forum.confluent.io/u/Rithy125)\
**Post date:** [22 October 2024 10:01 UTC](https://forum.confluent.io/t/debezium-cdc-connector/12371/2 "2024-10-22T10:01:57Z")

</div>

Try changing the snapshot mode? From the log , there is no snapshot mode configured

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex019/uploads/confluentcommunity/original/1X/c49438c90c9df282e9996fdf6971be890c71b65a.svg) [@system](https://forum.confluent.io/u/system)\
**Post date:** [21 November 2024 10:02 UTC](https://forum.confluent.io/t/debezium-cdc-connector/12371/3 "2024-11-21T10:02:51Z")

</div>

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.