Thread: Instructions/status of modpglogger
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
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
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@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Jeff Ross Sent: Thursday, November 11, 2010 11:51 PM To: pgsql-general@postgresql.org Subject: Re: [GENERAL] Instructions/status of modpglogger 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Hi ! Thank you. But this is out my current linux experience ;-) I'll look for PGLOGD or let apache lo to a pipe and write the pipe receiver with mono [and NpgSql]. Thanks! ++mabra -----Original Message----- From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Jeff Ross Sent: Thursday, November 11, 2010 11:51 PM To: pgsql-general@postgresql.org Subject: Re: [GENERAL] Instructions/status of modpglogger 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general