Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oHBym-0004L6-91 for pgsql-hackers@arkaria.postgresql.org; Thu, 28 Jul 2022 22:27:40 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oHByl-0002uF-4m for pgsql-hackers@arkaria.postgresql.org; Thu, 28 Jul 2022 22:27:39 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oHByk-0002tm-RS for pgsql-hackers@lists.postgresql.org; Thu, 28 Jul 2022 22:27:38 +0000 Received: from mail-io1-xd30.google.com ([2607:f8b0:4864:20::d30]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1oHByi-0008Nl-K8 for pgsql-hackers@postgresql.org; Thu, 28 Jul 2022 22:27:37 +0000 Received: by mail-io1-xd30.google.com with SMTP id e69so2468565iof.5 for ; Thu, 28 Jul 2022 15:27:36 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20210112.gappssmtp.com; s=20210112; h=user-agent:in-reply-to:content-disposition:mime-version:references :message-id:subject:cc:to:from:date:from:to:cc; bh=WUYePClUCRZmeCgMX2sDswB+lIRP5easV/vsw99b8sY=; b=wBqZGhTb2sh6hk2mtuugoJepS+FJ9qs6qH+8n7dZeN6esMsqJRL8U7aESVoS+x4qF0 89pSGrDyDWA/ob+BnBBryx2uYkyJgaOv2OxQVfJGHuDducp7W8sLTQRwH6IMdbl5S0vZ ywMj/7eV0HttB/Ls/LQilfbhIDs9s0XSkynqD4jhkMJJXsXDeZytCTmMPa6btkQOawoS yw2U2YECqflQG2Qz0A46NXwCicGeMEMFh/wmuf6zLbo/U3BXfXtweNNHKy5IWbEe7Jf8 TroU6E/TmzlXz2TFyfDABEKZMntSubaaBOw9jugc+ScMdQguCgtqEWlq46ph5ZvZecZz rQ5w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=user-agent:in-reply-to:content-disposition:mime-version:references :message-id:subject:cc:to:from:date:x-gm-message-state:from:to:cc; bh=WUYePClUCRZmeCgMX2sDswB+lIRP5easV/vsw99b8sY=; b=Wl2fldkjlkFoAlBhZhlLigbUTV1aeGeM4EW3e9s6wGVNTQMmqc0MQtLnUA65yW9t9b tF3b+O+8QSyZQ4/CMvHi10I3Ng/dFS2sHK9jaJWhMtzN9VvQq9fqA+uv7+yErwsck2PK psht5gvH8tDM5mmptcZrYHLNeZdmsCzdVzR5yS24zwXL76ZT8oWDh2cdH4K1LVsgiKMW qZ8CZnfCly6g2ZxN5hbupf2nrNgami4EON767SEGWwcgPt11BqrmnOEvSxf9wqKqeCk1 c5SFOoiVomVmd7+cCrG9b26UiWZqn6T6hWrqHUhgtVI3rgJpx3caTqVKLnZ0epbwf3YO B8GA== X-Gm-Message-State: AJIora95yOeRFoYFKnOr8QaHFB/ME7knVl2lSDiQZSBZSFpNKecpxu5p FIXQCDxo3tyYThNw6TK8q7nIog== X-Google-Smtp-Source: AGRyM1u1WwGjqev7Cj1uf7AiR477jTrZgPiNXKGgtp132kvIKk5nVTol7I7HcsxGL5uHNq2zwNSQhw== X-Received: by 2002:a02:c6a6:0:b0:33f:4e18:73ef with SMTP id o6-20020a02c6a6000000b0033f4e1873efmr370201jan.298.1659047255830; Thu, 28 Jul 2022 15:27:35 -0700 (PDT) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id m40-20020a05663840a800b0032b3a7817acsm890841jam.112.2022.07.28.15.27.35 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Thu, 28 Jul 2022 15:27:35 -0700 (PDT) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id E9BEA80086E; Thu, 28 Jul 2022 17:27:34 -0500 (CDT) Date: Thu, 28 Jul 2022 17:27:34 -0500 From: Justin Pryzby To: Kyotaro Horiguchi Cc: michael@paquier.xyz, andres@anarazel.de, nathandbossart@gmail.com, pgsql-hackers@postgresql.org Subject: Re: fix stats_fetch_consistency value in postgresql.conf.sample Message-ID: <20220728222734.GA1913@telsasoft.com> References: <20220713173000.GD18011@telsasoft.com> <20220713235444.GF18011@telsasoft.com> <20220719.150427.952514686871468436.horikyota.ntt@gmail.com> <20220720051226.GH12702@telsasoft.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20220720051226.GH12702@telsasoft.com> User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Note that this can currently exposes internal elog() errors to users: postgres=# select pg_normalize_config_value('log_min_messages','abc'); WARNING: invalid value for parameter "log_min_messages": "abc" HINT: Available values: debug5, debug4, debug3, debug2, debug1, info, notice, warning, error, log, fatal, panic. ERROR: could not find enum option 0 for log_min_messages postgres=# \errverbose ERROR: XX000: could not find enum option 0 for log_min_messages LOCATION: config_enum_lookup_by_value, guc.c:7284