Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commita7cc523

Browse files
committed
Reorganize Notes section in documentation of pg_checksums
This commit reorders the paragraphs of the Notes section in order ofimportance, and clarifies better the safe uses of pg_checksums forreplication setups.Author: Fabien CoelhoDiscussion:https://postgr.es/m/alpine.DEB.2.21.1903231404280.18811@lancre
1 parentc0a2ff4 commita7cc523

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)

[8]ページ先頭

©2009-2025 Movatter.jp