Re: Log Output Going to STDERR even with silent mode on

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