zlacker

[parent] [thread] 2 comments
1. MrPowe+(OP)[view] [source] 2023-09-25 02:30:32
One reason that makes me dislike NOTIFY/LISTEN is that issues with it are hard to diagnose.

Recently I had to stop using it because after a while all NOTIFY/LISTENS would stop working, and only a database restart would fix the issue https://dba.stackexchange.com/questions/325104/error-could-n...

replies(1): >>runeks+Ws
◧
2. runeks+Ws[view] [source] 2023-09-25 08:19:11
>>MrPowe+(OP)
At my previous company, they switched from using NOTIFY/LISTEN for Postgres notifications to a custom solution built on top of logical replication. As I understand it, part of the reason was reliability. I never touched that part of the code, but I believe the idea was to subscribe to logical replication updates and send out notifications based on these.
replies(1): >>cpursl+YE
◧◩
3. cpursl+YE[view] [source] [discussion] 2023-09-25 10:24:00
>>runeks+Ws
This is what we do. Even put together a library for it:

https://github.com/cpursley/walex

[go to top]