Skip site navigation (1) Skip section navigation (2)

Re: Help! PostgreSQL stuck at starting up after crash

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <david(at)beechglen(dot)com>,"Samuel Hwang" <samuel(at)replicon(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Help! PostgreSQL stuck at starting up after crash
Date: 2012-01-19 17:16:39
Message-ID: 4F17FB9702000025000449B8@gw.wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-admin
Samuel Hwang <samuel(at)replicon(dot)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

In response to

Responses

pgsql-admin by date

Next:From: Bruce MomjianDate: 2012-01-19 22:12:02
Subject: Re: Can't get pg_upgrade work for 8.4
Previous:From: Samuel HwangDate: 2012-01-19 17:09:48
Subject: Re: Help! PostgreSQL stuck at starting up after crash

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group