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