> Good to know, but limited. to get the historical info, you'd have to continually
>spawn
> ps and either generate a lot of overhead or miss events.
>
> I think Stephen and I have roughly similar desires (ref "Logging Access" Sun, 03 Oct
>1999 23:09:06 -0400)
> It's not too hard to get the backend to report authentication requests, although as
>a DBA, I'd ultimately
> like logging to be up to modern-day quality expectations (e.g. filterable, routable,
>and securable) and to record not only basic session info, but statistical info to
>assist in tuning.
>
> So, returning to my own question. Is any such presently available that I'm ignorant
>of, or, failing that,
> may I be of assitance in realizing such a facility?
The postmaster/postgres -d option can echo tons of information you many need.
Postmaster -d will show connections, and postgres -d shows queries and
other info. Postgres -E is good too.
--
Bruce Momjian | http://www.op.net/~candle
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
************
