From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | Stuart Bishop <stuart(at)stuartbishop(dot)net> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: log_statement and syslog severity |
Date: | 2010-03-11 01:42:59 |
Message-ID: | 201003110142.o2B1gxs20866@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Stuart Bishop wrote:
-- Start of PGP signed section.
>
>
> On Wed, Mar 10, 2010 at 8:51 AM, Bruce Momjian <bruce(at)momjian(dot)us> wrote:
> > Greg Sabino Mullane wrote:
> >> Bruce replied:
> >> ...
> >> >> This means that, even using syslog as a destination, it's not possible for
> >> >> me to filter statements without some sort of log-text parsing, which I'd
> >> >> prefer to avoid on effort, performance and data-integrity grounds.
> >>
> >> > Our logging system is very flexible, but not work-free on the user end.
> >> > I don't see us changing things in that area.
> >>
> >> Bruce, that's a little harsh, I think the original poster has a legitimate
> >> request. Personally, I'd love to be able to split the logs on various things,
> >> the most important to me being durations and per-database. I looked at the
> >> code about a year ago to see how hard this would be and found it non-trivial
> >> (for me), as we're really assuming hard things go to a single filehandle.
> >> It's definitely an area for improvement, and should be a TODO if not already.
> >
> > This issue has been discussed and I think the community conclusion was
> > that this should not be done by the database but rather by external
> > tools. ?I think I was giving an accurate portrayal of the odds of this
> > getting added. ?I do not think there is enough support for this to be a
> > TODO item.
>
> How do you plug in this external tool?
I think the real problem with log splitting in the server is designing a
clean API to do this, and I haven't seen one yet.
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
PG East: http://www.enterprisedb.com/community/nav-pg-east-2010.do
From | Date | Subject | |
---|---|---|---|
Next Message | jgirvin | 2010-03-11 01:54:04 | dst question |
Previous Message | Chris Travers | 2010-03-11 01:16:44 | Naming conventions for lots of stored procedures |