Re: Does PostgreSQL check database integrity at startup? - Mailing list pgsql-general

From Jan Wieck
Subject Re: Does PostgreSQL check database integrity at startup?
Date
Msg-id CAGBW59fBrhado-6NbtT1LES9cTR2PM3syCTsmCF=svxeh4THJw@mail.gmail.com
Whole thread Raw
In response to Re: Does PostgreSQL check database integrity at startup?  (Stephen Frost <sfrost@snowman.net>)
Responses Re: Does PostgreSQL check database integrity at startup?
List 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 by date:

Previous
From: Stephen Frost
Date:
Subject: Re: Sv: Re: Sv: Re: Does PostgreSQL check database integrity atstartup?
Next
From: Ibrahim Edib Kokdemir
Date:
Subject: invalid memory alloc request size 576460752438159360