Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id A34E9633EA7; Thu, 27 Aug 2009 15:31:51 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 50035-07; Thu, 27 Aug 2009 18:31:31 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from out02.mta.xmission.com (out02.mta.xmission.com [166.70.13.232]) by mail.postgresql.org (Postfix) with ESMTP id 98566633212; Thu, 27 Aug 2009 15:31:26 -0300 (ADT) Received: from in01.mta.xmission.com ([166.70.13.51]) by out02.mta.xmission.com with esmtp (Exim 4.62) (envelope-from ) id 1Mgjkq-00014d-3K; Thu, 27 Aug 2009 12:31:24 -0600 Received: from [208.187.158.94] (helo=[172.16.1.221]) by in01.mta.xmission.com with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.69) (envelope-from ) id 1Mgjkp-0002Uu-W8; Thu, 27 Aug 2009 12:31:24 -0600 Message-ID: <4A96D0FB.5010609@gmail.com> Date: Thu, 27 Aug 2009 12:31:23 -0600 From: Rob Sargent User-Agent: Thunderbird 2.0.0.23 (X11/20090817) MIME-Version: 1.0 To: Alvaro Herrera CC: Nathaniel Smith , pgsql-general@postgresql.org, pgsql-sql@postgresql.org Subject: Re: [SQL] Data audit trail techniques in postgresql References: <20090827122831.7a780cdb@gibson.summersault.com> <20090827173617.GK11213@alvh.no-ip.org> In-Reply-To: <20090827173617.GK11213@alvh.no-ip.org> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-XM-SPF: eid=; ; ; mid=; ; ; hst=in01.mta.xmission.com; ; ; ip=208.187.158.94; ; ; frm=robjsargent@gmail.com; ; ; spf=neutral X-SA-Exim-Connect-IP: 208.187.158.94 X-SA-Exim-Rcpt-To: alvherre@commandprompt.com, nate@summersault.com, pgsql-general@postgresql.org, pgsql-sql@postgresql.org, robjsargent@gmail.com X-SA-Exim-Mail-From: robjsargent@gmail.com X-SA-Exim-Version: 4.2.1 (built Thu, 25 Oct 2007 00:26:12 +0000) X-SA-Exim-Scanned: No (on in01.mta.xmission.com); Unknown failure X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.925 tagged_above=-10 required=5 tests=AWL=-0.185, BAYES_20=-0.74 X-Spam-Level: X-Archive-Number: 200908/1122 X-Sequence-Number: 152323 tablelog doesn't appear any more lively than the OPs audittrail2. Alvaro Herrera wrote: > Nathaniel Smith wrote: > > >> What do others use to accomplish this? Do most pg users just write >> triggers by hand? Or is there some nice auditing module that Google >> just isn't revealing to me? >> > > I think tablelog (to be found in pgfoundry too) is the most commonly > used audit module. > >