As others have said, a queue system and message system are not exactly the same. Can you explain your goal, as the listen/notify may not be appropriate for your use. If what you want is really just a message system, then the example we based our code on is at https://jdbc.postgresql.org/documentation/81/listennotify.html.
Keep in mind, if you connect (or reconnect) to the listen interface, you won't get any messages sent before it, so it isn't exactly what you want if you need a persistent queue, say for a job queue. We use it for invalidating cache content.
On Mon, Oct 11, 2021 at 11:31 AM aditya desai <admad123@gmail.com> wrote:
Hi Erik,
Thanks for response. We will be implementing it in Java or .NET. Could you please send steps for Java?
I am not a Java expert and I am completely DB person. So do we need external API to enqueue and dqueue messages. Completely new to this concept. Please bear with me :)
You will need to provide more info, such as what language and driver you are trying to implement this with. I have implemented it with Java, but the driver has a specific API to implement this.
On Mon, Oct 11, 2021 at 10:12 AM aditya desai <admad123@gmail.com> wrote:
Hi,
Has anyone implemented LISTEN / NOTIFY to enqueue and dequeue messages to and from Postgres? Do you have steps to implement it?