Thread: BUG #17049: what is the parameter wal_consistency_checking default value ?
BUG #17049: what is the parameter wal_consistency_checking default value ?
From
PG Bug reporting form
Date:
The following bug has been logged on the website: Bug reference: 17049 Logged by: yanliang lei Email address: leiyanliang@highgo.com PostgreSQL version: 13.3 Operating system: CentOS7.6 Description: in the document https://www.postgresql.org/docs/current/runtime-config-developer.html there is the following description about parameter wal_consistency_checking: The default value of this setting is the empty string, which disables the feature but in the following sql statement’s rusult,parameter wal_consistency_checking default value is not empty string postgres=# select * from pg_settings where name='wal_consistency_checking'; -[ RECORD 1 ]---+--------------------------------------------------------------------------------------------------------- name | wal_consistency_checking setting | unit | category | Developer Options short_desc | Sets the WAL resource managers for which WAL consistency checks are done. extra_desc | Full-page images will be logged for all data blocks and cross-checked against the results of WAL replay. context | superuser vartype | string source | default min_val | max_val | enumvals | boot_val | reset_val | sourcefile | sourceline | pending_restart | f postgres=# select * from pg_settings where name='wal_consistency_checking' and name=''; (0 rows) ---->>>this result returns zero rows postgres=# select version(); -[ RECORD 1 ]---------------------------------------------------------------------------------------------------- version | PostgreSQL 13.3 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-44), 64-bit postgres=# this problem also applies to PostgreSQL 14 Beta1 Version。
Re: BUG #17049: what is the parameter wal_consistency_checking default value ?
From
"leiyanliang@highgo.com"
Date:
soryy,
select * from pg_settings where name='wal_consistency_checking' and name='';---->>>this sql is not correct
select * from pg_settings where name='wal_consistency_checking' and setting='';---->>>this sql is correct
so, BUG #17049 is not bug,please close this problem
祝工作顺利!
----------------------------------
类延良 技术支持部
瀚高基础软件股份有限公司
地址:济南市高新区新泺大街2117号铭盛大厦20层
手机:138-0531-7390 邮箱:leiyanliang@highgo.com
From: PG Bug reporting formDate: 2021-06-05 07:41Subject: BUG #17049: what is the parameter wal_consistency_checking default value ?The following bug has been logged on the website:Bug reference: 17049Logged by: yanliang leiEmail address: leiyanliang@highgo.comPostgreSQL version: 13.3Operating system: CentOS7.6Description:in the documenthttps://www.postgresql.org/docs/current/runtime-config-developer.htmlthere is the following description about parameterwal_consistency_checking:The default value of this setting is the empty string, which disables thefeaturebut in the following sql statement’s rusult,parameterwal_consistency_checking default value is not empty stringpostgres=# select * from pg_settings wherename='wal_consistency_checking';-[ RECORD 1]---+---------------------------------------------------------------------------------------------------------name | wal_consistency_checkingsetting |unit |category | Developer Optionsshort_desc | Sets the WAL resource managers for which WAL consistencychecks are done.extra_desc | Full-page images will be logged for all data blocks andcross-checked against the results of WAL replay.context | superuservartype | stringsource | defaultmin_val |max_val |enumvals |boot_val |reset_val |sourcefile |sourceline |pending_restart | fpostgres=# select * from pg_settings where name='wal_consistency_checking'and name='';(0 rows) ---->>>this result returns zero rowspostgres=# select version();-[ RECORD 1]----------------------------------------------------------------------------------------------------version | PostgreSQL 13.3 on x86_64-pc-linux-gnu, compiled by gcc (GCC)4.8.5 20150623 (Red Hat 4.8.5-44), 64-bitpostgres=#this problem also applies to PostgreSQL 14 Beta1 Version。