Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 9A8102E304B for ; Sun, 30 Dec 2007 08:32:46 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 62577-05 for ; Sun, 30 Dec 2007 08:32:32 -0400 (AST) Received: from fmailhost04.isp.att.net (fmailhost04.isp.att.net [207.115.11.54]) by postgresql.org (Postfix) with ESMTP id C1FC32E304A for ; Sun, 30 Dec 2007 08:32:38 -0400 (AST) Received: from [127.0.0.1] (adsl-153-8-204.gsp.bellsouth.net[70.153.8.204]) by isp.att.net (frfwmhc04) with ESMTP id <20071230123236H0400a24pqe>; Sun, 30 Dec 2007 12:32:37 +0000 X-Originating-IP: [70.153.8.204] Message-ID: <47778FE2.3050704@reedyriver.com> Date: Sun, 30 Dec 2007 07:32:34 -0500 From: "H. Hall" User-Agent: Thunderbird 2.0.0.9 (Windows/20071031) MIME-Version: 1.0 To: "Matthew T. O'Connor" , pgsql-admin@postgresql.org Subject: Re: Apache Logging to PostgreSQL References: <4776D003.9070702@zeut.net> In-Reply-To: <4776D003.9070702@zeut.net> 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/245 X-Sequence-Number: 27762 Matthew T. O'Connor wrote: > 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 Here's an article that might interest you: Datamining Apache Logs with PostgreSQL You can find it at: http://www.onlamp.com/pub/a/onlamp/2005/03/03/pg_datamining.html --cheers > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster > > >