Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 3DA482E2EFF for ; Sun, 30 Dec 2007 11:57:21 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 91729-06 for ; Sun, 30 Dec 2007 11:57:07 -0400 (AST) Received: from smtp172.sat.emailsrvr.com (smtp172.sat.emailsrvr.com [66.216.121.172]) by postgresql.org (Postfix) with ESMTP id 8A0762E02CF for ; Sun, 30 Dec 2007 11:57:13 -0400 (AST) Received: from relay7.relay.sat.mlsrvr.com (localhost [127.0.0.1]) by relay7.relay.sat.mlsrvr.com (SMTP Server) with ESMTP id 3DAFD1B401C; Sun, 30 Dec 2007 10:57:12 -0500 (EST) Received: by relay7.relay.sat.mlsrvr.com (Authenticated sender: matthew-AT-zeut.net) with ESMTP id E5A751B4006; Sun, 30 Dec 2007 10:57:11 -0500 (EST) Message-ID: <4777BFD2.6090309@zeut.net> Date: Sun, 30 Dec 2007 08:57:06 -0700 From: "Matthew T. O'Connor" User-Agent: Thunderbird 2.0.0.9 (Windows/20071031) MIME-Version: 1.0 To: "H. Hall" CC: pgsql-admin@postgresql.org Subject: Re: Apache Logging to PostgreSQL References: <4776D003.9070702@zeut.net> <47778FE2.3050704@reedyriver.com> In-Reply-To: <47778FE2.3050704@reedyriver.com> 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/247 X-Sequence-Number: 27764 >> 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? > Here's an article that might interest you: > > You can find it at: > http://www.onlamp.com/pub/a/onlamp/2005/03/03/pg_datamining.html Yeah, I came across this article already, but the thing that it doesn't address is the best way to get the log data into PG realtime, he does a manual import of the data which I don't want to do.