Add options to enable and disable checksums in pg_checksums
Michael Paquier <michael@paquier.xyz>
Add options to enable and disable checksums in pg_checksums An offline cluster can now work with more modes in pg_checksums: - --enable enables checksums in a cluster, updating all blocks with a correct checksum, and updating the control file at the end. - --disable disables checksums in a cluster, updating only the control file. - --check is an extra option able to verify checksums for a cluster, and the default used if no mode is specified. When running --enable or --disable, the data folder gets fsync'd for durability, and then it is followed by a control file update and flush to keep the operation consistent should the tool be interrupted, killed or the host unplugged. If no mode is specified in the options, then --check is used for compatibility with older versions of pg_checksums (named pg_verify_checksums in v11 where it was introduced). Author: Michael Banck, Michael Paquier Reviewed-by: Fabien Coelho, Magnus Hagander, Sergei Kornilov Discussion: https://postgr.es/m/20181221201616.GD4974@nighthawk.caipicrew.dd-dns.de
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/ref/pg_checksums.sgml | modified | +74 −5 |
| src/bin/pg_checksums/pg_checksums.c | modified | +149 −26 |
| src/bin/pg_checksums/t/002_actions.pl | modified | +61 −15 |
| src/tools/pgindent/typedefs.list | modified | +1 −0 |
Documentation touched
Discussion
- Offline enabling/disabling of data checksums 149 messages · 2018-12-21 → 2019-03-29