Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 82FEB2E32A3 for ; Sun, 30 Dec 2007 14:09:07 -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 33247-10 for ; Sun, 30 Dec 2007 14:09:01 -0400 (AST) Received: from balder.scrooge.dk (unknown [194.192.15.69]) by postgresql.org (Postfix) with ESMTP id 1984B2E3261 for ; Sun, 30 Dec 2007 14:09:00 -0400 (AST) Received: from [213.237.12.36] (helo=PC) by balder.scrooge.dk with esmtpsa (TLS-1.0:RSA_AES_128_CBC_SHA:16) (Exim 4.50) id 1J92Wf-0003JI-4b for pgsql-admin@postgresql.org; Sun, 30 Dec 2007 19:04:41 +0100 From: =?iso-8859-1?Q?S=F8ren_Laursen?= To: References: <4776D003.9070702@zeut.net> <47778FE2.3050704@reedyriver.com> In-Reply-To: <47778FE2.3050704@reedyriver.com> Subject: Re: Apache Logging to PostgreSQL Date: Sun, 30 Dec 2007 19:09:06 +0100 Message-ID: <003701c84b0f$11ba8c10$352fa430$@dk> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable X-Mailer: Microsoft Office Outlook 12.0 Thread-Index: AchK+lir0O4uNdRFTx+VCYbnK/bAuQAE/jhQ Content-Language: da X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/249 X-Sequence-Number: 27766 Hi,=20 I got pglogd running on postgresql 8.1.4 a debian sarge installation. I = had to compile it myself and my apache2 configuration look like this. LogFormat "%t %D %>s %b %m %v %h \"%U\" \"%{Referer}i\" = \"%{User-agent}i\" \"%r\" %l %u" pglogd CustomLog "/var/log/apache2/pglogd_fifo" pglogd For a logtime ago I made some programs that can dump the tables in a = format that awstats can read and compute. Regards, S=F8ren Laursen -----Oprindelig meddelelse----- Fra: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] P=E5 vegne af H. Hall Sendt: 30. december 2007 13:33 Til: Matthew T. O'Connor; pgsql-admin@postgresql.org Emne: Re: [ADMIN] Apache Logging to PostgreSQL Matthew T. O'Connor wrote: > Hello, I've been looking into having apache log to postgresql, and it=20 > isn't clear to me what the best way to set this up is. The options=20 > that I see so far are: > > 1) Apache Pipe Logging: This seems simple enough, but I'm not sure=20 > what tool I would as the logging process? > > 2) pgLOGd: This isn't actively maintained anymore and apparently=20 > doesn't work with PG8.x > > 3) pglogger: Hasn't been updated since 2004, don't know if it's=20 > 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:=20 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 > > > ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings