rsyslog 2.0 supports postgresql it would be very simple to add an rpm with postgres support I am working on one but there are SELinux issues that I am still working on. It would be very nice if this were an official package.
Hi Fran, this is nice coincidence I have just built rsyslog-2.0.2-1 with PostgresSQL support. :) Could you try it please.
Created attachment 295077 [details] SELinux policy change for rsyslog
I have installed rsyslog-2.0.2-1 and it seems to be missing two items: the .sql file necessary to initialize the database (contained in the distribution) and a SELinux policy change to allow rsyslog to open a socket connection on the postgres port (I think this is missing for the mysql version as well). I have attached my solution to the latter issue, I don't know how such things are solved in general in these cases.
I installed your package on my Fedora 8 machine, and it has slowed to a crawl processing two SELinux failure messages: SELinux prevented rsyslogd from rerading from the urandom device. SELinux is preventing rsyslogd (syslogd_t) "getattr" to /etc/krb5.conf (krb5_conf_t). My rsyslog-postgresql doesn't have these problems. To make it, I just copied and pasted stuff in the spec file in the obvious manner. With the addition of the SELinux policy change I attached, it works fine.
thnx. Fran, .sql file - will be fixed in next release, selinux policy - I'm gonna contact dwalsh, but I can't reproduce selinux problem from comment #4. rsyslog is built without GSSAPI support, so it shouldn't do anything with krb5.conf.
Fixed in selinux-policy-3.2.8-1.fc9 Also added postgresql_stream_connect(syslogd_t) So you could set it up without using network.