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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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