Re: Disk is full, what's cool to get rid of? - Mailing list pgsql-sql

From Scott Marlowe
Subject Re: Disk is full, what's cool to get rid of?
Date
Msg-id 1154025714.31664.95.camel@state.g2switchworks.com
Whole thread Raw
In response to Re: Disk is full, what's cool to get rid of?  (Jeff Frost <jeff@frostconsultingllc.com>)
Responses Re: Disk is full, what's cool to get rid of?
List pgsql-sql
I can't tell you the number of times that little trick has saved my
life.

On Thu, 2006-07-27 at 11:32, Jeff Frost wrote:
> 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...
> >
> >


pgsql-sql by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Storage of Binary Data
Next
From: Erik Jones
Date:
Subject: Re: Disk is full, what's cool to get rid of?