Bruce Momjian wrote:
> > 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.
What about an option to send to syslog? With debugging messages flagged
as such, etc, using the full syslog phalanx of options. Then, it's
filterable, routable, and securable.
Of course, the framework for using syslog may already be there -- for
that matter, one could write a perl script (or C progam) to take the
existing log output, segregate it, and pipe into syslog with the proper
options set.
The sidebar to this is "Which supported platforms don't have syslog?"
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
************
