| From: | Dmitry Morozovsky <marck(at)rinet(dot)ru> |
|---|---|
| To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
| Cc: | Jens Hartwig <jhartwig(at)debis(dot)com>, PostgreSQL Admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: How to identify connected Users? |
| Date: | 2000-12-02 14:15:51 |
| Message-ID: | Pine.BSF.4.21.0012021714320.27250-100000@woozle.rinet.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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(at)rinet(dot)ru ***
------------------------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2000-12-02 16:31:12 | Re: How to identify connected Users? |
| Previous Message | Bryan Bateman | 2000-12-02 07:53:18 | Looking for a hosting environment that has the following features |