Re: Postgres debug logging

[Jeremiah Mahler <jeri@bingo.dnsalias.org>]

On Mon, Apr 07, 2003 at 05:10:49AM +1000, bob parker wrote:
> I'm running Woody and Postgresql.
> 
> These lines appear in my /var/log/debug
> 
> Apr  7 04:00:01 debian /USR/SBIN/CRON[3533]: (postgres) CMD ([ -x 
> /usr/lib/postgresql/bin/do.maintenance ] && 
> /usr/lib/postgresql/bin/do.maintenance -a)
> 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
> 
> It seems to me that I should be able to turn this off somewhere in the 
> posrgresql configuration but can not find where.
> 
> Ant pointers please.
> 
> Bob
> 
> 

Bob,

Look in the config file [1] and the documentation [2].
The config option 'server_min_messages' and possibly others
should be of interest to you.

[1] /etc/postgresql/postgresql.conf

[2] http://localhost/doc/postgresql/html/runtime-config.html#LOGGING

-- 
Jeremiah Mahler <jeri@bingo.dnsalias.org>