Re: Shutting postgres up

[Dave Sherohman <esper@sherohman.org>]

On Fri, Sep 13, 2002 at 07:09:14PM +0100, Oliver Elphick wrote:
> On Fri, 2002-09-13 at 18:17, Dave Sherohman wrote:
> > You must mean something other than setting "debug_level = 0", because
> > that doesn't suppress these messages (despite them all being prefaced
> > with "DEBUG:").
> 
> Hmm.  That should have worked, provided that you told the postmaster to
> reload its configuration.

postgresql.conf hasn't been changed since the upgrade; "debug_level =
0" was already in there when I first looked at it (and, from memory, I'm
pretty sure it was already there before the upgrade), but I was already
familiar with its lack of effect on the messages in question from having
filed a bug on it the last time I upgraded.  (I can't find it in the BTS,
but I was basically told that it's supposed to work this way.)

$ cat /etc/postgresql/postgresql.conf | grep -v ^#
debug_level = 0
log_connections = on
log_pid = on
log_timestamp = on
syslog = 2
silent_mode = off
syslog_facility = LOCAL0
trace_notify = off
max_connections = 64
shared_buffers = 128
tcpip_socket = on

Some sample messages:
---
Sep 13 04:00:06 genma postgres[5145]: [1] DEBUG:  connection: host=[local] user=postgres database=pmdb
Sep 13 04:00:07 genma postgres[5145]: [2] DEBUG:  --Relation pg_type--
Sep 13 04:00:07 genma postgres[5145]: [3-1] DEBUG:  Index pg_type_oid_index: Pages 2; Tuples 174: Deleted 1.
Sep 13 04:00:07 genma postgres[5145]: [3-2] ^ICPU 0.00s/0.00u sec elapsed 0.00 sec.
Sep 13 04:00:07 genma postgres[5145]: [4-1] DEBUG:  Index pg_type_typname_index: Pages 2; Tuples 174: Deleted 1.
Sep 13 04:00:07 genma postgres[5145]: [4-2] ^ICPU 0.00s/0.01u sec elapsed 0.01 sec.
Sep 13 04:00:07 genma postgres[5145]: [5-1] DEBUG:  Removed 1 tuples in 1 pages.
Sep 13 04:00:07 genma postgres[5145]: [5-2] ^ICPU 0.00s/0.00u sec elapsed 0.00 sec.
Sep 13 04:00:07 genma postgres[5145]: [6-1] DEBUG:  Pages 3: Changed 2, Empty 0; Tup 174: Vac 1, Keep 0, UnUsed 0.
Sep 13 04:00:07 genma postgres[5145]: [6-2] ^ITotal CPU 0.01s/0.02u sec elapsed 0.03 sec.
Sep 13 04:00:07 genma postgres[5145]: [7] DEBUG:  Analyzing pg_type
---

Similar messages are repeated for each table in every database, for a
total of 589 entries last night.

-- 
When we reduce our own liberties to stop terrorism, the terrorists
have already won. - reverius

Innocence is no protection when governments go bad. - Tom Swiss