Hacker News Reader

What about `pg_notify`? I just want to use it to replace my kafka server which is lite overload but costs much.

If you are using NOTIFY/LISTEN, keep track to check if your database does not have any long running queries. If you end up getting PostgreSQL to vacuum freeze your tables while the long running query is active, PostgreSQL will delete files from the pg_xact folder and that will bork out any LISTEN query, until you fully restart the database.

> PostgreSQL will delete files from the pg_xact folder and that will bork out any LISTEN query, until you fully restart the database

that sounds like a bug; are you aware of an issue/ticket tracking that?

While I haven't found an "issue" talking about this (sorry, I don't know how PostgreSQL tracks open bugs), they do know about it since I already seen that issue being talked about on PostgreSQL's mailing list.

Here's my issue on StackExchange, for anyone that wants to delve deeper into my issue: https://dba.stackexchange.com/questions/325104/error-could-n...

Here's an thread talking about the issue, while OP's issue doesn't seem to match exactly what I was experiencing, one of the replies describes my exact issue: https://postgrespro.com/list/thread-id/2546853

Take a look into logical replication. You can even send messages over it

Reply on news.ycombinator.com