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/
