Skip site navigation (1) Skip section navigation (2)

postgres, syslog and freeBSD

From: kevin kempter <kevin(at)kevinkempterllc(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: postgres, syslog and freeBSD
Date: 2008-05-30 04:35:19
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
Hi list;

I'm trying to get postgres & syslog to get along with no luck. I'm  
running freeBSD7 and postgres 8.3.1

Here's my postgres setup

log_destination = 'syslog'
#logging_collector = off
syslog_facility = 'LOCAL0'
syslog_ident = 'postgres'
silent_mode = on
log_min_duration_statement = 0

Here's my /etc/syslog.conf file:

security.*					/var/log/security;				/var/log/auth.log					/var/log/maillog					/var/log/lpd-errs					/var/log/xferlog
cron.*						/var/log/cron
*.=debug					/var/log/debug.log
*.emerg						*
# uncomment this to log all writes to /dev/console to /var/log/ 
console.log					/var/log/console.log
# uncomment this to enable logging of all log messages to /var/log/ 
# touch /var/log/all.log and chmod it to mode 600 before it will work
#*.*						/var/log/all.log
# uncomment this to enable logging to a remote loghost named loghost
#*.*						@loghost
# uncomment these if you're running inn
# news.crit					/var/log/news/news.crit
# news.err					/var/log/news/news.err
# news.notice					/var/log/news/news.notice
*.*						/var/log/slip.log
*.*						/var/log/ppp.log
LOCAL0.*					/var/log/pgsql

I dont see any files show up in /var/log

what am I doing wrong?

Thanks in advance..



pgsql-admin by date

Next:From: Camilo SperbergDate: 2008-05-30 04:57:14
Subject: Re: postgres, syslog and freeBSD
Previous:From: Theerasak ManeeneimDate: 2008-05-30 03:43:45
Subject: String comparison problem.

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group