> just nothing happened after that and postgresql is stuck at > starting up and not getting out of archive recovery mode.\
What do you base that on? (copy/paste) ==> I have waited for at least 2 hours, but the database is still in starting up state. In the mean time, there is not cpu/disk activities. > at that time there is no cpu/disk activities and it seemed like > it's waiting for something? That looks like normal recovery. I would expect it to be waiting for clients to connect at that point. What happens when you try to connect to the database after that above has been logged? (Copy/paste the psql command line and any errors, please.) ==> when I tried to use psql to connect the db, I got FATAL: the database system is starting up and it doesn't allow connection. On Thu, Jan 19, 2012 at 10:16 AM, Kevin Grittner < kevin.gritt...@wicourts.gov> wrote: > Samuel Hwang <sam...@replicon.com> wrote: > > I don't know how to make sure if WAL logs corrupted. > > At the end of the recovery in postgresql log I saw > > > > 2012-01-18 18:30:58.570 MST 3666 - LOG: consistent recovery > > state reached at 56C/CD0AFE00 > > 2012-01-18 18:30:58.587 MST 3666 - LOG: recovery stopping > > before abort of transaction 541802043, time 2012-01-18 > > 12:50:08.531615-07 > > 2012-01-18 18:30:58.587 MST 3666 - LOG: redo done at > > 56C/CD226C58 > > 2012-01-18 18:30:58.587 MST 3666 - LOG: last completed > > transaction was at log time 2012-01-18 12:49:28.321605-07 > > 2012-01-18 18:30:58.589 MST 3666 - LOG: selected new timeline > > ID: 2 > > 2012-01-18 18:30:59.187 MST 3666 - LOG: archive recovery > > complete > > > > just nothing happened after that and postgresql is stuck at > > starting up and not getting out of archive recovery mode.\ > > What do you base that on? (copy/paste) > > > at that time there is no cpu/disk activities and it seemed like > > it's waiting for something? > > That looks like normal recovery. I would expect it to be waiting > for clients to connect at that point. > > What happens when you try to connect to the database after that > above has been logged? (Copy/paste the psql command line and any > errors, please.) > > -Kevin > -- *Shian-Miin Samuel Hwang* | Software Developer | Phone 1-403-2626519 (ext. 276) | Fax 1-403-233-8046 *Replicon* | Hassle-Free Time & Expense Management Software - 7,300 Customers - 70 Countries www.replicon.com | facebook <http://www.facebook.com/Replicon.inc> | twitter<http://twitter.com/Replicon>| blog <http://www.replicon.com/blog/> | contact us<http://www.replicon.com/about_replicon/contact_us.aspx> *We are hiring!* | search jobs<http://tbe.taleo.net/NA2/ats/careers/searchResults.jsp?org=REPLICON&cws=1&act=sort&sortColumn=1&__utma=1.651918544.1299001662.1299170819.1299174966.10&__utmb=1.8.10.1299174966&__utmc=1&__utmx=-&__utmz=1.1299174985.10.3.utmcsr=google%7Cutmccn=%28organic%29%7Cutmcmd=organic%7Cutmctr=replicon%20careers&__utmv=1.%7C3=Visitor%20Type=Prospects=1,&__utmk=40578466>