On Mon, 2021-08-30 at 17:18 +0200, hubert depesz lubaczewski wrote: > The thing is - I can't close it with pg_terminate_backend(), and I'd > rather not kill -9, as it will, I think, close all other connections, > and this is prod server.
Of course the cause should be fixed, but to serve your immediate need: After calling pg_terminate_backend(), you can attach gdb to the backend and then run print ProcessInterrupts() That will cause the backend to exit normally without crashing the server. Yours, Laurenz Albe
