Re: Finding active connections to postmaster - Mailing list pgsql-admin

From Bramsi Prenata
Subject Re: Finding active connections to postmaster
Date
Msg-id 20010927162051.4e0c596c.bramsi@cakraweb.com
Whole thread Raw
In response to Finding active connections to postmaster  (drt@un.bewaff.net (Doobee R. Tzeck))
List pgsql-admin
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


pgsql-admin by date:

Previous
From: "Rainer Mager"
Date:
Subject: turning on debug without restarting postgres
Next
From: "Martins Zarins"
Date:
Subject: Re: Finding active connections to postmaster