| From: | Jan Wieck <jan(at)wi3ck(dot)info> |
|---|---|
| To: | Stephen Frost <sfrost(at)snowman(dot)net> |
| Cc: | Alban Hertroys <haramrae(at)gmail(dot)com>, Edson Carlos Ericksson Richter <richter(at)simkorp(dot)com(dot)br>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Does PostgreSQL check database integrity at startup? |
| Date: | 2017-12-31 03:10:59 |
| Message-ID: | CAGBW59fBrhado-6NbtT1LES9cTR2PM3syCTsmCF=svxeh4THJw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sat, Dec 30, 2017 at 10:27 AM, Stephen Frost <sfrost(at)snowman(dot)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
http://pgblog.wi3ck.info
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ibrahim Edib Kokdemir | 2017-12-31 13:50:45 | invalid memory alloc request size 576460752438159360 |
| Previous Message | Stephen Frost | 2017-12-31 01:03:15 | Re: Sv: Re: Sv: Re: Does PostgreSQL check database integrity at startup? |