Re: safelly erasing dirs/files

Joao Ferreira gmail wrote:
> vacuum/reindex is saying: I can't do it cause I have no space :(
> how do I un-bloat the /var partition ? this is why I was considering
> rm !!!!
>
I've gotten out of this situation before by finding other files in /var
to delete, using something like this to figure out where the big stuff
was at:

du -sk | sort -n

And then once a little room was available, using CLUSTER starting on the
smallest tables, identified with a query like the one at
http://wiki.postgresql.org/wiki/Disk_Usage except with different LIMITs
on it.  Once some of those are shrunk, you might be able to work your
way up to bigger ones.

--
Greg Smith    2ndQuadrant   Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com  www.2ndQuadrant.com