Even after reverting, I’m still getting the error below.

2022-08-22 203544 source > Caused by: io.debezium.DebeziumException: java.time.format.DateTimeParseException: Text ‘0’ could not be parsed at index 0

Could you try to refresh the schema and try to sync again?

I tried that, same error. What's interesting is that I have another connection, same source (postgres) and destination but using different replication slots and publications for CDC, and the old one works. It's the new connection I added on the weekend that's causing the problem. Both are using the same user to connect to pg

Can you specify which version of Postgres Source did you revert back to? Our team is still in the process of investigating so don't want to provide incorrect resolution steps. If you can, I would suggest amending your comment in the github issue with something like

EDIT: noticed that the same source (postgres) and destination using <some_configuration_info> works for CDC

The more information you can help provide the likelier our team can replicate the issue can create a solution. As for what seemed to work for other users that encountered this issue, the sync failed after upgrading from

0.4.0

to

1.0.2

so a suggestion would be to consider downgrading to

0.4.0

(which may not be ideal but should in theory resolve the failing sync for the time being)