Re: looking for connection leaks - Mailing list pgsql-general

From Guy Rouillier
Subject Re: looking for connection leaks
Date
Msg-id CC1CF380F4D70844B01D45982E671B2348E4F8@mtxexch01.add0.masergy.com
Whole thread Raw
In response to looking for connection leaks  ("Wiebe de Jong" <wiebe@blive.com>)
List pgsql-general
Wiebe de Jong wrote:
> I think I am having a problem with database connection leakage
> between PostgreSQL 7.3.4 on a Linux box and JBoss 2.4.3 on a separate
> Linux box
>
> What would be a good tool for monitoring connection usage and finding
> leaks?

Plain text formatting is encouraged.  I've converted this one.

That version of JBoss is very old.  There newer versions in the 2.4
series, but I'd highly recommend switching to the actively maintained 3
or 4 series.

Don't know about connection logging with PostgreSQL, but JBoss can do
this quite easily.  Quick and easy, just turn on debug for the
connections.  If you want something more customized, every connection
has a unique object reference; you can just print it out in the log.

--
Guy Rouillier

pgsql-general by date:

Previous
From: Robby Russell
Date:
Subject: Re: Postgresql website issues.
Next
From: Bruno Wolff III
Date:
Subject: Re: Tracking back foreign keys?