Re: 9.2.3 crashes during archive recovery - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: 9.2.3 crashes during archive recovery
Date
Msg-id 51273D8F.7060609@vmware.com
Whole thread Raw
In response to Re: 9.2.3 crashes during archive recovery  (Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>)
Responses Re: 9.2.3 crashes during archive recovery  (Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>)
List pgsql-hackers
On 15.02.2013 10:33, Kyotaro HORIGUCHI wrote:
> Sorry, I omitted to show how we found this issue.
>
> In HA DB cluster cosists of Pacemaker and PostgreSQL, PostgreSQL
> is stopped by 'pg_ctl stop -m i' regardless of situation.

That seems like a bad idea. If nothing else, crash recovery can take a 
long time. I don't know much about Pacemaker, but wouldn't it make more 
sense to at least try fast shutdown first, falling back to immediate 
shutdown after a timeout.

- Heikki



pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: 9.2.3 crashes during archive recovery
Next
From: Michael Paquier
Date:
Subject: Re: use_remote_explain missing in docs of postgres_fdw