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

From Greg Smith
Subject Re: recovery do not finish
Date
Msg-id Pine.GSO.4.64.0807112040340.8447@westnet.com
Whole thread Raw
In response to recovery do not finish  (Benedek Laszlo <bene33@freemail.hu>)
List pgsql-general
On Fri, 11 Jul 2008, Benedek Laszlo wrote:

> We have waited for more than 2 hours, but psql still says that the system is starting up.

In addition to the suggestions you've gotten to try a later version
instead, I'd add that you should consider running vmstat in another window
while the recovery is going on.  Recovery should show a steady flow of
data moving to and from disk with a fair amount of CPU usage.  If that
stops for a while, it's probably stuck because of a recovery bug or some
other issue, rather than still processing such that you should wait for
it.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD

pgsql-general by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Default fill factor for tables?
Next
From: "Scott Marlowe"
Date:
Subject: Re: Default fill factor for tables?