Hacker News new | ask | show | jobs
by topmax 1153 days ago
What about `pg_notify`? I just want to use it to replace my kafka server which is lite overload but costs much.
2 comments
MrPowerGamerBR 1153 days ago
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.
link
philsnow 1153 days ago
> 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?

link
MrPowerGamerBR 1152 days ago
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

link
klysm 1153 days ago
Take a look into logical replication. You can even send messages over it
link