| From: | Larry Rosenman <ler(at)lerctr(dot)org> |
|---|---|
| To: | Alex(dot)H(dot)Pollock(at)WellsFargo(dot)COM, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: audit trail |
| Date: | 2003-05-22 22:08:35 |
| Message-ID: | 389050000.1053641315@lerlaptop.iadfw.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
--On Thursday, May 22, 2003 14:57:44 -0700 Alex(dot)H(dot)Pollock(at)WellsFargo(dot)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(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2003-05-22 22:20:54 | Re: Table size on disk |
| Previous Message | David Olbersen | 2003-05-22 22:04:19 | CREATE GROUP question |