[rsyslog] rsyslog 5.3.5 (v5-beta) released
Rainer Gerhards
rgerhards at hq.adiscon.com
Fri Dec 11 15:25:32 CET 2009
I am not sure if you judge the right thing. The way ompgsql is programmed is
that it does a begin transaction ... insert (n times) ... end transaction.
However, each of these statements is sent via a separate call to the postgres
lib. May it be that you are tracing the library calls and not the
transactions?
Rainer
> -----Original Message-----
> From: rsyslog-bounces at lists.adiscon.com [mailto:rsyslog-
> bounces at lists.adiscon.com] On Behalf Of Kenneth Marshall
> Sent: Friday, December 11, 2009 3:06 PM
> To: rsyslog-users
> Subject: Re: [rsyslog] rsyslog 5.3.5 (v5-beta) released
>
> On Fri, Dec 11, 2009 at 01:04:25PM +0100, Rainer Gerhards wrote:
> > if not subscribed to it, revisit bug tracker or forum post, there now
> exist a
> > patch! :)
> >
> > Rainer
> >
> Thank you Rainer. It now logs once more. Unfortunately, I am having
> trouble getting the INSERT batching to work. Here is my current
> rsyslog.conf:
>
> $ModLoad immark # provides --MARK-- message capability
> $ModLoad imtcp # provides TCP syslog reception and GSS-API (if compiled
> to support it)
> $ModLoad imuxsock
> $InputTCPServerRun 601 # listen on this port
> $WorkDirectory /var/spool/rsyslog # default location for work (spool)
> files
> #$MainMsgQueueFileName mainq # set file name, also enables disk mode
> $ActionQueueType LinkedList # use asynchronous processing
> $ActionQueueDequeueBatchSize 16
> $ActionQueueFileName dbq # set file name, also enables disk mode
> $ActionResumeRetryCount -1 # infinite retries on insert failure
> $ModLoad ompgsql # provides postgres support
> # Everything we receive goes in the database
> *.* :ompgsql:127.0.0.1,Syslog,dbuser,xxxxxx
>
> The $ActionQueueDequeueBatchSize option does not appear to have
> any effect. The inserts are still performed one at a time. Any
> ideas?
>
> Regards,
> Ken
>
> _______________________________________________
> rsyslog mailing list
> http://lists.adiscon.net/mailman/listinfo/rsyslog
> http://www.rsyslog.com
More information about the rsyslog
mailing list