Pam Wampler wrote:
> Tom
> When I try that, I get
>
> template1=# select count(*) from pg_stat_activity;
> ERROR: Relation 'pg_stat_activity' does not exist
Tom said "in 7.2". So why do you expect it to work in a
pre-7.2 version?
And BTW:
SELECT numbackends FROM pg_stat_database ...
could do it too.
Jan
>
>
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com