Re: Audit trail - Mailing list pgsql-general

From Jeff Fitzmyers
Subject Re: Audit trail
Date
Msg-id E2B31091-550A-11D7-9482-000A959C6000@cloverpub.com
Whole thread Raw
In response to Audit trail  (James Gregory <james@anchor.net.au>)
Responses Re: Audit trail  (James Gregory <james@anchor.net.au>)
List pgsql-general
> I am wondering if anyone has any good solutions for having postgres
> leave an audit trail.

I had 2 tables that needed a simple audit trail. It was very easy to
set up using php.

A few lines of code within transactions:
When a row is created, log it.
When any changes happen, log them, who did them and why.

I never felt I needed all the info for each row - just the changes.

Jeff


pgsql-general by date:

Previous
From: Joshua Moore-Oliva
Date:
Subject: Re: Audit trail
Next
From: James Gregory
Date:
Subject: Re: Audit trail