Skip site navigation (1) Skip section navigation (2)

Re: Review: Hot standby

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Guillaume Smet <guillaume(dot)smet(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Simon Riggs <simon(at)2ndquadrant(dot)com>, Pavan Deolasee <pavan(dot)deolasee(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Review: Hot standby
Date: 2008-11-28 18:34:52
Message-ID: 493039CC.7090507@dunslane.net (view raw or flat)
Thread:
Lists: pgsql-hackers

Guillaume Smet wrote:
> On Fri, Nov 28, 2008 at 6:45 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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

In response to

pgsql-hackers by date

Next:From: Tom LaneDate: 2008-11-28 18:48:38
Subject: Re: Re: [COMMITTERS] pgsql: Add support for matching wildcard server certificates to the new
Previous:From: Magnus HaganderDate: 2008-11-28 18:33:54
Subject: Re: Re: [COMMITTERS] pgsql: Add support for matching wildcard server certificates to the new

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group