[rsyslog] PostgreSQL: Problems with character encoding

[Marc Schiffbauer]

Hi all,

which encoding should be chosen for the database when using postgres?

My rsyslog version is 4.4.3.

Which client_encoding does rsyslog use in ompgsql?


I currently have set UTF-8 on the database. It worked for a while until some 
special message arrived at the server where postgres denies the INSERT:

2010-01-06 16:13:11 CET syslog syslog ERROR:  invalid byte sequence for 
encoding "UTF8": 0xd220
2010-01-06 16:13:11 CET syslog syslog HINT:  This error can also happen if the 
byte sequence does not match the encoding expected by the server, which is 
controlled by "client_encoding".

Now rsyslog is not able to log anything... it is currently spooling to disk 
because it "hangs" at this message not being accepted by postgres.

Any hints?
TIA
-Marc