audit trail - Mailing list pgsql-general

From Johnson, Shaunn
Subject audit trail
Date
Msg-id 73309C2FDD95D11192E60008C7B1D5BB04C73E5F@snt452.corp.bcbsm.com
Whole thread Raw
Responses Re: audit trail  (Mark Stosberg <mark@summersault.com>)
List pgsql-general

Running PostgreSQL 7.2.1 on RedHat Linux 7.2.

I'm interested in turning on an audit trail
to note what tables have been updated, created,
selected from, who did it, what machine / connection
they're using, etc.

I saw something in the n.g. where something
similar has been done by a trigger and a
table with this info is kept.

I'm also sure this is yet another perfect time
to learn a new facet about PostgreSQL.  So,
how do I create / manage an audit trail?

Thanks!

-X

pgsql-general by date:

Previous
From: "Orr, Steve"
Date:
Subject: Re: OSS RDBMS Features Compared
Next
From: "Marc G. Fournier"
Date:
Subject: Re: OSS RDBMS Features Compared