Home > mailing lists

some requests on auditing - Mailing list pgsql-hackers

From	Pavel Stehule
Subject	some requests on auditing
Date	August 30, 2016 14:13:17
Msg-id	CAFj8pRDR8CYFT3ewupW1NbVJh=9we0+n6j1gussnWe+_0=mQhg@mail.gmail.com Whole thread Raw
Responses	Re: some requests on auditing
List	pgsql-hackers

I am working on pgaudit customization for one my customer.

There are few requests:

1. flat format without complex types, without nesting - CSV is ideal.

2. all important attributes should be separated - is not possible to search in original queries: table name, database name, role name, rights.

3. if it is possible - own log file

4. one statement can have more rows (flat format is required), but it should be logged only once success/failed

5. any activity should be logged

The point @4 is hard to implement - static audit should be linked with result together. There is not any top level hook.

Regards

Pavel

From: Tom Lane
Date: 30 August 2016, 14:00:59
Subject: Re: standalone backend PANICs during recovery

From: Jesper Pedersen
Date: 30 August 2016, 14:49:58
Subject: pageinspect: Hash index support