I am trying to setup replication slot using wal2json plugin. I have created the slot and publication in Postgres. And provided the values to Airbyte. But when I try to test the connection I get an error saying that the “_Expected exactly one replication slot but found 0_”. But I do have replication slot created in Postgres. Not sure why Airbyte is unable to find it. pgoutput plugin works perfectly fine with Airbyte. Below screenshot for wal2json.

Are you able to sync without CDC?

Yes

You created a publication called cdc_wal? Did you follow the steps described here? https://docs.airbyte.com/integrations/sources/postgres#step-3-create-replication-slot

For anyone having the same issue, support to wal2json has been removed by Debezium (which is used by Airbyte). You’ll need to move to pgoutput to have CDC

@Ignacio Valdelvira cann you share the link here for this changelog?

This is all I found sorry https://debezium.io/blog/2022/10/17/debezium-2-0-final-released/#postgres-changes