Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 10E102E2E67 for ; Sat, 29 Dec 2007 18:54:09 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 06528-09 for ; Sat, 29 Dec 2007 18:54:05 -0400 (AST) Received: from smtp122.sat.emailsrvr.com (smtp122.sat.emailsrvr.com [66.216.121.122]) by postgresql.org (Postfix) with ESMTP id 0329F2E00D6 for ; Sat, 29 Dec 2007 18:54:06 -0400 (AST) Received: from relay2.relay.sat.mlsrvr.com (localhost [127.0.0.1]) by relay2.relay.sat.mlsrvr.com (SMTP Server) with ESMTP id 62840182F86 for ; Sat, 29 Dec 2007 17:54:04 -0500 (EST) Received: by relay2.relay.sat.mlsrvr.com (Authenticated sender: matthew-AT-zeut.net) with ESMTP id 0D923182CB1 for ; Sat, 29 Dec 2007 17:54:03 -0500 (EST) Message-ID: <4776D003.9070702@zeut.net> Date: Sat, 29 Dec 2007 15:53:55 -0700 From: "Matthew T. O'Connor" User-Agent: Thunderbird 2.0.0.9 (Windows/20071031) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Apache Logging to PostgreSQL Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/241 X-Sequence-Number: 27758 Hello, I've been looking into having apache log to postgresql, and it isn't clear to me what the best way to set this up is. The options that I see so far are: 1) Apache Pipe Logging: This seems simple enough, but I'm not sure what tool I would as the logging process? 2) pgLOGd: This isn't actively maintained anymore and apparently doesn't work with PG8.x 3) pglogger: Hasn't been updated since 2004, don't know if it's production quality or not. 4) pglogger Apache Module: Also hasn't been updated since 04. Doesn't anyone have any experience / advice for me? Thanks, Matt