Unnecessary files that can be deleted/moved in cluster dir?

From: John Abraham <jea(at)hbaspecto(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Unnecessary files that can be deleted/moved in cluster dir?
Date: 2013-01-03 23:31:40
Message-ID: 81697C4F-EEA2-404C-9246-209C70F3E435@hbaspecto.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a little problem, I let my drive get too full. And then while I was deleting rows to free space, the auto vacuum didn't kick in quite the way I expected, and I ran out of space entirely. So the DB shut down and won't start back up.

So is there anything ( other than the logs in pg_log) that I can delete, or move temporarily, to save some space and allow the database to start up and finish it's vacuum?

Or is there a way to move some of the stuff to another drive? The whole cluster is too big to move entirely to a new physical drive (the machine is in another city so I can't just plug in a USB drive or anything, but I can put stuff on network shares for now) and there is nothing else on the partition other than the cluster.

Thanks,

--
John Abraham

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2013-01-03 23:59:37 Re: alter default privileges problem
Previous Message Gauthier, Dave 2013-01-03 21:57:29 Re: alter default privileges problem