Re: Re: BUG #5602: Recovering from Hot-Standby file backup leads to the currupted indexes

Поиск
Список
Период
Сортировка
От Fujii Masao
Тема Re: Re: BUG #5602: Recovering from Hot-Standby file backup leads to the currupted indexes
Дата
Msg-id AANLkTi=a4pyk2uUNG5LAKoumkjiOjZuD4n3_RV8Q1jHD@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Re: BUG #5602: Recovering from Hot-Standby file backup leads to the currupted indexes  (Simon Riggs <simon@2ndQuadrant.com>)
Ответы Re: Re: BUG #5602: Recovering from Hot-Standby file backup leads to the currupted indexes  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
On Fri, Aug 6, 2010 at 7:50 AM, Simon Riggs <simon@2ndquadrant.com> wrote:
> The procedure used does differ from that documented. However, IMHO the
> procedure *documented* is *not* safe and could lead to corrupt indexes
> in the way described, since the last recovered point might be mid-way
> between two halves of an index split record, which will never be
> corrected during HS.

An index split record is replayed by two calls of rm_redo()? If not,
we don't need to worry about the above since the last recovered point
which pg_last_xlog_replay_location() returns is updated after every
rm_redo().

Regards,

--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center

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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: BUG #5588: I use a lot of the "INHERITS", results of tests found that the performance is very low.
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Re: BUG #5602: Recovering from Hot-Standby file backup leads to the currupted indexes