Skip to content

Commit a7cc523

Browse files
committed
Reorganize Notes section in documentation of pg_checksums
This commit reorders the paragraphs of the Notes section in order of importance, and clarifies better the safe uses of pg_checksums for replication setups. Author: Fabien Coelho Discussion: https://postgr.es/m/alpine.DEB.2.21.1903231404280.18811@lancre
1 parent c0a2ff4 commit a7cc523

File tree

1 file changed

+18
-20
lines changed

1 file changed

+18
-20
lines changed

doc/src/sgml/ref/pg_checksums.sgml

Lines changed: 18 additions & 20 deletions
Original file line numberDiff line numberDiff line change
@@ -179,29 +179,27 @@ PostgreSQL documentation
179179
<refsect1>
180180
<title>Notes</title>
181181
<para>
182-
When disabling or enabling checksums in a replication setup of multiple
183-
clusters, it is recommended to stop all the clusters before doing
184-
the switch to all the clusters consistently. When using a replication
185-
setup with tools which perform direct copies of relation file blocks
186-
(for example <xref linkend="app-pgrewind"/>), enabling or disabling
187-
checksums can lead to page corruptions in the shape of incorrect
188-
checksums if the operation is not done consistently across all nodes.
189-
Destroying all the standbys in the setup first, enabling or disabling
190-
checksums on the primary and finally recreating the standbys from
191-
scratch is also safe.
182+
Enabling checksums in a large cluster can potentially take a long time.
183+
During this operation, the cluster or other programs that write to the
184+
data directory must not be started or else data loss may occur.
192185
</para>
193186
<para>
194-
If <application>pg_checksums</application> is aborted or killed in
195-
its operation while enabling or disabling checksums, the cluster
196-
will have the same state with respect of checksums as before the
197-
operation and <application>pg_checksums</application> needs to be
198-
restarted.
187+
When using a replication setup with tools which perform direct copies
188+
of relation file blocks (for example <xref linkend="app-pgrewind"/>),
189+
enabling or disabling checksums can lead to page corruptions in the
190+
shape of incorrect checksums if the operation is not done consistently
191+
across all nodes. When enabling or disabling checksums in a replication
192+
setup, it is thus recommended to stop all the clusters before switching
193+
them all consistently. Destroying all standbys, performing the operation
194+
on the primary and finally recreating the standbys from scratch is also
195+
safe.
199196
</para>
200197
<para>
201-
When enabling checksums in a cluster, the operation can potentially
202-
take a long time if the data directory is large. During this operation,
203-
the cluster or other programs that write to the data directory must not
204-
be started or else data loss may occur.
205-
</para>
198+
If <application>pg_checksums</application> is aborted or killed while
199+
enabling or disabling checksums, the cluster will keep the same
200+
configuration for data checksums as before the operation attempted.
201+
<application>pg_checksums</application> can be restarted to
202+
attempt again the same operation.
203+
</para>
206204
</refsect1>
207205
</refentry>

0 commit comments

Comments
 (0)