From: | Joao Ferreira gmail <joao(dot)miguel(dot)c(dot)ferreira(at)gmail(dot)com> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: safelly erasing dirs/files |
Date: | 2009-11-14 19:42:50 |
Message-ID: | 1258227770.7624.7.camel@debj5n.critical.pt |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | Postg범퍼카 토토SQL |
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(dot)miguel(dot)c(dot)ferreira(at)gmail(dot)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.
>
From | Date | Subject | |
---|---|---|---|
Next Message | John R Pierce | 2009-11-14 19:44:31 | Re: safelly erasing dirs/files |
Previous Message | Greg Smith | 2009-11-14 19:38:51 | Re: safelly erasing dirs/files |