Re: [PATCH] Verify Checksums during Basebackups
Michael Banck <michael.banck@credativ.de>
From: Michael Banck <michael.banck@credativ.de>
To: David Steele <david@pgmasters.net>, pgsql-hackers@lists.postgresql.org
Cc: Stephen Frost <sfrost@snowman.net>, Magnus Hagander
<magnus@hagander.net>, Robert Haas <robertmhaas@gmail.com>
Date: 2018-03-24T14:32:15Z
Lists: pgsql-hackers
Attachments
- basebackup-verify-checksum_suppress_warnings.patch (text/x-patch) patch
Hi, Am Freitag, den 23.03.2018, 17:43 +0100 schrieb Michael Banck: > Am Freitag, den 23.03.2018, 10:54 -0400 schrieb David Steele: > > In my experience actual block errors are relatively rare, so there > > aren't likely to be more than a few in a file. More common are > > overwritten or transposed files, rogue files, etc. These produce a lot > > of output. > > > > Maybe stop after five? The attached patch does that, and outputs the total number of verification failures of that file after it got sent. > I'm on board with this, but I have the feeling that this is not a very > common pattern in Postgres, or might not be project style at all. I > can't remember even seen an error message like that. > > Anybody know whether we're doing this in a similar fashion elsewhere? I tried to have look around and couldn't find any examples, so I'm not sure that patch should go in. On the other hand, we abort on checksum failures usually (in pg_dump e.g.), so limiting the number of warnings does makes sense. I guess we need to see what others think. Michael -- Michael Banck Projektleiter / Senior Berater Tel.: +49 2166 9901-171 Fax: +49 2166 9901-100 Email: michael.banck@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
Commits
-
Validate page level checksums in base backups
- 4eb77d50c21d 11.0 landed