hello 👋 the source-postgres connector suffers from lots of bugs since

3.8.x

2 months old release, examples: • github.com/airbytehq/airbyte/issues/80939 • github.com/airbytehq/airbyte/issues/80295 • github.com/airbytehq/airbyte/issues/81431 • github.com/airbytehq/airbyte/issues/81397 • github.com/airbytehq/airbyte/issues/47547 • github.com/airbytehq/airbyte/issues/79109 👉 do you have any visibility regarding a solid fix ? ⚠️ this is blocking for this 🏎️ speeded up destination v2 adoption as

Change Data Capture

is unusuable 😕 thank you!

@Richelle Herrli First off, welcome and glad to have you in the mix! To Kevin's point, there's been a lot of chatter about these Postgres issues in various forms, and since this connector is widely used it may make sense to prioritize any related PRs (as part of the work you mentioned in this thread). (I know some of those conversations are off in internal tickets that the community doesn't have visibility into, but maybe there are some wins to be had there.)

Thanks for tagging me, Justin! I'm checking internally about this connector and I'll let you know when I have intel.

hi @Richelle Herrli 👋 welcome on board and thank you for considering this topic ! I do confirm, CDC is properly working on our side using PostgreSQL connector

v3.7.2

with heartbeat query 👍

The Postgres version on Issue 47547 is 3.6.22. Is it not an issue on 3.7.2 but you're seeing a regression on 3.8? To better help you, I need to know which specific issues are impacting 3.8.

at least all listed in my first message except github.com/airbytehq/airbyte/issues/47547

Got it. I'll let you know if I have any news.

Hi @Richelle Herrli 👋 Please do you have visibility regarding CDC and XMin fixes in order to benefit from speed mode ? Thank you !

github.com/airbytehq/airbyte/issues/80295 , github.com/airbytehq/airbyte/issues/79109, and github.com/airbytehq/airbyte/pull/79110 are all done.

ok thank you 🤞

I don't currently have updates for Postgres, but I did pass along the PRs that are blockers for your team

Hi @Richelle Herrli, any visibility now ? We would like to upgrade to speed mode in the weeks to come 🙏

Hey Kevin, did you see github.com/airbytehq/airbyte/pull/82782? It fixes issues with CDC.

Hey @Richelle Herrli, thank you for follow up, really appreciated 🙂 Looks like below issues must still be addressed to serenely upgrade to `v3.8`: • github.com/airbytehq/airbyte/issues/80939 • github.com/airbytehq/airbyte/issues/81431 • github.com/airbytehq/airbyte/issues/81397 • github.com/airbytehq/airbyte/issues/82266 and possibly with CDK upgrade: github.com/airbytehq/airbyte/pull/84996

@Kevin Lefevre I don't see any other updates but I'll check with the team. Are you updating your method from Xmin to CDC? Otherwise, I don't see how github.com/airbytehq/airbyte/issues/81397 is relevant to your use case.

@Richelle Herrli ok thank you 🤞 we currently have both XMin and CDC collects and our target is to fully move to CDC

Letting folks know. Thanks Kevin!

@Richelle Herrli sure, it is not a blocker compared to other issues