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.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
