Pgpool is crashing when terminating user session - Mailing list pgsql-general

From RAJAMOHAN
Subject Pgpool is crashing when terminating user session
Date
Msg-id CAFzdntu4WTt1827fL-F6Mp5zu9BYHdqGLOoLg3cG0Lx7_au1Aw@mail.gmail.com
Whole thread Raw
Responses Re: Pgpool is crashing when terminating user session  (Tatsuo Ishii <ishii@sraoss.co.jp>)
List pgsql-general
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

pgsql-general by date:

Previous
From: "Peter J. Holzer"
Date:
Subject: Re: Column reset all values
Next
From: Rob Sargent
Date:
Subject: Re: schema agnostic functions in language sql