Re: URGENT: Whole DB down ("no space left on device") - Mailing list pgsql-general

From Phoenix Kiula
Subject Re: URGENT: Whole DB down ("no space left on device")
Date
Msg-id e373d31e0708310734l2dcfaf76ia3d5323748b22f1a@mail.gmail.com
Whole thread Raw
In response to Re: URGENT: Whole DB down ("no space left on device")  ("Josh Tolley" <eggyknap@gmail.com>)
Responses Re: URGENT: Whole DB down ("no space left on device")  (Jeff Davis <pgsql@j-davis.com>)
List pgsql-general
On 31/08/2007, Josh Tolley <eggyknap@gmail.com> wrote:
> On 8/31/07, Zoltan Boszormenyi <zb@cybertec.at> wrote:
> > Phoenix Kiula írta:

> In addition to what others have already said, when things calm down
> you should consider implementing some sort of monitoring system that
> is configured to start screaming before you run into problems like
> this. At my place of work, we've set up Nagios to monitor the space
> left on various partitions, and email us when a partition gets above
> 90% full.



Wow, Nagois seems like a superb tool. Thanks for the recommendation!

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Out of memory error, FreeBSD 6.2, PostgreSQL 8.2.4
Next
From: "John Prevost"
Date:
Subject: Re: Out of shared memory (locks per process) using table-inheritance style partitioning