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@gmail.com> 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.
>