Skip to main content

Suggest an Idea

Vote for your favorite Qlik product ideas and add your own suggestions.

Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE

pgoutput for Postgresql CDC

RogerBeanPool
Contributor II
Contributor II

pgoutput for Postgresql CDC

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.

Tags (2)
5 Comments
Shelley_Brennan
Former Employee
Former Employee

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.

Status changed to: Open - Collecting Feedback
danny-o
Contributor II
Contributor II

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
Contributor II
Contributor II

@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.

Ideation
Explorer II
Explorer II
 
Status changed to: Closed - Archived