Re: recover corrupt DB? - Mailing list pgsql-general

From Craig Ringer
Subject Re: recover corrupt DB?
Date
Msg-id 49FAEE4D.90801@postnewspapers.com.au
Whole thread Raw
In response to Re: recover corrupt DB?  (Steve Clark <sclark@netwolves.com>)
List pgsql-general
> On all our servers we have a cron job that runs daily and reports disk
> usage stats.
> Maybe you need something similar.

Of course. I have Cacti running to monitor disk usage on all my servers.

That doesn't help if a user creates several duplicates of a huge table,
or otherwise gobbles disk space. There's always the *potential* to run
out of disk space, and I'm concerned that Pg doesn't handle that
gracefully. I agree it shouldn't happen, but Pg shouldn't mangle the DB
when it does, either.

--
Craig Ringer

pgsql-general by date:

Previous
From: Keaton Adams
Date:
Subject: Re: Any way to execute ad-hoc pl/pgsql?
Next
From: Bill Moran
Date:
Subject: Re: Re: Mapping output from a SEQUENCE into something non-repeating/colliding but random-looking?