ok. thx all for the explanation 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 !!!! thx Joao On Sat, 2009-11-14 at 14:35 -0500, Bill Moran wrote: > Joao Ferreira gmail <joao.miguel.c.ferreira@xxxxxxxxx> wrote: > > > > Hello all, > > > > How can I safelly erase (with rm command in Linux) files or dirs > > concerning a specific database ? > > What do you mean by this? The typical way would be to log into the > DB server and issue DROP DATABASE x. > > However, if you're looking for secure data destruction (akin to rm's -P > flag) I don't know if there is a canned method for doing so. > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
