Wiki / 配置参数

This parameter is intended to be used to check for bugs in the WAL redo routines. When enabled, full-page images of any buffers modified in conjunction with the WAL record are added to the record. If the record is subsequently replayed, the system will first apply each record and then test whether the buffers modified by the record match the stored images. In certain cases (such as hint bits), minor variations are acceptable, and will be ignored. Any unexpected differences will result in a fatal error, terminating recovery. The default value of this setting is the empty string, which disables the feature. It can be set to all to check all records, or to a comma-separated list of resource managers to check only records originating from those resource managers. Currently, the supported resource managers are heap, heap2, btree, hash, gin, gist, sequence, spgist, brin, and generic. Extensions may define additional resource managers. Only superusers and users with the appropriate SET privilege can change this setting.

英文手册覆盖始于 PostgreSQL 7.4. 来源历史与运行验证各自保留独立版本边界。

此版本暂无所选语言的定义，以下显示原始英文内容。

boot val

未知

category

Developer Options

context

superuser

documented

true

enumvals

未知

extra desc

Full-page images will be logged for all data blocks and cross-checked against the results of WAL replay.

lang

en

max val

未知

metadata version

18

min val

未知

name

wal_consistency_checking

short desc

Sets the WAL resource managers for which WAL consistency checks are done.

source

pg-settings-source-snapshot

unit

未知

vartype

string