The whole point of LISTEN/NOTIFY is that it's transaction safe! Not sure where you got that idea. Not only is NOTIFY transactional, so is LISTEN. The only ser

The whole point of LISTEN/NOTIFY is that it's transaction safe! Not sure where you got that idea. Not only is NOTIFY transactional, so is LISTEN. The only serious limitation I can think of: There was some talk, long ago, about propagating notifications via the WAL, so that LISTEN could work on a read-only slave. I don't know if this was implemented.