Re: Online verification of checksums

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: Online verification of checksums
Дата
Msg-id 20201120072801.GF8506@paquier.xyz
обсуждение исходный текст
Ответ на Re: Online verification of checksums  (Magnus Hagander <magnus@hagander.net>)
Ответы Re: Online verification of checksums
Список pgsql-hackers
On Mon, Nov 16, 2020 at 11:41:51AM +0100, Magnus Hagander wrote:
> I was referring to the latest patch on the thread. But as I said, I have
> not read up on all the different issues raised in the thread, so take it
> with a big grain os salt.
>
> And I would also echo the previous comment that this code was adapted from
> what the pgbackrest folks do. As such, it would be good to get a comment
> from for example David on that -- I don't see any of them having commented
> after that was mentioned?

Agreed.  I am adding Stephen as well in CC.  From the code of
backrest, the same logic happens in src/command/backup/pageChecksum.c
(see pageChecksumProcess), where two checks on pd_upper and pd_lsn
happen before verifying the checksum.  So, if the page header finishes
with random junk because of some kind of corruption, even corrupted
pages would be incorrectly considered as correct if the random data
passes the pd_upper and pg_lsn checks :/
--
Michael

Вложения

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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: Skip ExecCheckRTPerms in CTAS with no data
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: Skip ExecCheckRTPerms in CTAS with no data