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 1n5dwg-0006KK-Ry for pgsql-hackers@arkaria.postgresql.org; Fri, 07 Jan 2022 01:21:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1n5dwf-0002Ta-65 for pgsql-hackers@arkaria.postgresql.org; Fri, 07 Jan 2022 01:21:29 +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 1n5dwe-0002TR-T3 for pgsql-hackers@lists.postgresql.org; Fri, 07 Jan 2022 01:21:28 +0000 Received: from wout4-smtp.messagingengine.com ([64.147.123.20]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1n5dwV-0000RU-G1 for pgsql-hackers@postgresql.org; Fri, 07 Jan 2022 01:21:27 +0000 Received: from compute5.internal (compute5.nyi.internal [10.202.2.45]) by mailout.west.internal (Postfix) with ESMTP id 36E683202B6D; Thu, 6 Jan 2022 20:21:17 -0500 (EST) Received: from imap49 ([10.202.2.99]) by compute5.internal (MEProxy); Thu, 06 Jan 2022 20:21:18 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=eulerto.com; h= mime-version:message-id:in-reply-to:references:date:from:to:cc :subject:content-type; s=fm3; bh=04x4+iA1d8LDBerjn5m8c6v5IptXkDx QsYo+/UPoosI=; b=M+4Bggf3JlpVd2cBKp9H98fUPy9wbGfSJWzODcLhFutELH2 MTIIuxZ100i8A1XX57N+zbd4kI7WqG9g7/nR4GpkNvkcp7wW7C/VGwnDj3QQC5i5 p6ikC+Ysioz8CxIWe8py3dkPPtghGaONVixtgLBR80Lr582PisNHPrWYy105OiOp g/NO98jFOZHdLjJ07Xr5lOFYE9YeE6ka13vL/xqHQ+DVSH6EI70qbhc4TKJ9jbqb r06iP3QCHeHEDlSRoYag1J75Q+qq1XfqDON35AZlzwZHLigT9HfpcAeqf9iHMYT9 MbXE9CMAEenbZCyWZMyBr9sKmwkwTcf576g4HAQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm1; bh=04x4+i A1d8LDBerjn5m8c6v5IptXkDxQsYo+/UPoosI=; b=WxsBymko2qu3EMN7D5F8S+ RqmUM979HdD/vHQO8JkgA7zYcCD15GIGo46n4OvPZaV8XqBDiw37rKXtqct0kUf3 pqG7B0fwG3VfqW9w+Lrj5RsLvFsTIgvWryAeIsEc/XpBvp/lcbSOucwxkUznLGa7 rJii1tW+RdScjC21ZYrcH9Q89D7obO/6Bo/sOwM/q0zMYBFvwRXOYKuWBwjS/UQy f9oeojiKWTlFaj/4ygqG5C0L9lJk3QzpYVe/URlJ9usncpsSq63vHB+977W97orn m9wkjBJAtFAYA9BcP5QuM9fMQvP3ai9Uz3ba0leM4hiO4PlpAWWqVMXNb6fIYuWw == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvuddrudegtddgvdelucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepofgfggfkjghffffhvffutgesrgdtreerreertdenucfhrhhomhepfdfguhhl vghrucfvrghvvghirhgrfdcuoegvuhhlvghrsegvuhhlvghrthhordgtohhmqeenucggtf frrghtthgvrhhnpeejtefhuedvgffftdetvedufedtjeeuffekleevkefhveekgeelfefh jeehtdejgeenucffohhmrghinhepvghnthgvrhhprhhishgvuggsrdgtohhmnecuvehluh hsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomhepvghulhgvrhesvghu lhgvrhhtohdrtghomh X-ME-Proxy: Received: by mailuser.nyi.internal (Postfix, from userid 501) id DA64DF60080; Thu, 6 Jan 2022 20:21:15 -0500 (EST) X-Mailer: MessagingEngine.com Webmail Interface User-Agent: Cyrus-JMAP/3.5.0-alpha0-4526-gbc24f4957e-fm-20220105.001-gbc24f495 Mime-Version: 1.0 Message-Id: <816909aa-8772-4cfb-897f-6c75b9ce618c@www.fastmail.com> In-Reply-To: References: <417711.1637940660@sss.pgh.pa.us> <20211130142042.GR26257@tamriel.snowman.net> <3404870c1a921bafbcd168c098088981fe082ab1.camel@cybertec.at> <845544A4-0B0E-41D2-903C-C8B9E8A18812@amazon.com> <1661037.1638311167@sss.pgh.pa.us> <1cce9981-2c48-981a-a936-812830dfb3b1@pgmasters.net> <9427c6b3-5e0b-e27f-a2e7-ec1ebc00b582@pgmasters.net> <4a363c5a-473f-9cb9-9f59-74a230575340@dunslane.net> <553d2348-1015-3546-2be8-b5a8a745dfa8@pgmasters.net> Date: Thu, 06 Jan 2022 22:20:55 -0300 From: "Euler Taveira" To: "Bossart, Nathan" , "David Steele" , "Andrew Dunstan" , "Tom Lane" Cc: "Stephen Frost" , "Laurenz Albe" , "Michael Paquier" , pgsql-hackers , "SATYANARAYANA NARLAPURAM" Subject: Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file Content-Type: multipart/alternative; boundary=03f26561f3ce4896a8ca0901135530de List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --03f26561f3ce4896a8ca0901135530de Content-Type: text/plain On Thu, Jan 6, 2022, at 9:48 PM, Bossart, Nathan wrote: > After a quick glance, I didn't see an easy way to hold a session open > while the test does other things. If there isn't one, modifying > backup_fs_hot() to work with non-exclusive mode might be more trouble > than it is worth. You can use IPC::Run to start psql in background. See examples in src/test/recovery. -- Euler Taveira EDB https://www.enterprisedb.com/ --03f26561f3ce4896a8ca0901135530de Content-Type: text/html
On Thu, Jan 6, 2022, at 9:48 PM, Bossart, Nathan wrote:
After a quick glance, I didn't see an easy way to hold a session open
while the test does other things.  If there isn't one, modifying
backup_fs_hot() to work with non-exclusive mode might be more trouble
than it is worth.
You can use IPC::Run to start psql in background. See examples in
src/test/recovery.


--
Euler Taveira

--03f26561f3ce4896a8ca0901135530de--