Re: audit trail

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

In response to

Browse pgsql-admin by date

  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