Re: 9.2.3 crashes during archive recovery

Поиск
Список
Период
Сортировка
От Kyotaro HORIGUCHI
Тема Re: 9.2.3 crashes during archive recovery
Дата
Msg-id 20130215.173341.74375204.horiguchi.kyotaro@lab.ntt.co.jp
обсуждение исходный текст
Ответ на Re: 9.2.3 crashes during archive recovery  (Heikki Linnakangas <hlinnakangas@vmware.com>)
Ответы Re: 9.2.3 crashes during archive recovery  (Heikki Linnakangas <hlinnakangas@vmware.com>)
Список pgsql-hackers
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.

On the other hand, PosrgreSQL RA(Rsource Agent) is obliged to
start the master node via hot standby state because of the
restriction of the state transition of Pacemaker,

So the simply stopping and then starting the master node can fall
into this situation.

> Hmm, I just realized a little problem with that approach. If you take
> a base backup using an atomic filesystem backup from a running server,
> and start archive recovery from that, that's essentially the same
> thing as Kyotaro's test case.

Regards,

-- 
Kyotaro Horiguchi
NTT Open Source Software Center



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Kyotaro HORIGUCHI
Дата:
Сообщение: Re: Identity projection
Следующее
От: Amit Kapila
Дата:
Сообщение: Re: Identity projection