Re: Instructions/status of modpglogger

Hallo !

Much thanks, I'll give it a try !

I have the build tools, but never used them. I am new
to linux development and think, I hard time will come ;-)

br++mabra

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Jeff Ross
Sent: Thursday, November 11, 2010 11:51 PM
To: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Instructions/status of modpglogger

On 11/11/10 14:48, mabra(at)manfbraun(dot)de wrote:
> Hi All !
>
> I just started with postgres and wish to use a postgres db as a logging
> destination for my apache webserver in my debian environment [this was not
> the reason to start with postgres]. Does someone, if this works [thre is
no
> package in my distribution]?
>
> Any tips would be great!
>
> br++mabra
>
>
>

If that doesn't work (and something that hasn't been updated since 2004
is doubtful) there is an opensource utility called pglogd

http://www.digitalstratum.com/oss/pglogd

that works pretty well for me through 8.4.5. I haven't tried it yet on 9.

Digital Stratum EOLed pglogd and I sort of tried to fork the project and
fix a couple of things that it doesn't do very well--like allow the
backend to shutdown because it opens a connection and never lets it
go--but my C skills are lacking and time more so.

If the version from Digital Stratum doesn't work and you (or anyone else
for that matter) would like my slightly modified version let me know off
list and I'll get it to you.

Jeff Ross