Hi
I am sending some notes, experience about usage of pgAudit.
pgAudit provides basic functionality and usually is good enough. But it is not good enough for some applications in financial services.
The requirements:
1. structured output - attached query is not good enough - column name, table name, schema, database, role should be separated
2. separated log (log file) with guaranteed write - fsync after every line means significant performance issue, but fsync every 1sec (or defined interval) is acceptable
3. security issues - not enough access rights to database object should be processed and logged in audit log too.
Regards
Pavel