skip to Main Content

How to configure kafka connect jdbc sink connector for postgresql with ssl postgres authentication?

I have a working jdbc sink connector configuration for postgres using username and password configuration: { "connector.class": "io.confluent.connect.jdbc.JdbcSinkConnector", "connection.url": "jdbc:postgresql://localhost:5432/postgres", "connection.user": "postgres-user", "connection.password": "postgres-pw", "topics.regex": "my-topic", "transforms": "unwrap", "transforms.unwrap.type": "io.debezium.transforms.ExtractNewRecordState", "transforms.unwrap.drop.tombstones": "false", "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",…

VIEW QUESTION

Postgresql – Debezium Connect does not create topic

I'm a newbie to Kafka and started experimenting. I'm using this tutorial https://medium.com/high-alpha/data-stream-processing-for-newbies-with-kafka-ksql-and-postgres-c30309cfaaf8 I ran the following docker-compose.yml version: '2' services: postgres: image: 'debezium/postgres:11' environment: POSTGRES_PASSWORD: postgres command: postgres -c config_file=/home/config/postgresql.conf ports: - '5432:5432' volumes: - 'C:postgres-kafkaconfig:/home/config' - 'C:postgres-kafkaconfigpg_hba.conf:/home/config/pg_hba.conf' -…

VIEW QUESTION
Back To Top
Search