Re: BUG #17049: what is the parameter wal_consistency_checking default value ?

From: "leiyanliang(at)highgo(dot)com" <leiyanliang(at)highgo(dot)com>
To: "leiyanliang(at)highgo(dot)com" <leiyanliang(at)highgo(dot)com>, "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #17049: what is the parameter wal_consistency_checking default value ?
Date: 2021-06-05 00:03:30
Message-ID: 202106050802300708451@highgo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

祝工作顺利!
----------------------------------
类延良 技术支持部
瀚高基础软件股份有限公司
网址:www.highgo.com
地址:济南市高新区新泺大街2117号铭盛大厦20层
手机:138-0531-7390 邮箱:leiyanliang(at)highgo(dot)com

From: PG Bug reporting form
Date: 2021-06-05 07:41
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
CC: leiyanliang(at)highgo(dot)com
Subject: BUG #17049: what is the parameter wal_consistency_checking default value ?
The following bug has been logged on the website:

Bug reference: 17049
Logged by: yanliang lei
Email address: leiyanliang(at)highgo(dot)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。

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2021-06-05 00:07:05 Re: logical decoding bug: segfault in ReorderBufferToastReplace()
Previous Message PG Bug reporting form 2021-06-04 23:41:09 BUG #17049: what is the parameter wal_consistency_checking default value ?