Re: users work now with PostgreSQL - Mailing list pgsql-admin

From Ross J. Reedstrom
Subject Re: users work now with PostgreSQL
Date
Msg-id 20001212105026.B25559@rice.edu
Whole thread Raw
In response to users work now with PostgreSQL  ("Michael B. Babakov" <M.Babakov@sochi.net.ru>)
Responses Re: users work now with PostgreSQL  ("Michael B. Babakov" <M.Babakov@sochi.net.ru>)
List pgsql-admin
It's encoded in the process environment, so the 'ps' command will
give you what you want:

On my Debian linux box, I do something like:

reedstrm@cooker:~$ ps ax | grep '[/]postgres '
18737 ?        S      0:02 /usr/lib/postgresql/bin/postmaster -b /usr/lib/postgresql/bin/postgres -B 128 -D
/var/lib/postgres/data-d 2 -i -o -E 
 8696 ?        S      0:00 /usr/lib/postgresql/bin/postgres localhost reedstrm reedstrm idle
                       
 8697 ?        S      0:00 /usr/lib/postgresql/bin/postgres 192.168.1.190 reedstrm idas idle
                       
reedstrm@cooker:~$


This shows you the postmaster, and two clients connected: Both are
user 'reedstrm' one is connected to database 'reedstrm' and is a local
conenction, the other to 'idas' from a remote machine (I faked the IP).
Both are currently idle.

The odd form of the grep argument is just to filter out the psql client,
and the grep process itself. If you want something completely automated,
say to use in a script of some sort, I'd go with (note that the exact
syntax depends on your version of unix):

reedstrm@cooker:~$ ps ax | grep '[/]usr/lib/postgresql/bin/postgres' |
grep -v postmaster | awk '{print $6,$7,$8,$9}'

localhost reedstrm reedstrm idle
192.168.1.190 reedstrm idas idle

Ross

On Mon, Dec 11, 2000 at 11:39:01AM +0300, Michael B. Babakov wrote:
> Good day!
>
> How to look what users work now with PostgreSQL?
>
--
Open source code is like a natural resource, it's the result of providing
food and sunshine to programmers, and then staying out of their way.
[...] [It] is not going away because it has utility for both the developers
and users independent of economic motivations.  Jim Flynn, Sunnyvale, Calif.

pgsql-admin by date:

Previous
From: "Graham Vickrage"
Date:
Subject: RE: Index usage ?
Next
From: Stephan Szabo
Date:
Subject: Re: Foriegn key constraint