Re: 9.2.3 crashes during archive recovery

From: Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>
To: hlinnakangas(at)vmware(dot)com
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-26 06:25:48
Message-ID: 20130226.152548.181199302.horiguchi.kyotaro@lab.ntt.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

At Fri, 22 Feb 2013 11:42:39 +0200, Heikki Linnakangas <hlinnakangas(at)vmware(dot)com> wrote in <51273D8F(dot)7060609(at)vmware(dot)com>
> On 15.02.2013 10:33, Kyotaro HORIGUCHI wrote:
> > 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.

I completely agree with you. But I hear that they want to
shutdown as fast as possible on failure and also don't want more
states on RA.. On the other hand he result in case of this
failure is catastrophic so this should be fixed regardless of
what pacemaker does.

regards,
--
Kyotaro Horiguchi
NTT Open Source Software Center

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Kyotaro HORIGUCHI 2013-02-26 06:52:04 Re: 9.2.3 crashes during archive recovery
Previous Message Kyotaro HORIGUCHI 2013-02-26 06:25:24 Re: 9.2.3 crashes during archive recovery