On Tue, Jan 18, 2005 at 03:05:34PM +0000, David Klugmann wrote: > > I have the following entries in my postgresql.conf file yet it doesn't seem > to log anything. Did you restart the backend after modifying postgresql.conf? > syslog_facility = 'LOCAL0' Have you configured /etc/syslog.conf to send local0 messages anywhere? You might need to add an appropriate line to /etc/syslog.conf, touch the desired log file if it doesn't already exist, and send a HUP signal to syslogd. You can test your syslog configuration with the "logger" program. I think log_statement sends messages to the LOG_INFO syslog level, so run the following command from the shell prompt and see if the message gets logged: logger -p local0.info "test 1 to local0.info" Verify that your syslog configuration is working, make sure you've restarted the PostgreSQL backend so it knows about the configuration changes, and try again. -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
