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 1nEfbP-0000PM-Bu for pgsql-hackers@arkaria.postgresql.org; Mon, 31 Jan 2022 22:56:51 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nEfbO-0005jH-7P for pgsql-hackers@arkaria.postgresql.org; Mon, 31 Jan 2022 22:56:50 +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 1nEfbN-0005j8-UT for pgsql-hackers@lists.postgresql.org; Mon, 31 Jan 2022 22:56:49 +0000 Received: from mail-il1-x12e.google.com ([2607:f8b0:4864:20::12e]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1nEfbL-0001I8-FD for pgsql-hackers@lists.postgresql.org; Mon, 31 Jan 2022 22:56:48 +0000 Received: by mail-il1-x12e.google.com with SMTP id o10so12818018ilh.0 for ; Mon, 31 Jan 2022 14:56:47 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20210112.gappssmtp.com; s=20210112; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to:user-agent; bh=UTMQ5BsIhwc3bV1Tjwsnqplpnuu2fG0E35FFWvYSmHM=; b=4eC13ia3x1YHjxTg8izMumvxIpZaHrw5Muoc4jXNiICJvl9/lAQBnjrchIQ4KwltKC 79RMYDyBtVk+V4X6kbiutCKW22H/kBFlEvyXYAFqDEaYVEhyfkJF/D1DsnGjAP7E+cJq 65zzC28z1B2MeNzs7C308ml6x3sRhAXR5rlQGAiSa44hSq4Xn/nXfXNmfAuA1kSf3mxT EM5dT3HjUYZx/9yiFfeFPKaONsIaB5lICnqkAWBz+/nEk4WEwGZyH4nsYSwsDdUMYF5b ztVCt3EmTwJz9SH5zkis06iC05t1PGHJsrHWnpSX/gSriOKqu2YGlqxvJx/rBXfflKjb ECsQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to:user-agent; bh=UTMQ5BsIhwc3bV1Tjwsnqplpnuu2fG0E35FFWvYSmHM=; b=fcT0V9suqPW5g8TYMTuq1c6v1RML/nY1uVhJM0GzpF8l8WhETMmiZnCs8IQUa0xkEB t0rHITOnd7mvI5R5J8V2go/FhmoGjHxcZ1Jb2WcPfjlgrp4kRHxYvYHhQgVr2EX45ESA 7UCgaP/YfMZEAOEN7dk3tu9PPvcf+QA43SMJQEaViAimqotSQXxclWn7TUBNIYtmNPlz xk3ekTC6x55SYNc6fHy9pLjgtDndVPwcbbsX87HANwnbhl6FhYMQstiC+7PcZ6gibbhL ucZrbvGg4pfIRrzu14+gInqYdhKOGt1mzLK2G8j7/zZO9fQV12V7CRIa6Qh83curK7oo u4Kg== X-Gm-Message-State: AOAM532njMSXfc0GeNxUeUS+lNefZTDXFWJiC6qsvQjylLKQnTxJCXnG mgcJF9dvcgDMiavm/1+Sr4kmxQ== X-Google-Smtp-Source: ABdhPJztrG3Ndvci9jZeVFobfmJ1HVwCeWbQHIVVfyOHBS0f/WuyMGu0rNlbw2tuxKEblLTa8nBiJw== X-Received: by 2002:a05:6e02:1e04:: with SMTP id g4mr4412268ila.188.1643669806792; Mon, 31 Jan 2022 14:56:46 -0800 (PST) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id r9sm8997212iov.26.2022.01.31.14.56.46 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Mon, 31 Jan 2022 14:56:46 -0800 (PST) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id AA488800DBA; Mon, 31 Jan 2022 16:56:45 -0600 (CST) Date: Mon, 31 Jan 2022 16:56:45 -0600 From: Justin Pryzby To: Michael Paquier Cc: Peter Eisentraut , Kyotaro Horiguchi , pgsql-hackers@lists.postgresql.org, bruce@momjian.us, tgl@sss.pgh.pa.us Subject: Re: GUC flags Message-ID: <20220131225645.GZ23027@telsasoft.com> References: <20220125010729.GC23027@telsasoft.com> <20220125180751.GH23027@telsasoft.com> <20220126034426.GN23027@telsasoft.com> <20220128043621.GA23027@telsasoft.com> <20220130001849.GR23027@telsasoft.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: 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 On Mon, Jan 31, 2022 at 02:17:41PM +0900, Michael Paquier wrote: > With all those doc fixes, applied after an extra round of review. So > this makes us rather covered with the checks on the flags. Thanks > Now, what do we do with the rest of check_guc that involve a direct > lookup at what's on disk. We have the following: > 1) Check the format of the option lists in guc.c. > 2) Check the format of postgresql.conf.sample: > -- Valid options preceded by a '#' character. > -- Valid options followed by ' =', with at least one space before the > equal sign. > 3) Check that options not marked as NOT_IN_SAMPLE are in the sample > file. > > I have never seen 1) as a problem, and pgindent takes care of that at > some degree. 2) is also mostly cosmetic, and committers are usually > careful when adding a new GUC. 3) would be the most interesting > piece, and would cover most cases if we consider that a default > installation just copies postgresql.conf.sample over, as proposed > upthread in 0002. > > Now, 3) has also the problem that it would fail installcheck as one > can freely add a developer option in the configuration. We could I'm not clear on what things are required/prohibited to allow/expect "installcheck" to pass. It's possible that postgresql.conf doesn't even exist in the data dir, right ? It's okay with me if the config_file-reading stuff isn't re-implemented. -- Justin