Re: 9.2.3 crashes during archive recovery

From: Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
To: Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>
Cc: tgl(at)sss(dot)pgh(dot)pa(dot)us, pgsql-hackers(at)postgresql(dot)org
Subject: Re: 9.2.3 crashes during archive recovery
Date: 2013-02-22 09:42:39
Message-ID: 51273D8F.7060609@vmware.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2013-02-22 10:17:54 Re: Review : Add hooks for pre- and post-processor executables for COPY and \copy
Previous Message Heikki Linnakangas 2013-02-22 09:40:31 Re: 9.2.3 crashes during archive recovery