Re: pgaudit - an auditing extension for PostgreSQL

On Fri, May 2, 2014 at 3:19 PM, Ian Barwick <ian(at)2ndquadrant(dot)com> wrote:
> Hi
>
> Here is an initial version of an auditing extension for Postgres to
> generate log output suitable for compiling a comprehensive audit trail
> of database operations.

You added this into CF, but its patch has not been posted yet. Are you planning
to make a patch?

> Planned future improvements include:
>
> 1. Additional logging facilities, including to a separate audit
> log file and to syslog, and potentially logging to a table
> (possibly via a bgworker process). Currently output is simply
> emitted to the server log via ereport().
>
> 2. To implement per-object auditing configuration, it would be nice to use
> extensible reloptions (or an equivalent mechanism)

Is it possible to implement these outside PostgreSQL by using hooks?
If not, it might be better to implement audit feature in core from the
beginning.

Regards,

--
Fujii Masao