Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 68F496326C5; Thu, 27 Aug 2009 14:36:36 -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 39800-03; Thu, 27 Aug 2009 17:36:20 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from spinlock.commandprompt.com (host-215.commandprompt.net [207.173.203.215]) by mail.postgresql.org (Postfix) with ESMTP id 126116321D5; Thu, 27 Aug 2009 14:36:21 -0300 (ADT) Received: from perhan.alvh.no-ip.org (190-95-25-134.bk17-dsl.surnet.cl [190.95.25.134]) by spinlock.commandprompt.com (Postfix) with ESMTPSA id 4051C348199; Thu, 27 Aug 2009 10:34:34 -0700 (PDT) Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id B57FC6E951; Thu, 27 Aug 2009 13:36:17 -0400 (CLT) Date: Thu, 27 Aug 2009 13:36:17 -0400 From: Alvaro Herrera To: Nathaniel Smith Cc: pgsql-general@postgresql.org, pgsql-sql@postgresql.org Subject: Re: Data audit trail techniques in postgresql Message-ID: <20090827173617.GK11213@alvh.no-ip.org> References: <20090827122831.7a780cdb@gibson.summersault.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20090827122831.7a780cdb@gibson.summersault.com> User-Agent: Mutt/1.5.20 (2009-06-14) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.545 tagged_above=-10 required=5 tests=AWL=0.054, BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 200908/1120 X-Sequence-Number: 152321 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. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support