Audit trail ? - Mailing list pgsql-general

From Zlatko Matic
Subject Audit trail ?
Date
Msg-id 001101c5643b$218883d0$e7321dc3@zlatkovyfkpgz6
Whole thread Raw
In response to Question: migrate  (Hrishikesh Deshmukh <hdeshmuk@gmail.com>)
Responses Re: Audit trail ?
Re: Audit trail ?
List pgsql-general
Hello.

I must have audit trail of all insert/update/delete on several table. I have
several questions regarding that:

1. Is it better to have one audit trail table that collects
insert/update/delete of all audited tables, or it is better to have separate
audit trail table for every audited table ?
2. To use triggers or rules ? Example for both ?
3. Could someone give me an example of a successfull audit trail solution ?

I'm running on lack of time, so any help would be precious...

Thanks.


pgsql-general by date:

Previous
From: Christopher Browne
Date:
Subject: Re: Fast request for version checking....
Next
From: Bob
Date:
Subject: Re: Audit trail ?