Re: Finding active connections to postmaster

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