Re: logging hook for database audit - Mailing list pgsql-hackers

From Tom Lane
Subject Re: logging hook for database audit
Date
Msg-id 23596.1252593862@sss.pgh.pa.us
Whole thread Raw
In response to logging hook for database audit  (Itagaki Takahiro <itagaki.takahiro@oss.ntt.co.jp>)
Responses Re: logging hook for database audit
List pgsql-hackers
Itagaki Takahiro <itagaki.takahiro@oss.ntt.co.jp> writes:
> For the purpose, I'll submit to add "logging hook" in core, rather than
> fixed features like log_min_messages-per-destination.

The more functionality you put inside elog.c, the higher the probability
that it will fail when the going gets tough (out of memory, for instance),
leaving you with no idea of what went wrong.  I also dislike the idea
of having such critical behavior dependent on a loadable module, as that
introduces a whole set of failure modes of its own, particularly with
regard to early-startup behavior.

I think the proposal to put a hook here is an end-run to try to avoid
getting a detailed feature proposal past the criticism of pgsql-hackers,
and I don't like that either.

I can see the potential value of per-destination minimum message levels,
so maybe you should just propose that.  But this is a bad place for a
hook.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Emmanuel Cecchet
Date:
Subject: COPY enhancements
Next
From: Tom Lane
Date:
Subject: Re: Disable and enable of table and column constraints