Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 85DA69FB466 for ; Tue, 20 Mar 2007 00:58:05 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 63228-03 for ; Tue, 20 Mar 2007 00:58:03 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by postgresql.org (Postfix) with ESMTP id 0EA029FB435 for ; Tue, 20 Mar 2007 00:58:05 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.8/8.13.8) with ESMTP id l2K3w4E7048354 for ; Tue, 20 Mar 2007 00:58:04 -0300 (ADT) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.8/8.13.8/Submit) id l2K3cQfP045228 for pgsql-admin@postgresql.org; Tue, 20 Mar 2007 00:38:26 -0300 (ADT) (envelope-from news) From: Christopher Browne X-Newsgroups: pgsql.admin Subject: Re: [Bulk] Re: Disconnecting non active (IDLE ) users Date: Mon, 19 Mar 2007 23:32:38 -0400 Organization: cbbrowne Computing Inc Lines: 48 Message-ID: <87hcsgy4h5.fsf@wolfe.cbbrowne.com> References: <55c095e90702280801q484b75d8v3833a18c5d5a5c16@mail.gmail.com> <030c01c75b5e$0de7ffb0$6401a8c0@RnDworkstation> <45FF0470.2050403@augustz.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org X-message-flag: Outlook is rather hackable, isn't it? X-Home-Page: http://www.cbbrowne.com/info/ X-Affero: http://svcs.affero.net/rm.php?r=cbbrowne User-Agent: Gnus/5.1007 (Gnus v5.10.7) XEmacs/21.4.19 (linux) Cancel-Lock: sha1:s5RZDzI8rsqSfBqGrJUOQk4kr9o= To: pgsql-admin@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/130 X-Sequence-Number: 24954 The world rejoiced as augustz@augustz.com (August Zajonc) wrote: > Ted Byers wrote: > > [snip] >> It is outrageously unethical, IMHO, for a programmer, or group thereof, >> to refuse to fix a problem that has arisen from how their targetted >> users use their application. > > Let's save the determination of outrageous behavior for others and see > if we can help the user fix their problem. > > Two suggestions: > Pgpool > > Change keepalive settings in kernel if the machine is only used for > postgresql. If you disable keepalives, at some point the kernel will > likely drop the connection. Postgresql turns keepalives on by default > (which is usually a good thing). > > Your apps should login transparently though and know how to handle this > issue. Prompting users repeatedly to login can be frustrating, the usual > question is how to keep a connection open longer :) > > I'm not sure that postgresql would itself implement a timeout feature... This fits very nicely into the category of things that can reasonably vary quite a lot based on local policy. I'd quite like to be able to say: "We can let some users in, with read-only access. And we can have PostgreSQL enforce policies as to maximum connection times so that we can ensure they do not hold open in transaction connections that will destroy performance." At present, I can only handle this via creating external utilities to try to analyze things and look for connections that are breaking connectivity policies. It would be rather nice to have something to support this in the DB engine. That may not fit your needs: your users may be in a position to tell you "we don't care if performance suffers - we want our connections." -- output = reverse("moc.liamg" "@" "enworbbc") http://linuxdatabases.info/info/lsf.html "Let me blow that up a bit more for you." -- Colin Powell, Discussing a picture of the intelligence compound in Iraq