> 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?
that sounds like a bug; are you aware of an issue/ticket tracking that?
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