Postgres Pro
Downloads
Home   >   mailing lists

Re: Anyway to know which users are connected to postgres? - Mailing list pgsql-general

From Tom Lane
Subject Re: Anyway to know which users are connected to postgres?
Date
Msg-id 12694.1011031351@sss.pgh.pa.us
Whole thread Raw
In response to Anyway to know which users are connected to postgres?  ("Peter E. Chen" <pchen3@jhmi.edu>)
List pgsql-general
Tree view 
"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

pgsql-general by date:

Previous
From: Wendy Chin
Date:
Subject: Calling a Stored Procedure using PHP
Next
From: Bruce Momjian
Date:
Subject: Re: gborg