| From: | John R Pierce <pierce(at)hogranch(dot)com> |
|---|---|
| To: | Joao Ferreira gmail <joao(dot)miguel(dot)c(dot)ferreira(at)gmail(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: safelly erasing dirs/files |
| Date: | 2009-11-14 19:51:50 |
| Message-ID: | 4AFF0A56.3070705@hogranch.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | Postg스포츠 토토 사이트SQL |
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 partition ? this is why I was considering
> rm !!!!
>
stop postgres. mv /var//pgsql to a new larger filesystem, then ln -s
/new/path/to/pgsql /var/pgsql
then restart postgres.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andreas Kretschmer | 2009-11-14 19:52:27 | Re: Remote Database Connection |
| Previous Message | Andreas Kretschmer | 2009-11-14 19:50:07 | Re: safelly erasing dirs/files |