Re: pg_terminate_backend idea - Mailing list pgsql-hackers

From Oliver Jowett
Subject Re: pg_terminate_backend idea
Date
Msg-id 42B8BB96.5010600@opencloud.com
Whole thread Raw
In response to Re: pg_terminate_backend idea  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:
> "Magnus Hagander" <mha@sollentuna.net> writes:
> 
>>But it still requires me to send some data (such as a dummy query) to
>>the backend before it exits. This is because server side libpq blocks
>>when reading and ignores signals at this time. I believe the fix for
>>this would be to pass a flag down to the libpq routines that we want to
>>be abort in case of signal+flag, set only when doing the "main call" to
>>recv, so we can kill idle process.
> 
> 
> Yech!  That code is messy enough already, lets not pile another kluge
> atop it in order to handle something that's not even being requested
> AFAIR.

I ran into the same problem back when I was trying to implement an
idle-in-transaction timeout, so solving this might be useful in more
than one place..

-O


pgsql-hackers by date:

Previous
From: Dave Cramer
Date:
Subject: Re: PROPOSAL FE/BE extension to handle IN/OUT parameters
Next
From: Neil Conway
Date:
Subject: pl/pgsql: END verbosity