[pgpool-general: 3681] Re: How to terminate pgpool process ?

[Raghav]

On Mon, May 4, 2015 at 3:59 PM, Tatsuo Ishii <ishii at postgresql.org> wrote:

> > Hi Team,
> >
> > Am using pgpool version 3.3.3 with load-balancing feature.
> >
> > My question is, during month end, users are executing long running
> queries
> > via pgpool and those queries are running on Slave node(which is good).
> > Sometimes we
> > get request from same user to stop those queries, in such cases we cannot
> > stop those queries using pg_cancel_backend()
>
> Why you cannot use pg_cancel_backend()? You can directly connect to
> the PostgreSQL backend and by using pg_stat_activity to get the
> process id of the backend which runs the user's query. Then you can
> issue "select pg_cancel_backend(pid)" to cancel the query.
>
> Thank you for quick response.

Ah.. we were trying to cancel query via pgpool, above mentioned method we
didn't try,
seems its a clean way to kill the long running queries. This answers all my
queries.

--Raghav
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20150504/08aecf27/attachment.html>