Re: safelly erasing dirs/files

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: pgsql-general

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.
>

In response to

Responses

Browse pgsql-general by date

  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