May 2018
Intermediate to advanced
576 pages
30h 25m
English
First, you may want to try pg_cancel_backend(pid), a milder version of pg_terminate_backend(pid).
The difference between these two is that pg_cancel_backend() just cancels the current query, whereas pg_terminate_backend() really kills the backend (therefore, this can be used for idle or idle in transaction backends).