> > Agreed. If that is what is required, I think you can forget ps status
> > on that platform.
>
> Bruce,
>
> have you taken a look at my statistics collector stuff yet?
> The view pgstat_activity shows datid, datname, procpid,
> usesysid, usename and current_query per backend.
>
> The code still needs some more work, but as it is it's ready
> to apply as soon as 7.1 is out the door. All that is totally
> OS independant, restricts the display of querystrings to
> postgres superusers and works remotely.
>
[ Sent only to ports]
Yes, that is what I will do for 7.2, but that may be a year away.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026