Обсуждение: audit trail
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
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
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
--On Thursday, May 22, 2003 14:57:44 -0700 Alex.H.Pollock@WellsFargo.COM wrote: > 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? I don't know, but if you find out, I'm all eyes. LER -- 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