Re: safelly erasing dirs/files
От | Andreas Kretschmer |
---|---|
Тема | Re: safelly erasing dirs/files |
Дата | |
Msg-id | 20091114195006.GA16147@tux обсуждение исходный текст |
Ответ на | Re: safelly erasing dirs/files (Joao Ferreira gmail <joao.miguel.c.ferreira@gmail.com>) |
Список | pgsql-general |
Joao Ferreira gmail <joao.miguel.c.ferreira@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°
В списке pgsql-general по дате отправления: