Postgres Pro
Downloads
Home   >   mailing lists

How to determine number of established connections - Mailing list pgsql-general

From Andrus
Subject How to determine number of established connections
Date
Msg-id dtcutr$e0b$1@news.hub.org
Whole thread Raw
Responses Re: How to determine number of established connections  (Michael Fuhr <mike@fuhr.org>)
Re: How to determine number of established connections  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List pgsql-general
Tree view 
When connectiong to database my application needs to determine how many
connections is currently established to Postgres server.

Any idea which query I should use ?

I can create temporary table at startup of each connection. But how to count
the number of temporary tables created by all applications ?


Using Postgres 8.1

Andrus

pgsql-general by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: What is the syntax for setting a default date in PostgreSQL
Next
From: Michael Fuhr
Date:
Subject: Re: How to determine number of established connections