Re: More issues with pg_verify_checksums and checksum verification in base backups
Andres Freund <andres@anarazel.de>
From: Andres Freund <andres@anarazel.de>
To: Stephen Frost <sfrost@snowman.net>
Cc: Michael Banck <michael.banck@credativ.de>, Michael Paquier <michael@paquier.xyz>, pgsql-hackers@postgresql.org
Date: 2019-08-06T15:13:37Z
Lists: pgsql-hackers
Hi, On 2019-08-06 10:58:15 -0400, Stephen Frost wrote: > * Michael Banck (michael.banck@credativ.de) wrote: > > Independently of the whitelist/blacklist question, I believe > > pg_checksums should not error out as soon as it encounters a weird looking > > file, but either (i) still checksum it or (ii) skip it? Or is that to be > > considered a pilot error and it's fine for pg_checksums to fold? > > imv, random files that we don't know about are exactly 'pilot error' to > be complained about.. This is exactly why the whitelist idea falls > over. I still think this whole assumption is bad, and that you're fixing non-problems, and creating serious usability issues with zero benefits. Greetings, Andres Freund
Commits
-
Fix various checksum check problems for pg_verify_checksums and base backups
- 19516afdf167 11.2 landed
- 5c995139752f 12.0 landed
-
Switch pg_verify_checksums back to a blacklist
- 85036308dc58 11.2 landed
- a1c91dd1108c 12.0 landed