Hi, I'm currently testing ompgsql and running into a problem with the number of pgsql retries if the INSERT statement is wrong. My rsyslog.conf setting:
$ModLoad ompgsql # load the output driver for PostgreSQL $ModLoad imudp # network reception $MaxMessageSize 8192 # default 2048; use 32768 to support large message sizes for IHE $UDPServerRun 514 # start a udp server at port 514 $WorkDirectory /var/spool/rsyslog/work # default location for work (spool) files $ActionQueueType LinkedList # use asynchronous processing $ActionQueueFileName dbq # set file name, also enables disk mode $ActionResumeRetryCount 0 $template applogFormat,"INSERT INTO applog (message, host, priority, priotext, tag, logtime) VALUES \ (E'%msg%', '%hostname%', '%syslogpriority%', '%syslogpriority-text %', '%programname%', '%timegenerated:::date-pgsql%')",stdsql if $programname contains 'production' then :ompgsql:loghost,syslog,syslog,syslog;applogFormat I changed $ActionResumeRetryCount from -1 to 1 and then to 0, but always the same result: indefinite retries of rsyslogd to get the INSERT done. This setup is basically running OK. Only if a binary 0 (\000) is contained in the message Postgres returns: ERROR: invalid byte sequence for encoding "UTF8": 0x00 What am I doing wrong? Any hints are welcome. Thanks for your help, Rudolf. Rudolf VanderLeeden Scoreloop GmbH [email protected] _______________________________________________ rsyslog mailing list http://lists.adiscon.net/mailman/listinfo/rsyslog http://www.rsyslog.com
