Re: number of connections to postmaster

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