Re: Offline enabling/disabling of data checksums
Michael Banck <michael.banck@credativ.de>
From: Michael Banck <michael.banck@credativ.de>
To: Michael Paquier <michael@paquier.xyz>
Cc: Fabien COELHO <coelho@cri.ensmp.fr>, Postgres hackers <pgsql-hackers@postgresql.org>
Date: 2019-02-26T15:35:22Z
Lists: pgsql-hackers
Attachments
- offline-activation-of-checksums_V4.patch (text/x-patch) patch
Hi, Am Dienstag, den 19.02.2019, 14:02 +0900 schrieb Michael Paquier: > On Sun, Feb 17, 2019 at 07:31:38PM +0100, Michael Banck wrote: > > New patch attached. > > - * src/bin/pg_verify_checksums/pg_verify_checksums.c > + * src/bin/pg_checksums/pg_checksums.c > That's lacking a rename, or this comment is incorrect. Right, I started the rename, but then backed off pending further discussion whether I should submit that or whether the committer will just do it. I've backed those 4 in-file renames out for now. > +#if PG_VERSION_NUM >= 100000 > + StaticAssertStmt(sizeof(ControlFileData) <= PG_CONTROL_MAX_SAFE_SIZE, > + "pg_control is too large for atomic disk writes"); > +#endif > This is compiled with only one version of the control file data, so > you don't need that. Oops, yeah. > Any reason why we don't refactor updateControlFile() into > controldata_utils.c? This duplicates the code, at the exception of > some details. Ok, I've done that now, and migrated pg_rewind as well, do you know of any other programs that might benefit here? This could/should probably be committed separately beforehand. New patch attached. 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 Unser Umgang mit personenbezogenen Daten unterliegt folgenden Bestimmungen: https://www.credativ.de/datenschutz
Commits
-
Reorganize Notes section in documentation of pg_checksums
- a7cc52370b2b 12.0 landed
-
Add option -N/--no-sync to pg_checksums
- e0090c869008 12.0 landed
-
Add options to enable and disable checksums in pg_checksums
- ed308d783790 12.0 landed
-
Refactor more code logic to update the control file
- 8b938d36f744 12.0 landed
-
Rename pg_verify_checksums to pg_checksums
- 6dd263cfaa84 12.0 landed
-
Fix cross-version compatibility checks of pg_verify_checksums
- 501f58359b59 11.3 landed
- c9ae7f704c67 12.0 landed
-
Add routine able to update the control file to src/common/
- ce6afc6823fb 12.0 landed