Thanks Larry!
I was wondering whether the Statistics Collector in section 10.2 of the
Admin manual might be a way to not only create an audit trail of insert,
update, and delete, but all sql activity and who is doing it. Could the
pg_stat_activity view or the access functions be used for this? But maybe
this would not create a continuous stream, and activity would be missed?
Alex Pollock
WFSC Data Services District
Database Administration
-----Original Message-----
From: Larry Rosenman [mailto:ler@lerctr.org]
Sent: Thursday, May 22, 2003 2:02 PM
To: Alex.H.Pollock@WellsFargo.COM; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] audit trail
see the thread I had on the SQL list last week. Joe Conway posted a
WONDERFUL solution
using contrib/dblink.
LER
--On Thursday, May 22, 2003 11:46:24 -0700 Alex.H.Pollock@WellsFargo.COM
wrote:
> Does anyone know of a good way to create a continuous audit trail with no
> gaps within PostgreSQL that can tell who has done what at what time?
>
> Thanks.
>
> Alex Pollock
> WFSC Data Services District
> Database Administration
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749