nicky wrote:
Hello All,
I'm trying to configure my PostgreSQL 8.1.x (on FreeBSD 6-STABLE) to log
through syslog, yet somehow my logging doesn't end up in the specified
log files.
I'm kind of at a loss as to where i messed up. I'm hoping someone can
help me fix it.
Below are uncommented lines in my postgresql.conf file, related to logging:
log_destination = 'syslog'
# These are relevant when logging to syslog:
syslog_facility = 'LOCAL0'
syslog_ident = 'postgres'
log_min_messages = debug5 # Values, in order of decreasing
detail:
log_min_duration_statement = 0 # -1 is disabled, 0 logs all
statements
# and their durations, in
milliseconds.
silent_mode = on
log_connections = on
log_disconnections = on
log_duration = on
log_statement = 'all' # none, mod, ddl, all
And i've appended the line below to my /etc/syslog.conf
local0.* /var/log/pgsql
Restarted both PostgreSQL and syslog, yet, nothing gets displayed in
/var/log/pgsql.
What's in /usr/local/etc/rc.d/postgresql? Does it specify anything for
logging? If so, it's likely to have something like
PGLOG="$PGDATA/postgres.log".
brian
