On Sat, Dec 30, 2017 at 10:27 AM, Stephen Frost <sfrost@xxxxxxxxxxx> 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
Senior Postgres Architect