Re: Instructions/status of modpglogger - Mailing list pgsql-general

From Jeff Ross
Subject Re: Instructions/status of modpglogger
Date
Msg-id 4CDC737B.6050205@wykids.org
Whole thread Raw
In response to Instructions/status of modpglogger  (<mabra@manfbraun.de>)
Responses Re: Instructions/status of modpglogger  (<mbwl@manfbraun.de>)
Re: Instructions/status of modpglogger  (<mabra@manfbraun.de>)
List pgsql-general
On 11/11/10 14:48, mabra@manfbraun.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



pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Seeking advice on database replication.
Next
From: Digimer
Date:
Subject: Problem using CASTed timestamp column