Re: How to identify connected Users?

On Fri, 1 Dec 2000, Peter Eisentraut wrote:

PE> > is there any way to identify users which are currently connected to the
PE> > database? Does perhaps even exist a method to notify this users (e.g. to
PE> > close the connection)?
PE>
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. And, if
the scripts are running from the web server, there will be only
nobosy/httpd in most cases...

Sincerely,
D.Marck                                   [DM5020, DM268-RIPE, DM3-RIPN]
------------------------------------------------------------------------
*** Dmitry Morozovsky --- D.Marck --- Wild Woozle --- marck@rinet.ru ***
------------------------------------------------------------------------