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 1nybBb-0004uT-0E for pgsql-hackers@arkaria.postgresql.org; Tue, 07 Jun 2022 15:32:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nybAb-0000n2-Ku for pgsql-hackers@arkaria.postgresql.org; Tue, 07 Jun 2022 15:31:01 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nybAb-0000ms-Be for pgsql-hackers@lists.postgresql.org; Tue, 07 Jun 2022 15:31:01 +0000 Received: from feynman.df7cb.de ([195.49.152.168]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nybAZ-0003B1-3o for pgsql-hackers@lists.postgresql.org; Tue, 07 Jun 2022 15:31:00 +0000 Received: from msg.df7cb.de (unknown [IPv6:2003:5b:203b:100:7627:eaff:fe52:8e03]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange ECDHE (P-256) server-signature ECDSA (P-384) server-digest SHA384) (Client did not present a certificate) by feynman.df7cb.de (Postfix) with ESMTPSA id 4LHZ7j4xPQz3F11; Tue, 7 Jun 2022 17:30:57 +0200 (CEST) Date: Tue, 7 Jun 2022 17:30:57 +0200 From: Christoph Berg To: "Jonathan S. Katz" Cc: Robert Haas , Tom Lane , Justin Pryzby , Julien Rouhaud , Pavel Stehule , "David G. Johnston" , Joe Conway , Mark Dilger , Andrew Dunstan , David Rowley , Alvaro Herrera , PostgreSQL Hackers Subject: Re: How about a psql backslash command to show GUCs? Message-ID: References: <9439380b-a81f-c910-f527-db4d470b026b@postgresql.org> <531275.1649707882@sss.pgh.pa.us> <7bba5a32-65fe-04e1-7c36-efd963a625c9@postgresql.org> <807242.1649776780@sss.pgh.pa.us> <20220606135529.GV29853@telsasoft.com> <918042.1654531335@sss.pgh.pa.us> <952350.1654549308@sss.pgh.pa.us> <29d873fa-ce53-0eeb-ddf5-0a0d38458d16@postgresql.org> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <29d873fa-ce53-0eeb-ddf5-0a0d38458d16@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Re: Jonathan S. Katz > On 6/7/22 10:26 AM, Robert Haas wrote: > I think some of these could be interesting if they deviate from the default > (e.g. "in_hot_standby") as it will give the user context on the current > state of the system. > > However, something like that is still fairly easy to determine (e.g. > `pg_catalog.pg_is_in_recovery()`). And looking through the settings marked > "internal" showing the non-defaults may not provide much additional context > to a user. in_hot_standby sounds very useful to have in that list. Christoph