I though to do that w/ log_destination, but i left everything pretty much
default except those params I mentioned earlier.

Interestingly i have another DB server (same ver, etc...) w/ exact same
config params w/ postgres and sys log config and that is writing to the
"system postgres log".


it's a head scratcher for me.

On Thu, Jan 24, 2013 at 4:08 PM, Adrian Klaver <adrian.kla...@gmail.com>wrote:

> 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.kla...@gmail.com
>

Reply via email to