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 1mViNk-0000jc-Pw for pgsql-hackers@arkaria.postgresql.org; Wed, 29 Sep 2021 22:48:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mViNj-0006SD-IF for pgsql-hackers@arkaria.postgresql.org; Wed, 29 Sep 2021 22:48:55 +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 1mViNj-0006S4-AU for pgsql-hackers@lists.postgresql.org; Wed, 29 Sep 2021 22:48:55 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mViNc-0007Oy-VV for pgsql-hackers@lists.postgresql.org; Wed, 29 Sep 2021 22:48:54 +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 18TMmWqS3006959; Wed, 29 Sep 2021 18:48: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: <41423ae2-eceb-16d6-0ee3-11abc3a5c50f@dunslane.net> References: <202109292127.7q66qhxhde67@alvherre.pgsql> <41423ae2-eceb-16d6-0ee3-11abc3a5c50f@dunslane.net> Comments: In-reply-to Andrew Dunstan message dated "Wed, 29 Sep 2021 17:40:47 -0400" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <3006957.1632955712.1@sss.pgh.pa.us> Date: Wed, 29 Sep 2021 18:48:32 -0400 Message-ID: <3006958.1632955712@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Andrew Dunstan writes: > On 9/29/21 5:27 PM, Alvaro Herrera wrote: >> So, do we take the stance that we have no right to expect pg_basebackup >> to work if we didn't pass allow_streaming => 1? If so, the fix is to >> add it. But my preferred fix would be to call set_replication_conf if >> either allows_streaming or has_archiving are given. >> >> Another easy fix would be to call $primary2->set_replication_conf in the >> test file, but then you'd complain that that's supposed to be an >> internal method :-) > It claims that but it's also used here: > src/bin/pg_basebackup/t/010_pg_basebackup.pl Given that precedent, it seems like calling set_replication_conf is a good quick-fix for getting the buildfarm green again. But +1 for then refactoring this to get rid of these hacks (both with respect to pg_hba.conf and the postgresql.conf parameters) in both of these tests. regards, tom lane