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
Last activity: Aug 4, 2023, 04:54 PM