Re: Disk is full, what's cool to get rid of?

[Jeff Frost <jeff(at)frostconsultingllc(dot)com>]

You can probably just "tune2fs -m 0 <device name>" to give yourself enough 
space to get out of the jam before you go deleting things.  Then you might 
want to vacuum full afterwards.

On Thu, 27 Jul 2006, Erik Jones wrote:

> Hello, quick question.  I've run into an issue with the disk that my 
> development box is on filling up and preventing pretty much any writing 
> (inserts, updates, deletes, etc...) from happening.  Other than some piddly 
> text logs the db is pretty much the only thing on the box.  So, my question 
> is:  what can I do to free space and run a full vacuum? (I was not the one 
> who set up this box and there has been virtually no administration or 
> maintenance on it that I know of...)  How about the WAL files in pg_xlog? 
> How critical are they when no data on the system is critical in and of 
> itself?  Any suggestions would be greatly appreciated...

--
Jeff Frost, Owner 	<jeff(at)frostconsultingllc(dot)com>
Frost Consulting, LLC 	http://www.frostconsultingllc.com/
Phone: 650-780-7908	FAX: 650-649-1954