Sample Header Ad - 728x90

Postgres Listen/Notify As Message Queue

25 votes
3 answers
31460 views
Is there any way to use Postgres Listen/Notify feature to deliver a message to a channel and have only one listener consume this message? The purpose for this is that I have multiple 'worker' apps all listening to the same Postgres channel. But I only want the work done once per message received through the notification channel. If Listen/Notify is not the correct feature in Postgres, is there a seperate feature I should be using? Ideally I would like to do this without using any additional extensions.
Asked by moesef (351 rep)
Apr 13, 2017, 11:13 PM
Last activity: Aug 4, 2023, 04:54 PM