search

2ndQuadrant / audit-trigger

Simple, easily customised trigger-based auditing for PostgreSQL (Postgres). See also pgaudit.
Other
659 stars 241 forks source link

Add option to not track inserts. #42

Closed peterbecker closed 3 years ago

peterbecker commented 3 years ago

This has the option to not trigger the audit on inserts. Should be backwards compatible, although I must admit I did not test that as I don't have a setup for doing so.

We have tables that already have the insertion timestamp and we are not too worried about some of the other data tracked in the audits (query/client/etc).

Our use case is tracking changes coming through an ETL pipeline, so there is only one writer, but we don't know what updates we see and how frequently. For that scenario tracking only changes to existing data is more useful, and we'd prefer not going with a fully customized solution.

peterbecker commented 3 years ago

Sorry - got to redo this. Wrong author email.