Postgres Pro
Downloads
Home   >   mailing lists

Re: any api in libpq to get the number of connections - Mailing list pgsql-general

From Shoaib Mir
Subject Re: any api in libpq to get the number of connections
Date
Msg-id bf54be870612120155o7d91d94dg1d131b0ac2fb9fac@mail.gmail.com
Whole thread Raw
In response to any api in libpq to get the number of connections  ("surabhi.ahuja" <surabhi.ahuja@iiitb.ac.in>)
List pgsql-general
Tree view
This might be of some help using a query like:

select count(*) as NumberOfConn from pg_stat_activity where datname = 'dbname';

--------------
Shoaib Mir
EnterpriseDB ( www.enterprisedb.com)

On 12/12/06, surabhi.ahuja <surabhi.ahuja@iiitb.ac.in> wrote:
 Hi,
is ther any api avaiable in libpq
so that i can get the number of connections that exists with the database
 
thanks,
regards
surabhi
This message has been scanned by the Trend Micro IGSA and found to be free of known security risks.

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Restore database from files (not dump files)?
Next
From: Martijn van Oosterhout
Date:
Subject: Re: out of memory error on 3 table join