Re: Anyway to know which users are connected to postgres?

Tom Lane wrote:

> "Peter E. Chen" <pchen3@jhmi.edu> writes:
>
>>I'd like to know if there is anyway one can figure out who is currently
>>connected to the database.
>>
>
> In 7.2 there is a system view pg_stat_activity.
>
> Since about 7.0, a "ps" listing will show the owning user for each
> postgres backend process (on most platforms, anyway).
>
>             regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>

This is very nice.  I can't ever see the current query, however,
even as postgres.  Is this column just to tease us?  I can
see it could be a security issue.

elein

--
--------------------------------------------------------
elein@nextbus.com
(510)420-3120
www.nextbus.com
    spinning to infinity, hallelujah
--------------------------------------------------------