On Mon, Nov 16, 2009 at 2:37 AM, Jasen Betts wrote:
> On 2009-11-14, Joao Ferreira gmail wrote:
>> 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/rei
On 2009-11-14, Joao Ferreira gmail wrote:
> 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
Greg Smith wrote:
how do I un-bloat the /var partition ? this is why I was considering
rm
I've gotten out of this situation before by finding other files in
/var to delete, using something like this to figure out where the big
stuff was at:
while sometimes /var/log or /var/spool data
Joao Ferreira gmail wrote:
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
I've gotten out of this situation before by finding other files in /var
to delete, using something like this to figure out w
From the on-line help:
|DROP DATABASE| drops a database. It removes the catalog entries for the
database and deletes the directory containing the data.
Joao Ferreira gmail wrote:
Hello all,
How can I safelly erase (with rm command in Linux) files or dirs
concerning a specific database ?
a
On Sat, Nov 14, 2009 at 7:42 PM, Joao Ferreira gmail
wrote:
> vacuum/reindex is saying: I can't do it cause I have no space :(
Hm, vacuum shouldn't require any extra space. I suppose you need
enough space for the transaction log though. You can probably get away
with a pretty small amount of extr
Joao Ferreira gmail wrote:
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 partiti
Joao Ferreira gmail 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
Bill Moran wrote:
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.
the only really secure data destruction is to put the disk drives in a
chipper and grind them up. don't forget any media that ever held
b
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 consid
Joao Ferreira gmail wrote:
How can I safelly erase (with rm command in Linux) files or dirs
concerning a specific database ?
You can't do it with rm; you need to execute the SQL "drop" command
somehow to clean up all the references to that database. If you want to
remove a database from the
Joao Ferreira gmail 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 d
Joao Ferreira gmail writes:
> How can I safelly erase (with rm command in Linux) files or dirs
> concerning a specific database ?
Don't even think about it.
> assuming I whish to elimiante data belonging to database A but I do not
> whish to disturb or cause any injury to database B
DROP DATABA
In response to Joao Ferreira gmail :
> Hello all,
>
> How can I safelly erase (with rm command in Linux) files or dirs
> concerning a specific database ?
Don't do that!
>
> assuming I whish to elimiante data belonging to database A but I do not
> whish to disturb or cause any injury to database
On Fri, Nov 13, 2009 at 12:15 PM, Joao Ferreira gmail <
joao.miguel.c.ferre...@gmail.com> wrote:
> Hello all,
>
> How can I safelly erase (with rm command in Linux) files or dirs
> concerning a specific database ?
>
Using 'rm', you can't -- not safely anyways.
>
> assuming I whish to elimiant
Hello all,
How can I safelly erase (with rm command in Linux) files or dirs
concerning a specific database ?
assuming I whish to elimiante data belonging to database A but I do not
whish to disturb or cause any injury to database B
Is there documentation on how to do this or on what exactly am I
16 matches
Mail list logo
