Re: Open connections - Mailing list pgsql-jdbc

From Scott Marlowe
Subject Re: Open connections
Date
Msg-id 1104248929.21810.13.camel@state.g2switchworks.com
Whole thread Raw
In response to Open connections  ("Nico" <nicohmail-postgresql@yahoo.com>)
Responses Re: Open connections  (Kris Jurka <books@ejurka.com>)
List pgsql-jdbc
On Tue, 2004-12-28 at 05:34, Nico wrote:
> I would like to know how many connections are open at a certain time from a
> servlet, so I can anticipate connection errors. How do I do that?

Assuming that stats_row_level = true is set in the postgresql.conf file,
you can find out with:

SELECT * from pg_stat_activity;


pgsql-jdbc by date:

Previous
From: Guillaume Cottenceau
Date:
Subject: Re: problem to get nextval of a sequence
Next
From: tony
Date:
Subject: openoffice and boolean