On Fri, 2008-11-28 at 12:45 -0500, Tom Lane wrote: > Simon Riggs <[EMAIL PROTECTED]> writes: > > On Fri, 2008-11-28 at 11:44 -0500, Tom Lane wrote: > >> I hadn't been following the discussion closely enough to know what the > >> problem is. > > > When we replay an AccessExclusiveLock on the standby we need to kick off > > any current lock holders, after a configurable grace period. Current > > lock holders may include some read-only backends that are > > idle-in-transaction. SIGINT, which is what the current patch uses, is > > not sufficient to dislodge the idle backends. > > 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?
Yes, that is by far the best solution. ISTM many people will be happy. -- Simon Riggs www.2ndQuadrant.com PostgreSQL Training, Services and Support -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers