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(at)gmx(dot)net http://yi.org/peter-e/