Re: Review: Hot standby - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: Review: Hot standby
Date
Msg-id 493039CC.7090507@dunslane.net
Whole thread Raw
In response to Re: Review: Hot standby  ("Guillaume Smet" <guillaume.smet@gmail.com>)
List pgsql-hackers

Guillaume Smet wrote:
> On Fri, Nov 28, 2008 at 6:45 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>   
>> Hm.  People have complained of that fact from time to time in normal
>> usage as well.  Should we simply change SIGINT handling to allow it to
>> cancel an idle transaction?
>>     
>
> If this means that we would be able to able to easily rollback the
> current transaction of a backend stuck in "idle in transaction"
> status, a big +1.
>
>   

Yes, I have had clients caught by this regularly (last time less than a 
week ago), it would be a significant enhancement.

cheers

andrew


pgsql-hackers by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: Re: [COMMITTERS] pgsql: Add support for matching wildcard server certificates to the new
Next
From: Tom Lane
Date:
Subject: Re: Re: [COMMITTERS] pgsql: Add support for matching wildcard server certificates to the new