Re: recovery do not finish - Mailing list pgsql-general

From Simon Riggs
Subject Re: recovery do not finish
Date
Msg-id 1215811819.4051.1670.camel@ebony.2ndQuadrant
Whole thread Raw
In response to Re: recovery do not finish  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-general
On Fri, 2008-07-11 at 16:53 -0400, Alvaro Herrera wrote:
> Benedek Laszlo wrote:
> > Hello,
> >
> > I have a serious problem with a production database.
> > We had a no disk space left on device problem, and postgres did not stop, so it was killed ( kill -9 )
> > we made free space and reboot, but postgres not start properly.
> > We have waited for more than 2 hours, but psql still says that the system is starting up.
> > ( Db size is about 20 gb )
> > the os is Ubuntu 4.0.3-1ubuntu5
> > postgres is 8.1.4

2 hours is a long time for a crash recovery. What does the log say?

> There are known bugs in the recovery code; IIRC some of them may cause
> the recovery to hang.

Just to clarify: There are no known bugs in recovery code at the highest
maintenance release level in any version of PostgreSQL after 8.0 on
Linux, possibly before that also. So upgrade, yes, very soon.

--
 Simon Riggs           www.2ndQuadrant.com
 PostgreSQL Training, Services and Support


pgsql-general by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Default fill factor for tables?
Next
From: Alvaro Herrera
Date:
Subject: Re: How do I tell if a vacuum is currently running?