Re: PostgreSQL Audit Extension - Mailing list pgsql-hackers

From Joe Conway
Subject Re: PostgreSQL Audit Extension
Date
Msg-id 56B4F24A.9030704@joeconway.com
Whole thread Raw
In response to Re: PostgreSQL Audit Extension  (Stephen Frost <sfrost@snowman.net>)
Responses Re: PostgreSQL Audit Extension
List pgsql-hackers
On 02/05/2016 10:16 AM, Stephen Frost wrote:
> An in-core auditing solution would provide us with proper grammar
> support, ability to directly mark objects for auditing in the catalog,
> allow us to much more easily maintain auditing capability over time as
> a small incremental bit of work for each new feature (with proper
> in-core infrastructure for it) and generally be a far better technical
> solution.  Leveraging the GRANT system is quite cute, and does work, but
> it's certainly non-intuitive and is only because we've got no better
> way, due to it being implemented as an extension.

I think one additional item needed would be the ability for the audit
logs to be sent to a different location than the standard logs.

> To make true progress towards that, however, we need to get past
> the thinking that auditing doesn't need to be in-core or that it should
> be a second-class citizen feature or that we don't need it in PG.

+1

Joe

--
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterprises
Consulting, Training, & Open Source Development


pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: PostgreSQL Audit Extension
Next
From: Stephen Frost
Date:
Subject: Re: PostgreSQL Audit Extension