my connections never die - Mailing list pgsql-general

From Ben Carterette
Subject my connections never die
Date
Msg-id 3AFABD99.615BCF2D@mail.liberty.k12.mo.us
Whole thread Raw
Responses Re: my connections never die  (Hunter Hillegas <lists@lastonepicked.com>)
Re: my connections never die  ("Dominic J. Eidson" <sauron@the-infinite.org>)
List pgsql-general
I'm running a web server on one machine (Apache 1.3+Tomcat 3.2+mod_jk)
with some databases (postgresql 7.1), and a dedicated database server on
another machine (postgresql 7.0.2).  A lot of my web pages establish a
connection to a database on either machine and store the Connection
object in a session so's I don't have to create a new one every page.
Well, it seems these connections, which never get explicitly closed, are
never dying.  Some of them, anyway.  I haven't been able to predict
which ones are going to close themselves and which ones will stay open
for days, but some of them are still taking up a process days later.

Greatly appreciating any explanation,
Ben Carterette
bcarterette@mail.liberty.k12.mo.us



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: COPY locking
Next
From: John Coers
Date:
Subject: Re: COPY locking