Hi, On Wed, Feb 21, 2018 at 09:53:31PM +0100, Magnus Hagander wrote: > We’ve also included a small commandline tool, bin/pg_verify_checksums, > that can be run against an offline cluster to validate all checksums.
The way it is coded in the patch will make pg_verify_checksums fail for heap files with multiple segments, i.e. tables over 1 GB, becuase the block number is consecutive and you start over from 0: $ pgbench -i -s 80 -h /tmp [...] $ pg_verify_checksums -D data1 pg_verify_checksums: data1/base/12364/16396.1, block 0, invalid checksum in file 6D61, calculated 6D5F pg_verify_checksums: data1/base/12364/16396.1, block 1, invalid checksum in file 7BE5, calculated 7BE7 [...] Checksum scan completed Data checksum version: 1 Files scanned: 943 Blocks scanned: 155925 Bad checksums: 76 Michael -- Michael Banck Projektleiter / Senior Berater Tel.: +49 2166 9901-171 Fax: +49 2166 9901-100 Email: michael.ba...@credativ.de credativ GmbH, HRB Mönchengladbach 12080 USt-ID-Nummer: DE204566209 Trompeterallee 108, 41189 Mönchengladbach Geschäftsführung: Dr. Michael Meskes, Jörg Folz, Sascha Heuer
