idea pgoutput for Postgresql CDC in Suggest an Idea

pgoutput for Postgresql CDC

RogerBeanPool — Mon, 16 Nov 2020 14:58:55 GMT

The pgoutput plugin is the standard logical decoding plugin for Postgresql 10+. It's maintained by the community and is always-present so no additional libraries need to be installed.

It would be nice to be able to use this plugin for Qlik Replicate instead of having to install the `test_decoding` plugin.

Re: pgoutput for Postgresql CDC - Status changed to: Open - Collecting Feedback

Shelley_Brennan — Mon, 08 Mar 2021 14:09:28 GMT

Thank you - it is under consideration but is a major engineering effort for Replicate to support it. We will consider it for a future release.

Re: pgoutput for Postgresql CDC

danny-o — Mon, 13 Dec 2021 23:42:45 GMT

I think this could be a critical upgrade.

We've been having big problems with our replication slot locking up during high volume, and I have a theory this is because of the "test_decoding" plugin. Postgres themselves list the test_decoding plugin as "It doesn't do anything especially useful, but can serve as a starting point for developing your own output plugin.".

Since it is for testing only, my theory is that the serialization process of the WAL log is very much not optimized. pgoutput on the other hand, is a production-grade binary stream of changes.

Re: pgoutput for Postgresql CDC

RogerBeanPool — Mon, 17 Apr 2023 13:53:33 GMT

@Shelc can you tell us if this is still under consideration, please?

From now on, please track this idea from the Ideation por...

Meghann_MacDonald — Wed, 02 Aug 2023 15:53:55 GMT

From now on, please track this idea from the Ideation portal.

Link to new idea

Meghann

NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.

Re: pgoutput for Postgresql CDC - Status changed to: Closed - Archived

Ideation — Wed, 02 Aug 2023 15:53:57 GMT