X-Original-To: pgsql-admin@postgresql.org Received: from localhost (unknown [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id 459079254DA for ; Thu, 22 May 2003 18:38:09 -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 70328-04 for ; Thu, 22 May 2003 18:37:38 -0400 (EDT) Received: from lerami.lerctr.org (lerami.lerctr.org [207.158.72.11]) by developer.postgresql.org (Postfix) with ESMTP id BDF4D925EEF for ; Thu, 22 May 2003 17:02:09 -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 h4ML269J019073; Thu, 22 May 2003 16:02:07 -0500 (CDT) Date: Thu, 22 May 2003 16:02:06 -0500 From: Larry Rosenman To: Alex.H.Pollock@WellsFargo.COM, pgsql-admin@postgresql.org Subject: Re: audit trail Message-ID: <330580000.1053637326@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/317 X-Sequence-Number: 8879 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