pg.ddx.io pgsql-bugs@postgresql.org mailing list archivehelp / color / mirror / Atom feed
BUG #17049: what is the parameter wal_consistency_checking default value ? 2+ messages / 2 participants [nested] [flat]
* BUG #17049: what is the parameter wal_consistency_checking default value ? @ 2021-06-04 23:41 PG Bug reporting form <noreply@postgresql.org> 0 siblings, 1 reply; 2+ messages in thread From: PG Bug reporting form @ 2021-06-04 23:41 UTC (permalink / raw) To: pgsql-bugs@lists.postgresql.org; +Cc: leiyanliang@highgo.com 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。 ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: BUG #17049: what is the parameter wal_consistency_checking default value ? @ 2021-06-05 00:03 leiyanliang@highgo.com <leiyanliang@highgo.com> parent: PG Bug reporting form <noreply@postgresql.org> 0 siblings, 0 replies; 2+ messages in thread From: leiyanliang@highgo.com @ 2021-06-05 00:03 UTC (permalink / raw) To: leiyanliang@highgo.com <leiyanliang@highgo.com>; pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.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:^ permalink raw reply [nested|flat] 2+ messages in thread18486_clip_image001.png (image/png, 18.1K) download
view image
end of thread, other threads:[~2021-06-05 00:03 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2021-06-04 23:41 BUG #17049: what is the parameter wal_consistency_checking default value ? PG Bug reporting form <noreply@postgresql.org> 2021-06-05 00:03 ` leiyanliang@highgo.com <leiyanliang@highgo.com>
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