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 1mVx3N-0001VE-Tp for pgsql-hackers@arkaria.postgresql.org; Thu, 30 Sep 2021 14:28:53 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mVx3M-0008LK-TW for pgsql-hackers@arkaria.postgresql.org; Thu, 30 Sep 2021 14:28:52 +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 1mVx3M-0008LC-Lk for pgsql-hackers@lists.postgresql.org; Thu, 30 Sep 2021 14:28:52 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mVx3K-0005cp-MP for pgsql-hackers@lists.postgresql.org; Thu, 30 Sep 2021 14:28:51 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 18UESWhe3060992; Thu, 30 Sep 2021 10:28:32 -0400 From: Tom Lane To: Andrew Dunstan cc: Alvaro Herrera , "Bossart, Nathan" , Kyotaro Horiguchi , "andres@anarazel.de" , "masao.fujii@oss.nttdata.com" , "pgsql-hackers@lists.postgresql.org" , "mengjuan.cmj@alibaba-inc.com" , "Jakub.Wartak@tomtom.com" , Ryo Matsumura Subject: Re: prevent immature WAL streaming In-reply-to: <97ccf47e-e4f9-28b6-e780-83821f1da69c@dunslane.net> References: <202109291443.dxsnnji7a4dq@alvherre.pgsql> <3000074.1632947632@sss.pgh.pa.us> <06126430-07db-7051-a4c7-17edbe4ac34e@dunslane.net> <3003011.1632950979@sss.pgh.pa.us> <97ccf47e-e4f9-28b6-e780-83821f1da69c@dunslane.net> Comments: In-reply-to Andrew Dunstan message dated "Thu, 30 Sep 2021 10:18:39 -0400" MIME-Version: 1.0 Content-Type: text/plain; charset="UTF-8" Content-ID: <3060990.1633012112.1@sss.pgh.pa.us> Content-Transfer-Encoding: 8bit Date: Thu, 30 Sep 2021 10:28:32 -0400 Message-ID: <3060991.1633012112@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Andrew Dunstan writes: > Regardless of this problem, I think we should simply call > set_replication_conf unconditionally in init().  Replication connections > are now allowed by default on Unix, this would just bring Windows nodes > into line with that. Yeah, I was thinking along the same lines yesterday. The fact that pre-commit testing failed to note the problem is exactly because we have this random difference between what works by default on Unix and what works by default on Windows. Let's close that gap before it bites us again. There's still the issue of these tests overriding postgresql.conf entries made by init(), but maybe we can live with that? regards, tom lane