JDBC Connector support for Postgres' array types

Kafka Connect
1

Hi all,

As part of a project in my company, I’d like to introduce Kafka with Debezium for doing CDC replication from MongoDB to PostgreSQL. We have a system in place already, but it’s having scalability issues.

After doing a proof of concept, we got an error when trying to write to a Postgres array type (int, text, etc) via the JDBC connector. Looking for a solution, I found this PR: Added support for arrays of primitives in Postgres dialect by Faqa · Pull Request #805 · confluentinc/kafka-connect-jdbc · GitHub

My question is, is there any way to write a Postgres array from Kafka at the moment? Or how could we help accelerate the merge of this feature?

We had a similar issue for writing a Struct into JSON/JSONB, but it could be fixed by keeping the data as a String instead of a Struct.

Thanks

1 Like
2

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