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

Re: FATAL: the database system is in recovery mode

From: "Laura Hornbeck" <lhornbeck(at)oppunl(dot)com>
To: "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: FATAL: the database system is in recovery mode
Date: 2006-10-12 17:55:43
Message-ID: 20061012175502.A72F89FB3B6@postgresql.org (view raw or flat)
Thread:
Lists: pgsql-novice
 

-----Original Message-----
From: pgsql-novice-owner(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of Tom Lane
Sent: Thursday, October 12, 2006 12:43 PM
To: lhornbeck(at)oppunl(dot)com
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] FATAL: the database system is in recovery mode 

"Laura Hornbeck" <lhornbeck(at)oppunl(dot)com> writes:
> I am getting "FATAL:  the database system is in recovery mode" when 
> trying to reconnect after a crash.  This has been happening for about 
> an 1 hour now.  Is this something I need to wait out or can I safely 
> kill postgres and restart?

Hmmm ... unless you had extremely high settings for both checkpoint_segments
and checkpoint_timeout, it shouldn't take an hour to recover from a crash.
Does it appear that the startup subprocess is making progress at all?  (Use
"ps" to find the postmaster's startup process child, then see if it's doing
anything using "strace" or some such.)

			regards, tom lane

checkpoint_segments is 8.

strace -p26891
Process 26891 attached - interrupt to quit
futex(0xb7db2880, FUTEX_WAIT, 2, NULL



---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match


In response to

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2006-10-12 18:09:48
Subject: Re: FATAL: the database system is in recovery mode
Previous:From: Tom LaneDate: 2006-10-12 17:42:53
Subject: Re: FATAL: the database system is in recovery mode

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