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

Commit7106f74

Browse files
committed
Clarify documentation to state that "zero_damaged_pages" does not force
data to disk, so the table or index should be recreated before theparameter is turned off again.
1 parent15f55cc commit7106f74

File tree

1 file changed

+8
-6
lines changed

1 file changed

+8
-6
lines changed

‎doc/src/sgml/config.sgml

Lines changed: 8 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -6059,15 +6059,17 @@ LOG: CleanUpLock: deleting: lock(0xb7acd844) id(24688,24696,0,0,0,1)
60596059
<para>
60606060
Detection of a damaged page header normally causes
60616061
<productname>PostgreSQL</> to report an error, aborting the current
6062-
command. Setting <varname>zero_damaged_pages</> to on causes
6063-
the system to instead report a warning, zero out the damaged page,
6064-
and continue processing. This behavior <emphasis>will destroy data</>,
6065-
namely all the rows on the damaged page.But itallows you to get
6062+
transaction. Setting <varname>zero_damaged_pages</> to on causes
6063+
the system to instead report a warning, zero out the damaged
6064+
page in memory,and continue processing. This behavior <emphasis>will destroy data</>,
6065+
namely all the rows on the damaged page.However, itdoes allow you to get
60666066
past the error and retrieve rows from any undamaged pages that might
6067-
be present in the table.So it is useful for recovering data if
6067+
be present in the table.It is useful for recovering data if
60686068
corruption has occurred due to a hardware or software error. You should
60696069
generally not set this on until you have given up hope of recovering
6070-
data from the damaged pages of a table. The
6070+
data from the damaged pages of a table. Zerod-out pages are not
6071+
forced to disk so it is recommended to recreate the table or
6072+
the index before turning this parameter off again. The
60716073
default setting is <literal>off</>, and it can only be changed
60726074
by a superuser.
60736075
</para>

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp