[rsyslog] PostgreSQL: Problems with character encoding [Solved]

[Kenneth Marshall]

On Wed, Jan 06, 2010 at 05:32:43PM +0100, Marc Schiffbauer wrote:
> Am Mittwoch, 6. Januar 2010 16:53:52 schrieb Kenneth Marshall:
> > Would it be possible to send the poorly behaving loggers to
> > a different port to allow it to be cleaned up properly? 
> 
> No, not in that case I am afraid.
> 
> An option in rsyslog that would allow it to skip/trash/log-to-a-file those bad 
> messages would be a nice thing.
> 
> > Using
> > SQL_ASCII does allow truly anything into the database, which
> > means that all the output pieces need to process it appropriately
> > too.
> 
> Yes but this is working nicely here with phplogcon.
> 
> -Marc
> 
I was more concerned about possible compromizes caused by the
ability to insert pretty arbitrary binary data into the system.
If we have this problem in the future, I will investigate other
options further. It might be possible to have the driver also
store them in a bad record table using such an option.

Cheers,
Ken