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 <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
