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 1obfSP-00052o-DX for pgsql-hackers@arkaria.postgresql.org; Fri, 23 Sep 2022 09:58: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 1obfSN-0005mC-HQ for pgsql-hackers@arkaria.postgresql.org; Fri, 23 Sep 2022 09:58:51 +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 1obfSM-0005lx-Er for pgsql-hackers@lists.postgresql.org; Fri, 23 Sep 2022 09:58:51 +0000 Received: from out2-smtp.messagingengine.com ([66.111.4.26]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1obfSI-0006z3-V5 for pgsql-hackers@postgresql.org; Fri, 23 Sep 2022 09:58:49 +0000 Received: from compute2.internal (compute2.nyi.internal [10.202.2.46]) by mailout.nyi.internal (Postfix) with ESMTP id 319D15C00BF; Fri, 23 Sep 2022 05:58:45 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute2.internal (MEProxy); Fri, 23 Sep 2022 05:58:45 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:date:date:feedback-id:feedback-id:from:from :in-reply-to:in-reply-to:message-id:mime-version:references :reply-to:sender:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm2; t=1663927125; x= 1664013525; bh=QvEQczIVMewoH+iGaBI90XExZOP0hXnghDrWN0/UlHc=; b=x fOJkrkD7+0oNfC9xEaZIGXF63c+BnIvRGEP7VrM9AlcX0/+0nRzsKEJbI2PolYMZ np2plgI21qMt558V9YqC9qlqwBhpzJzErog9M8M7zCQPQTmegjpqovm36i7MxgNR 6RYVwNmqwtxAYrGvm+wXNYP8pw9Ea5kxBJqnJAvyZ2B/juKwfiE4VGIx4ujP95U3 c7q8XJGxMr/7QKMj4ShmMauXbtYf+2Zvl8JTUh5xX1pYkSgKDuxevnujU5DEpeuV UwUAPS7aLE2Ql6AyP3A4fS7GcQtSbL43cBWzSeN/o7wk8AhpxMJQQVzRgTQMfWxu OZBIEG5F427Nswbm/ATkw== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvfedrfeefiedgvdegucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepkfffgggfuffvvehfhfgjtgfgsehtjeertddtfeejnecuhfhrohhmpefrvght vghrucfgihhsvghnthhrrghuthcuoehpvghtvghrrdgvihhsvghnthhrrghuthesvghnth gvrhhprhhishgvuggsrdgtohhmqeenucggtffrrghtthgvrhhnpeehleffgeegudejteei hfelteduvdeifffhffdvjedvffegjeekudeludehudeifeenucevlhhushhtvghrufhiii gvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpehpvghtvghrrdgvihhsvghnthhrrghu thesvghnthgvrhhprhhishgvuggsrdgtohhm X-ME-Proxy: Feedback-ID: i131946ab:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Fri, 23 Sep 2022 05:58:43 -0400 (EDT) Message-ID: Date: Fri, 23 Sep 2022 05:58:42 -0400 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:102.0) Gecko/20100101 Thunderbird/102.2.2 Subject: Re: archive modules Content-Language: en-US To: Nathan Bossart , Tom Lane Cc: =?UTF-8?Q?Benoit_Lobr=c3=a9au?= , Alvaro Herrera , Robert Haas , "Bossart, Nathan" , David Steele , Fujii Masao , "pgsql-hackers@postgresql.org" , Michael Paquier , Magnus Hagander , Stephen Frost References: <20220830163048.GA544233@nathanxps13> <613541.1662842656@sss.pgh.pa.us> <20220910211046.GA2651323@nathanxps13> <9ee5d180-2c32-a1ca-d3d7-63a723f68d9a@enterprisedb.com> <20220914200305.GA2984249@nathanxps13> <37857474-5caa-ccb3-92a3-150ddfe851ab@enterprisedb.com> <2884265.1663188443@sss.pgh.pa.us> <20220914211746.GA2986134@nathanxps13> <2910705.1663193529@sss.pgh.pa.us> <20220914222736.GA3042279@nathanxps13> From: Peter Eisentraut In-Reply-To: <20220914222736.GA3042279@nathanxps13> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 15.09.22 00:27, Nathan Bossart wrote: > Both archive_command and archive_library are PGC_SIGHUP, so IIUC that > wouldn't be sufficient. I attached a quick sketch that seems to provide > the desired behavior. It's nowhere near committable yet, but it > demonstrates what I'm thinking. What is the effect of issuing a warning like in this patch? Would it just not archive anything until the configuration is fixed? I'm not sure what behavior you are going for; it's a bit hard to imagine from just reading the patch.