Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 7824D43CEB9 for ; Thu, 19 Jan 2012 13:17:06 -0400 (AST) Received: from gwmta.wicourts.gov ([165.219.244.99] helo=gw.wicourts.gov) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Rnvbi-00015I-88 for pgsql-admin@postgresql.org; Thu, 19 Jan 2012 17:17:06 +0000 Received: from Courts-MTA by gw.wicourts.gov with Novell_GroupWise; Thu, 19 Jan 2012 11:16:49 -0600 Message-Id: <4F17FB9702000025000449B8@gw.wicourts.gov> X-Mailer: Novell GroupWise Internet Agent 8.0.1 Date: Thu, 19 Jan 2012 11:16:39 -0600 From: "Kevin Grittner" To: ,"Samuel Hwang" Cc: Subject: Re: Help! PostgreSQL stuck at starting up after crash References: In-Reply-To: Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Pg-Spam-Score: -4.2 (----) X-Archive-Number: 201201/102 X-Sequence-Number: 39014 Samuel Hwang 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