Re: Postgres debug logging

[bob parker <bob_parker@dodo.com.au>]

On Tue, 8 Apr 2003 03:37, Dave Sherohman wrote:
> On Tue, Apr 08, 2003 at 02:32:10AM +1000, bob parker wrote:
> > I am a bit puzzled though because syslog = 2 should cause all noise to go
> > to syslog but there is very little there. It is all in /var/log/debug.
>
> syslog = 2 causes all noise to go to the syslog _daemon_.  Based on
> the instructions found in /etc/syslog.conf, the daemon decides which
> file(s) the messages get written to.  In a default debian config, not
> all syslogged messages get written to /var/log/syslog.

Thanks for that, I have checked that conf out. I suppose what is really 
cuasing this is that the messages all have the word [DEBUG] in the middle 
like so.

Apr  7 04:00:02 debian postgres[3551]: [1] DEBUG:  connection: host=[local] 
user=postgres database=template1
Apr  7 04:00:02 debian postgres[3565]: [1] DEBUG:  connection: host=[local] 
user=postgres database=template1
Apr  7 04:00:02 debian postgres[3566]: [1] DEBUG:  connection: host=[local] 
user=postgres database=aviation

Also I am getting about a gazillion similar lines every morning, I don't 
suppose it's something as silly as the binary compiled in debug mode???

Bob