4 ms·
What about `pg_notify`? I just want to use it to replace my kafka server which is lite overload but costs much.
by topmax 3y ago
What about `pg_notify`? I just want to use it to replace my kafka server which is lite overload but costs much.
- klysm 3y agoTake a look into logical replication. You can even send messages over it
- MrPowerGamerBR 3y agoIf 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.
- philsnow 3y 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?
- MrPowerGamerBR 3y agoWhile 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-not-access-status-of-transaction-could-not-open-file-pg-xact-0029 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 https://postgrespro.com/list/thread-id/2546853