Re: Does PostgreSQL check database integrity at startup?

Поиск
Список
Период
Сортировка
От Jan Wieck
Тема Re: Does PostgreSQL check database integrity at startup?
Дата
Msg-id CAGBW59fBrhado-6NbtT1LES9cTR2PM3syCTsmCF=svxeh4THJw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Does PostgreSQL check database integrity at startup?  (Stephen Frost <sfrost@snowman.net>)
Ответы Re: Does PostgreSQL check database integrity at startup?  (Stephen Frost <sfrost@snowman.net>)
Список pgsql-general
Дерево обсуждения


On Sat, Dec 30, 2017 at 10:27 AM, Stephen Frost <sfrost@snowman.net> wrote:

The checksums included in PG are page-level and therefore there simply
isn't one to look at if the file is zero bytes.

And even if the file wasn't zero bytes you can't tell from the per page CRCs if you have all the pages you should have. You could have extra pages that aren't supposed to  be there or missing some (or any mix of the two). A per page CRC is useless for those cases.


Regards, Jan



 

Thanks!

Stephen



--
Jan Wieck
Senior Postgres Architect

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

Предыдущее
От: Stephen Frost
Дата:
Сообщение: Re: Sv: Re: Sv: Re: Does PostgreSQL check database integrity atstartup?
Следующее
От: Ibrahim Edib Kokdemir
Дата:
Сообщение: invalid memory alloc request size 576460752438159360