Re: How to identify connected Users?

Dmitry Morozovsky writes:

> PE> ps ax | grep postgres
> PE>
> PE> is the best way to go.
>
> Nope. Using this you can identify UNIX users, instead of PG users.

Wrong.

$ ps ax | grep postgres
 1236 pts/1    S      0:00 psql template1 -U postgres
 1237 pts/1    S      0:00 /usr/bin/postgres localhost postgres template1 idle

> And, if the scripts are running from the web server, there will be
> only nobosy/httpd in most cases...

The question was how to find out what users are connected to the database
-- there's your answer.  Or do you suggest figuring out the identity of
the person that connected to your web page?

--
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/