Skip site navigation (1) Skip section navigation (2)

Re: Finding active connections to postmaster

From: Bramsi Prenata <bramsi(at)cakraweb(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Finding active connections to postmaster
Date: 2001-09-27 09:20:51
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
On 27 Sep 2001 10:22:02 +0200
drt(at)un(dot)bewaff(dot)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(at)al-quds bramsi]$ ps ax | grep postgres | grep -v grep | grep -v psql | awk -F " " {'print $7'}

but i'm sorry, i do not know what they are doing rigth now.

Hope can help you.

Best regards,
Bramsi Prenata

In response to

pgsql-admin by date

Next:From: Martins ZarinsDate: 2001-09-27 09:35:55
Subject: Re: Finding active connections to postmaster
Previous:From: Rainer MagerDate: 2001-09-27 08:42:27
Subject: turning on debug without restarting postgres

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group