Re: BUG: Infinite syslog() loop - Mailing list pgsql-bugs

From Oliver Elphick
Subject Re: BUG: Infinite syslog() loop
Date
Msg-id 1051296044.9011.6.camel@linda.lfix.co.uk
Whole thread Raw
In response to BUG: Infinite syslog() loop  (Erik Walthinsen <omega@temple-baptist.com>)
Responses Re: BUG: Infinite syslog() loop  (Erik Walthinsen <omega@temple-baptist.com>)
List 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.Elphick@lfix.co.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

pgsql-bugs by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Select Statements freeze.
Next
From: Tom Lane
Date:
Subject: Re: 7.3.2 indexes in PL/PgSQL