Re: 9.2.3 crashes during archive recovery

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