From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: leiyanliang@highgo.com
Subject: BUG #17049: what is the parameter wal_consistency_checking default value ?
Date: Fri, 04 Jun 2021 23:41:09 +0000
Message-ID: <17049-def7e58e4b94cfb8@postgresql.org> (raw)
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。
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: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, leiyanliang@highgo.com
Subject: Re: BUG #17049: what is the parameter wal_consistency_checking default value ?
In-Reply-To: <17049-def7e58e4b94cfb8@postgresql.org>
* 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