Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id F40A82E01E8 for ; Sun, 30 Dec 2007 13:49:25 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 13110-08 for ; Sun, 30 Dec 2007 13:49:21 -0400 (AST) Received: from fmailhost01.isp.att.net (fmailhost01.isp.att.net [207.115.11.51]) by postgresql.org (Postfix) with ESMTP id 4A4912E0042 for ; Sun, 30 Dec 2007 13:48:48 -0400 (AST) Received: from [127.0.0.1] (adsl-153-8-204.gsp.bellsouth.net[70.153.8.204]) by isp.att.net (frfwmhc01) with ESMTP id <20071230174845H0100mrij7e>; Sun, 30 Dec 2007 17:48:46 +0000 X-Originating-IP: [70.153.8.204] Message-ID: <4777D9FB.3070904@reedyriver.com> Date: Sun, 30 Dec 2007 12:48:43 -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> <47778FE2.3050704@reedyriver.com> <4777BFD2.6090309@zeut.net> In-Reply-To: <4777BFD2.6090309@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/248 X-Sequence-Number: 27765 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? >> 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. > > Hmm. Since you already know about Apache's Piped Logs, how hard is it to put it all together? Or are you looking for a pre-built solution? Don't blame you for not wanting to reinvent the wheel. Maybe someone else has a suggestion. cheers, HH ------------ > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq > > -------------------------------- > Spam/Virus scanning by CanIt Pro > > For more information see > http://www.kgbinternet.com/SpamFilter.htm > > To control your spam filter, log in at > http://filter.kgbinternet.com >