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

Tom Lane wrote:

> "Peter E. Chen" <pchen3(at)jhmi(dot)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(at)nextbus(dot)com
(510)420-3120
www.nextbus.com
spinning to infinity, hallelujah
--------------------------------------------------------