Thread: Re: [HACKERS] Killing the backend to cancel a long waiting query

Re: [HACKERS] Killing the backend to cancel a long waiting query

From
Tom Lane
Date:
"Paulo Scardine" <paulos@cimed.ind.br> writes:
> So I hacked a small pggetpid and pgkillpid C functions, and now I can learn
> the backend's PID, start the query in a new thread, and kill the backend
> using another connection if I want.

I trust when you say "kill", you really mean "send SIGINT" ...

            regards, tom lane