On Tue, 2005-04-12 at 08:51 +0100, Richard Huxton wrote:
Inpreet Singh wrote:
syslog = 2 # range 0-2 syslog_facility = 'LOCAL0' syslog_ident = 'postgres'
You also need to update your syslog.conf and restart syslogd
Add a line like: local0.* /var/log/pgsql
Saw this post and tried to setup the log info to be sent to a different file '/var/log/pgsql'. There was no trouble with this.
I then thought I would use a more logical name than 'LOCAL0' for the facility name. However no matter what name I tried '/etc/init.d/postgresql' wouldn't restart the 'postmaster' program.
The local0/1/etc facilities are for "custom" applications logging to syslog. You can see a list of valid facilities with "man syslog.conf"
HTH -- Richard Huxton Archonet Ltd
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)
