apache
Upgrade to later version of Debezium Postgres
Search before reporting
- [x] I searched in the issues and found nothing similar.
Motivation
Currently, the Debezium connector is set to Debezium version 1.9.7, last updated November 2022. The Debezium config API has some changes since 1.9, and it wasn't clear to me during my initial setup why the properties from the Debezium documentation were not working properly. The current version of drivers that the connector uses for PG is 42.5.5.
Further, the 1.9 release of Debezium is only tested through Postgres version 14. It seems to work for me on Postgres 15 that I have locally, so it's not a critical issue, but it does seem like this will become an incompatibility over time.
Other anything else using Debezium is also going to be about 2.5 years behind, but I was only specifically interested in Postgres when I investigated.
Solution
The current version of Debezium itself is 3.01, with support for the PG driver version 42.6.1 and PostgreSQL 17.5. I think the obvious solution is to upgrade the version of Debezium used in the connector to 3.0.1. I realize that's potentially a lot of legwork and re-testing, so an interim solution might just be to document that the current connector for the 4.0.4.nar file uses the 1.9.7 version of Debezium, at least until the divergence hits a problem without a work-around.
Alternatives
No response
Anything else?
No response
Are you willing to submit a PR?
- [ ] I'm willing to submit a PR!
