| From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | some requests on auditing |
| Date: | 2016-08-30 14:12:23 |
| Message-ID: | CAFj8pRDR8CYFT3ewupW1NbVJh=9we0+n6j1gussnWe+_0=mQhg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi
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 | Date | Subject | |
|---|---|---|---|
| Next Message | Jesper Pedersen | 2016-08-30 14:49:45 | pageinspect: Hash index support |
| Previous Message | Tom Lane | 2016-08-30 14:00:39 | Re: standalone backend PANICs during recovery |