Tom
When I try that, I get
template1=# select count(*) from pg_stat_activity;
ERROR: Relation 'pg_stat_activity' does not exist
thanks
Pam Wampler
-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Thursday, February 21, 2002 7:35 PM
To: Percy
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] number of connections to postmaster
"Percy" <percy_yip@yahoo.com> writes:
> Is there any way to find out the number of connections to postmaster?
In 7.2, "select count(*) from pg_stat_activity" should do it. See
http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/monitoring.html
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html