Hello all,
We are having master-slave setup with pgpool pointing, only to master
server. Whenever i tried to terminate the long running session on db end
using SELECT pg_terminate_backend(pid), pgpool is getting crashed. Many
blogs are saying this is the expected behaviour of pgpool, but my question
is there anyway to terminate unwanted sessions on db without loosing other
connections.
Because restarting entire system every time for a single trouble causing
session is a big hectic for us. Please share you ideas on this.
Thanks & Regards,
Rajamohan.J