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.

Check the order of following step. 1. Create publication 2. Create slot If you create Postgres slot first, Start all over by deleting both two steps above and create publication first. It has to do with how debezium expected the step to be followed.

@Qamarudeen Muhammad Tried that but I am still getting the same error.

Hi @Rishabh Jain! Have you found the cause of the error? I’m in the exact same place.

Nope, still stuck with it.

Hi! I found the issue. In my case I detect that if I modify a old connector the option to select the plugin is hide (i don’t know why). I see in your picture the same thing. Try creating a complete new source and the option will appear. Probably the plugin for default is not the same as yours. Tell me if this helps you.

Thanks for the looking into this Lautaro! Rishabh, does the above help?

@Lautaro Quiroga That worked thanks. But my Airbyte sync is very slow. It’s taking 5 mins even with a table of 10 rows. Did you face this issue?

hi guys, i encountered the same problem and the option does not even show up 😕 when trying to create new connector