Thread: Anyway to know which users are connected to postgres?
Hey All, I'd like to know if there is anyway one can figure out who is currently connected to the database. Thanks, Peter
Peter E. Chen wrote:
> Hey All,
>
> I'd like to know if there is anyway one can figure out who is currently
> connected to the database.
You can use ps to see args of connected users, or pg_monitor at:
http://gborg.postgresql.org/project/pgmonitor
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
"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
On Mon, 14 Jan 2002, Peter E. Chen wrote: > Hey All, > > I'd like to know if there is anyway one can figure out who is currently > connected to the database. On Linux at least, the output of 'ps' shows the user, the database they are connected to, and the host they are connected from. -jwb
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 --------------------------------------------------------
Elein <elein@nextbus.com> writes: >> In 7.2 there is a system view pg_stat_activity. > 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. You need to turn on query stats. See http://developer.postgresql.org/docs/postgres/monitoring-stats.html regards, tom lane