| From: | nicky <nicky(at)valuecare(dot)nl> | 
|---|---|
| To: | pgsql-general(at)postgresql(dot)org | 
| Subject: | logs not ending up at Syslog | 
| Date: | 2006-12-04 09:14:44 | 
| Message-ID: | 4573E704.2030206@valuecare.nl | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-general | 
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.
Can someone give me a clue?
Thanks in advance.
Nick
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alban Hertroys | 2006-12-04 09:25:47 | Re: sudden drop in delete performance | 
| Previous Message | Albe Laurenz | 2006-12-04 08:43:02 | Re: Unsuccessful SIGINT |