From: leiyanliang@highgo.com <leiyanliang@highgo.com>
To: leiyanliang@highgo.com <leiyanliang@highgo.com>
To: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
Subject: Re: BUG #17049: what is the parameter wal_consistency_checking default value ?
Date: Sat, 5 Jun 2021 08:03:30 +0800
Message-ID: <202106050802300708451@highgo.com> (raw)
References: <17049-def7e58e4b94cfb8@postgresql.org>
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@highgo.com
From: PG Bug reporting form
Date: 2021-06-05 07:41
To: pgsql-bugs@lists.postgresql.org
CC: leiyanliang@highgo.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@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。
Attachments:18486_clip_image001.png (image/png, 18.1K) downloadview image
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: leiyanliang@highgo.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #17049: what is the parameter wal_consistency_checking default value ?
In-Reply-To: <202106050802300708451@highgo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox