Skip site navigation (1) Skip section navigation (2)

Re: BUG: Infinite syslog() loop

From: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
To: Erik Walthinsen <omega(at)temple-baptist(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG: Infinite syslog() loop
Date: 2003-04-25 18:40:44
Message-ID: 1051296044.9011.6.camel@linda.lfix.co.uk (view raw or flat)
Thread:
Lists: pgsql-bugs
On Tue, 2003-04-22 at 20:41, Erik Walthinsen wrote:
> I woke up this morning to a filled root partition on one of my servers.
> I found that both debug and syslog were filled with over 50MB each of
> postgres errors:
> 
> [what appears to be a standard cleanup cron job]
> . . . .
> Apr 21 04:00:03 alpha postgres[3371]: [85] DEBUG:  --Relation
...
> The machine is a stock Debian Woody box, up to date, with no local changes
> to the postgres configuration at all.  It's running 7.2.1-2woody2.

Change your syslog configuration to throw away debug messages from
postgres (user0)

-- 
Oliver Elphick                                Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight, UK                             http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
                 ========================================
     "Nay, in all these things we are more than conquerors 
      through him that loved us."    Romans 8:37 


In response to

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2003-04-25 20:16:00
Subject: Re: 7.3.2 indexes in PL/PgSQL
Previous:From: Stephan SzaboDate: 2003-04-25 17:53:50
Subject: Re: Select Statements freeze.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group