Joao Ferreira gmail <joao.miguel.c.ferre...@gmail.com> wrote: > my problem is I a heavilly bloated pg database that has just filled up > the partition > > data is in /var/pgsql/.. and /var is 100% full... > > 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 !!!!
Which version do you have? 8.4? If yes, you can create a new tablespace on an other partition/disk and alter table set tablespace <your new tablespace>. Indexes you can DROP and recreate. But never ever delete files on os-level! Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) "If I was god, I would recompile penguin with --enable-fly." (unknown) Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889° -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
