X-Original-To: pgsql-admin@postgresql.org Received: from localhost (unknown [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id 0DEA1925738 for ; Thu, 22 May 2003 20:16:12 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193:10024]) (amavisd-new) with ESMTP id 96006-08 for ; Thu, 22 May 2003 20:15:40 -0400 (EDT) Received: from lerami.lerctr.org (lerami.lerctr.org [207.158.72.11]) by developer.postgresql.org (Postfix) with ESMTP id A5ECA9258FF for ; Thu, 22 May 2003 18:08:38 -0400 (EDT) Received: from lerlaptop.iadfw.net (lerlaptop.iadfw.net [206.66.13.21]) (authenticated bits=0) by lerami.lerctr.org (8.12.9/8.12.9/20030515) with ESMTP id h4MM8Z9J025129; Thu, 22 May 2003 17:08:36 -0500 (CDT) Date: Thu, 22 May 2003 17:08:35 -0500 From: Larry Rosenman To: Alex.H.Pollock@WellsFargo.COM, pgsql-admin@postgresql.org Subject: Re: audit trail Message-ID: <389050000.1053641315@lerlaptop.iadfw.net> In-Reply-To: References: X-Mailer: Mulberry/3.0.3 (Linux/x86) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: by amavisd-milter (http://amavis.org/) X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/323 X-Sequence-Number: 8885 --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