Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wAESJ-002Bgu-1E for pgsql-hackers@arkaria.postgresql.org; Tue, 07 Apr 2026 21:59:32 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wAESH-002kCV-2c for pgsql-hackers@arkaria.postgresql.org; Tue, 07 Apr 2026 21:59:30 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wAESH-002kCM-1P for pgsql-hackers@lists.postgresql.org; Tue, 07 Apr 2026 21:59:29 +0000 Received: from smtp.outgoing.loopia.se ([93.188.3.37]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wAESF-00000001Bfh-2GGx for pgsql-hackers@lists.postgresql.org; Tue, 07 Apr 2026 21:59:29 +0000 Received: from s807.loopia.se (localhost [127.0.0.1]) by s807.loopia.se (Postfix) with ESMTP id 5354D599F34 for ; Tue, 07 Apr 2026 23:59:26 +0200 (CEST) Received: from s981.loopia.se (unknown [172.22.191.6]) by s807.loopia.se (Postfix) with ESMTP id 3ACC559A113; Tue, 07 Apr 2026 23:59:26 +0200 (CEST) Received: from localhost (unknown [172.22.191.5]) by s981.loopia.se (Postfix) with ESMTP id 393E922B160F; Tue, 07 Apr 2026 23:59:26 +0200 (CEST) X-Virus-Scanned: amavis at amavis.loopia.se X-Spam-Flag: NO X-Spam-Score: -1.2 X-Spam-Level: X-Spam-Status: No, score=-1.2 tagged_above=-999 required=6.2 tests=[ALL_TRUSTED=-1, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1] autolearn=disabled Authentication-Results: s472.loopia.se (amavis); dkim=pass (2048-bit key) header.d=proxel.se Received: from s934.loopia.se ([172.22.191.5]) by localhost (s472.loopia.se [172.22.190.12]) (amavis, port 10024) with LMTP id XatvVo5vF2MD; Tue, 7 Apr 2026 23:59:25 +0200 (CEST) X-Loopia-Auth: user X-Loopia-User: andreas@proxel.se X-Loopia-Originating-IP: 147.28.75.140 Received: from [192.168.0.121] (customer-147-28-75-140.stosn.net [147.28.75.140]) (Authenticated sender: andreas@proxel.se) by s934.loopia.se (Postfix) with ESMTPSA id 9D51D7CE90E; Tue, 07 Apr 2026 23:59:25 +0200 (CEST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=proxel.se; s=loopiadkim1707418970; t=1775599165; bh=h3UenvDVcUaErPz0WeTbZcBjh7mJvwAOOsa+N7tr9gQ=; h=Date:Subject:To:References:From:In-Reply-To; b=PXo6jLBzTbf+1mW/ZhvMc6kM0UguRqzomTReEzuKaLgawlCljqhsiw158T9qR7oSg bxLiL50oJUhKEZbqRPu+RiHr93so01vlr/GnZ7szXvXFGMs99GvbDwfybQomh0ZeIt rdNTC0CqHXFefhhKG50Sq1fBzTf3wBZ+yPmA5QuF1hcKa0PMvJb/i14EZVQ90aKWys c/lU69MpAPKBvGXYFLqFJ0fJ4os70MKOjFo4GR8/1R0vcnIxd9qu9ePsW+SltYmSKI mvPeVIIN0uMMrQLPholQLnkExHhCitKXJVgkVi32TfyKWY70xXu1WVevlFk5gKqW02 7B5r6XGYm42qA== Message-ID: <78ff5cc9-268f-4be8-ae0b-c1a07dc24852@proxel.se> Date: Tue, 7 Apr 2026 23:59:24 +0200 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: doc: Improve wal_level and effective_wal_level GUC around logical replication To: "David G. Johnston" , PostgreSQL Hackers References: From: Andreas Karlsson Content-Language: en-US In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 3/4/26 4:55 PM, David G. Johnston wrote: > In evaluating the proposed change to wal_level docs in [1] I found it to > be undesirable, but the discussion and my own review discovered some > other changes that should be considered. While I am not happy with the text before I am not sure your changes here really make it much better, just different, hmm. > Since effective_wal_level now exists, Logical Replication Getting > Started needs to be updated. > Add links to the main topics that the different levels apply to. > Be explicit about the ordering of minimal, replica, and logical. > Move the behavior of effective_wal_level to the GUC for it, leaving > behind just the pointer that wal_level is now just a "minimum". Shouldn't it be: "Ensure that is at least replica" and "wal_level = replica" as the logical replication slot may be created later? -- Andreas Karlsson Percona