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

From: Raghavendra <raghavendra(dot)rao(at)enterprisedb(dot)com>
To: John Abraham <jea(at)hbaspecto(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Unnecessary files that can be deleted/moved in cluster dir?
Date: 2013-01-08 05:58:17
Message-ID: CA+h6AhjJP=nw8DUyaMOd6tEQn82cwvkCYU0iA4WLXCfVp_jYgw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Jan 4, 2013 at 5:01 AM, John Abraham <jea(at)hbaspecto(dot)com> wrote:

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

What message it has written in DB server log file (pg_log) about it not
starting again ?

You can check the last lines of the recent log file under $PG_DATA/pg_log
location, which give very good information about why it has not started.

---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jackie Zhang 2013-01-08 06:02:43 Why the default data range for "pre_auth_delay" and "post_auth_delay" is different?
Previous Message Craig Ringer 2013-01-08 05:51:39 Re: Unnecessary files that can be deleted/moved in cluster dir?