Re: Logging Apache web server log information to Postgre

That is the order that I start everything. The web server and database are
on the same box. Here are the contents of my pglogd.log

[Wed Feb 20 10:27:18 2002] Resuming normal operation. [0]
[Wed Feb 20 10:27:18 2002] Closed inherited file descriptiors: [3]
[Wed Feb 20 10:27:18 2002] Database connection [pglogd] opened. [0]
[Wed Feb 20 10:27:40 2002] FIFO Named Pipe [/tmp/.f.PGLOGD] opened. [1]
[Wed Feb 20 10:27:40 2002] Overflow file open for reading: [2]
[Wed Feb 20 10:27:40 2002] Overflow file open for writing: [3]
[Wed Feb 20 10:27:40 2002] Overflow file entries found queued: [0]
[Wed Feb 20 10:27:40 2002] FIFO End Of File received. [0]
[Wed Feb 20 10:27:40 2002] Normal Shutdown [0]
[Wed Feb 20 10:27:40 2002] Server State: errno: [9]
[Wed Feb 20 10:27:40 2002] Server State: iHaveEntry: [0]
[Wed Feb 20 10:27:40 2002] Server State: iHaveReadData: [0]
[Wed Feb 20 10:27:40 2002] Server State: iOverflowEntry: [0]
[Wed Feb 20 10:27:40 2002] Server State: iOverFlowQueued: [0]
[Wed Feb 20 10:27:40 2002] Server State: iOverFlowProcessed: [0]
[Wed Feb 20 10:27:40 2002] Server State: iBackendDown: [0]
[Wed Feb 20 10:27:40 2002] Server State: iBackendBusy: [0]

-----Original Message-----
From: Singer Wang [mailto:swang(at)cs(dot)dal(dot)ca]
Sent: Friday, February 22, 2002 6:17 AM
To: Keller, Sid
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] Logging Apache web server log information to
Postgresql

On Thu, Feb 21, 2002 at 02:34:10PM -0600, Keller, Sid wrote:
> I was wondering if anyone has installed the pglogd program. It is a
program
> that sends Apache web server log information to a Postgresql database. I
> have successfully compiled it and have the other programs (Apache,
> Postgresql) working correctly. However, when I start Apache after
starting
> the database and then pglogd, the pglogd daemon dies. If anyone has this
> setup correctly and is willing to help, I can send you some details about
my
> setup. Oh, my O/S is OpenBSD 3.0.
>
Hello......

I use it as well for my intranet site... the appropiate start order is..

start postgresql
start pglogd
start apache

--
Singer XJ Wang - swang(at)cs(dot)dal(dot)ca - ICQ: 201253
-------------------------------------------------------------------------
"WAR stands for We Are Right!"