pg_audit_users - Auditing user activity

From: Pierre <pinaraf(at)pinaraf(dot)info>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_audit_users - Auditing user activity
Date: 2014-12-20 14:32:23
Message-ID: 1539105.VBOGNDHCGT@peanuts2
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi

I'm working on a web credit card payment solution, so in a PCI-DSS environment,
and the auditors gave me trouble with one specific audit point for the
PostgreSQL database. They require the list of users in the database that had no
activity in the past 90 days to be deleted.
So far, it seems the only solution to implement that in PostgreSQL would be to
parse the log, hoping not to lose any line.
That seems too risky for me, so I wrote my own solution for this issue, and I
would like to submit it here for review/suggestion and to help other users
facing the same needs. Since it's very small, I've taken the liberty of
attaching it to this email.
The code is more or less «inspired» by pg_stat_statements. So far I've not
implemented saving upon restarts of the database, I'll probably do it in the
next days/weeks. It has been tested against PostgreSQL 9.2 only, but I'll test
9.3 and 9.4 soon.

Thanks

Pierre

Attachment Content-Type Size
pg_audit_users-0.1.tar.bz2 application/x-bzip-compressed-tar 3.7 KB

Browse pgsql-general by date

  From Date Subject
Next Message Pierre Ducroquet 2014-12-20 14:40:33 pg_audit_users - Auditing user activity
Previous Message Andomar 2014-12-20 12:00:36 Monitoring query plan cache