A basic audit-trail can be implemented by using Postresql triggers [1]. It logs client IP, statement, before & after changes and can be enabled on selected tables. [1] https://wiki.postgresql.org/wiki/Audit_trigger_91plus