Re: [HACKERS] keeping track of connections

Brett M writes:
> On Wed, 3 June 1998, at 00:11:01, Bruce Momjian wrote:
>
> > Good question.  Postmaster does not have access to the system tables, so
> > it can't access them.  You could add a debug option to show it in the
> > server logs, or add it to the -d2 debug option that already shows SQL
> > statements.
>
> How about something like this: a pool of shared memory where this
> information is stored, and then a view which calls a set of functions
> to return the information from the shared memory?
>
> Apache does something similar.

I am curious, what is it you are trying to accomplish with this? Are you
trying to build a persistant log that you can query later for billing
or load management/capacity planning information? Are you trying to monitor
login attempts for security auditing? Are you trying to catch logins in
real time for some sort of middleware integration?

Here we are discussion solutions, but I don't even know what the problem
is. So, please describe what is needed in terms of requirements/functionality.

Thanks

-dg


David Gould            dg@illustra.com           510.628.3783 or 510.305.9468
Informix Software  (No, really)         300 Lakeside Drive  Oakland, CA 94612
"Don't worry about people stealing your ideas.  If your ideas are any
 good, you'll have to ram them down people's throats." -- Howard Aiken