Re: main.log file not being updated - Mailing list pgsql-general

From Adrian Klaver
Subject Re: main.log file not being updated
Date
Msg-id 5101A2EB.1000404@gmail.com
Whole thread Raw
In response to main.log file not being updated  (Anson Abraham <anson.abraham@gmail.com>)
Responses Re: main.log file not being updated  (Anson Abraham <anson.abraham@gmail.com>)
Re: main.log file not being updated  (Anson Abraham <anson.abraham@gmail.com>)
List pgsql-general
On 01/24/2013 12:44 PM, Anson Abraham wrote:
> i've always had logging_collector off.  it would still log query /
> transactions that failed to the "syslog"
> (var/log/postgres/postgres-9.0-main.log).
> the only thing I've changed was turning log_duration back to off.  But
> I've gone back and forth with what, and doing a postgres reload.
>

CCing list.

Then shouldn't

log_destination = 'stderr'

be

log_destination = 'syslog'

You may also want to check that the syslog configuration has not changed
and it is actually configured to catch the Postgres output.

Would not hurt to check the init.d script to see if it is overriding the
logging settings.


Adrian Klaver
adrian.klaver@gmail.com


pgsql-general by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: Optimizing select count query which often takes over 10 seconds
Next
From: Adrian Klaver
Date:
Subject: Re: main.log file not being updated