Suggest an Idea

[RogerBeanPool]

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.

[Shelley_Brennan]

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.

[danny-o]

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.

[RogerBeanPool]

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

[Meghann_MacDonald]

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.