Log Output Going to STDERR even with silent mode on
Log Output Going to STDERR even with silent mode on
От:
Adam Kessel <adam@bostoncoop.net>
Дата:
I've read through the postgresql.conf documentation and searched the history of this list and been unable to solve this problem. Since I upgraded from pgsql 7.2 to 7.3, all logging messages are going to STDERR and thus ending up in my apache error log. I have silent mode set to true and syslog set to 0. Messages are going to /var/log/postgresql/postgres.log as well, so I don't see why they should to both places. Messages are not appearing in syslog, as expected. I have placed the configuration file at http://bostoncoop.net/adam/temp/postgresql.conf in case that is helpful. Any advice would be appreciated! --Adam Kessel
Re: Log Output Going to STDERR even with silent mode on
От:
Steve Crawford <scrawford@pinpointresearch.com>
Дата:
Here is what your conf file has: log_connections = true log_pid = true #log_statement = false #log_duration = false log_timestamp = true ... syslog = 0 # range 0-2 #syslog_facility = 'LOCAL0' #syslog_ident = 'postgres' 0 means route to stdout, 2 to syslog, 1 to both. I use the following to log to syslog only on 7.3.1: syslog = 2 syslog_facility = 'LOCAL4' syslog_ident = 'postgres' Choose the syslog facility that's best for you - match in syslog.conf. Restart postgres after changing. Cheers, Steve On Wednesday 16 April 2003 8:56 am, Adam Kessel wrote: > I've read through the postgresql.conf documentation and searched the > history of this list and been unable to solve this problem. > > Since I upgraded from pgsql 7.2 to 7.3, all logging messages are going to > STDERR and thus ending up in my apache error log. I have silent mode set > to true and syslog set to 0. Messages are going to > /var/log/postgresql/postgres.log as well, so I don't see why they should > to both places. > > Messages are not appearing in syslog, as expected. > > I have placed the configuration file at > > http://bostoncoop.net/adam/temp/postgresql.conf > > in case that is helpful. > > Any advice would be appreciated! > > --Adam Kessel > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly