Instructions/status of modpglogger

Started by Nonameover 15 years ago4 messagesgeneral
Jump to latest
#1Noname
mabra@manfbraun.de

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

#2Jeff Ross
jross@wykids.org
In reply to: Noname (#1)
Re: 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

#3Noname
mbwl@manfbraun.de
In reply to: Jeff Ross (#2)
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@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

#4Noname
mabra@manfbraun.de
In reply to: Jeff Ross (#2)
Re: Instructions/status of modpglogger

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