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: | Raw Message | Whole Thread | 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 |