On 27 Sep 2001 10:22:02 +0200
drt@un.bewaff.net (Doobee R. Tzeck) wrote:
>
> I want to list which users are conected to postmaster and what
> they are doing. I guess I have overseen something but I wasn't
> able to find any information on doing this in the handbook, FAQ
> or mailinglist archives.
>
> Is it possible to list active connectons? How?
to list active connection, you can try this command in shell prompt
[bramsi@al-quds bramsi]$ ps ax | grep postgres | grep -v grep | grep -v psql | awk -F " " {'print $7'}
postgres
but i'm sorry, i do not know what they are doing rigth now.
Hope can help you.
Best regards,
Bramsi Prenata