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.klaver@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.
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