On Thu, Oct 21, 2010 at 6:26 PM, Rainer Gerhards
<[email protected]> wrote:
> do
>
> local0.* -/var/log/postgresql/postgresql-8.4-main.log
> & ~
>
I am afraid this did not work.
To give you more details.
I am running on ubuntu with postgres 8.4. Postgres is configured like this.
log_destination = 'syslog'
syslog_facility = 'LOCAL0'
I created a file called postgresql.conf in the /etc/rsyslog.d/
directory and now it looks like this.
local0.* -/var/log/postgresql/postgresql-8.4-main.log
& ~
#
# add local0 to the ignore field for the normal messages so it wont'
get logged twice.
#
*.=info;*.=notice;*.=warn;\
local0.none -/var/log/messages
*.=info;*.=notice;*.=warn;\
local0.none -/var/log/syslog
I tried it with and without the bottom part (after the comments).
No matter what I do every entry is written into /var/log/messages ,
/var/log/syslog and /var/log/postgresql/postgresql-8.4-main.log
I am reloading rsyslog with "reload rsyslog" when I do that both
syslog and messages have rsyslog messages on them which is also a bit
puzzling.
The rest of the syslog configuration is in 50-default.conf which I
didn't touch but I have included here for reference.
Default rules for rsyslog.
#
# For more information see rsyslog.conf(5) and
/etc/rsyslog.conf
#
# First some standard log files. Log by facility.
#
auth,authpriv.* /var/log/auth.log
*.*;auth,authpriv.none -/var/log/syslog
#cron.* /var/log/cron.log
daemon.* -/var/log/daemon.log
kern.* -/var/log/kern.log
lpr.* -/var/log/lpr.log
mail.* -/var/log/mail.log
user.* -/var/log/user.log
#
# Logging for the mail system. Split it up so that
# it is easy to write scripts to parse these files.
#
mail.info -/var/log/mail.info
mail.warn -/var/log/mail.warn
mail.err /var/log/mail.err
#
# Logging for INN news system.
#
news.crit /var/log/news/news.crit
news.err /var/log/news/news.err
news.notice -/var/log/news/news.notice
#
# Some "catch-all" log files.
#
*.=debug;\
auth,authpriv.none;\
news.none;mail.none -/var/log/debug
*.=info;*.=notice;*.=warn;\
auth,authpriv.none;\
cron,daemon.none;\
mail,news.none -/var/log/messages
#
# Emergencies are sent to everybody logged in.
#
*.emerg *
#
# I like to have messages displayed on the console, but only on a virtual
# console I usually leave idle.
#
#daemon,mail.*;\
# news.=crit;news.=err;news.=notice;\
# *.=debug;*.=info;\
# *.=notice;*.=warn /dev/tty8
# The named pipe /dev/xconsole is for the `xconsole' utility. To use it,
# you must invoke `xconsole' with the `-file' option:
#
# $ xconsole -file /dev/xconsole [...]
#
# NOTE: adjust the list below, or you'll go crazy if you have a reasonably
# busy site..
#
daemon.*;mail.*;\
news.err;\
*.=debug;*.=info;\
*.=notice;*.=warn |/dev/xconsole
_______________________________________________
rsyslog mailing list
http://lists.adiscon.net/mailman/listinfo/rsyslog
http://www.rsyslog.com
