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 1nSkVK-0007qT-OZ for pgsql-hackers@arkaria.postgresql.org; Fri, 11 Mar 2022 19:00:46 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nSkVJ-00068q-E9 for pgsql-hackers@arkaria.postgresql.org; Fri, 11 Mar 2022 19:00:45 +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 1nSkVI-00068g-IF for pgsql-hackers@lists.postgresql.org; Fri, 11 Mar 2022 19:00:45 +0000 Received: from anastigmatix.net ([68.171.219.55]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nSkVF-00009D-Se for pgsql-hackers@lists.postgresql.org; Fri, 11 Mar 2022 19:00:44 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=anastigmatix.net; s=default; h=Content-Transfer-Encoding:Content-Type: In-Reply-To:MIME-Version:Date:Message-ID:From:Cc:References:To:Subject:Sender :Reply-To:Content-ID:Content-Description:Resent-Date:Resent-From: Resent-Sender:Resent-To:Resent-Cc:Resent-Message-ID:List-Id:List-Help: List-Unsubscribe:List-Subscribe:List-Post:List-Owner:List-Archive; bh=n+s7iUf90bdJ2smB8xfMQh5ZLRsuy60f4lfLG/zHtwQ=; b=QrOtkQpDjLk9CeNXANBFKPmj50 qUBzpKRGrR5+j1hZWWuRQJWvFvAZIhGd1cCmJm0OQES0gMr3dXuygfAEs0z4sBZoFZ3Eb2+WSXvTA fmcNHH1rsqiMw2FbVllADpwaZTyyen82Li6E+8JDzm7RWUSN014agx80QYzz9I34bYyNxe30XNsG7 YhNtZVgS4vsbIIh4+UUZnCBYZbG7GYYyE1PynGRkffDDkk99o4hI7QtdcoRdXrMt+UQxeAtQzIT+t P455W4Zkw6MrHtexcRm0Otov/GoGi9p1SCH+qZj3LOGLu5+I/cawcGDsJu7moORUg2hhtWIqW5+3Z g4c2nF6A==; Received: from [184.19.43.81] (port=50866) by bay.acenet.us with esmtpsa (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1nSkVD-000gfB-0Q; Fri, 11 Mar 2022 14:00:39 -0500 Subject: Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file To: Nathan Bossart References: <622801BD.9020605@anastigmatix.net> <20220309154209.GU10577@tamriel.snowman.net> <6228DFE7.4080802@anastigmatix.net> <20220309171923.GV10577@tamriel.snowman.net> <622900C8.40807@anastigmatix.net> <20220309222124.GB180567@nathanxps13> <62293417.8070104@anastigmatix.net> <20220310000622.GA225595@nathanxps13> <622A941A.90909@anastigmatix.net> <20220311003834.GA597706@nathanxps13> Cc: Stephen Frost , Magnus Hagander , David Steele , pgsql-hackers@lists.postgresql.org From: Chapman Flack Message-ID: <622B9C55.9090708@anastigmatix.net> Date: Fri, 11 Mar 2022 14:00:37 -0500 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101 Thunderbird/38.7.0 MIME-Version: 1.0 In-Reply-To: <20220311003834.GA597706@nathanxps13> Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: 7bit X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - bay.acenet.us X-AntiAbuse: Original Domain - lists.postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - anastigmatix.net X-Get-Message-Sender-Via: bay.acenet.us: authenticated_id: chap@anastigmatix.net X-Authenticated-Sender: bay.acenet.us: chap@anastigmatix.net X-Source: X-Source-Args: X-Source-Dir: X-From-Rewrite: unmodified, already matched List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 03/10/22 19:38, Nathan Bossart wrote: > On Thu, Mar 10, 2022 at 07:13:14PM -0500, Chapman Flack wrote: >> +postgres=# SELECT * FROM pg_walfile_name_offset((pg_backup_stop()).lsn); > > Ah, good catch. I made this change in v7. I considered doing something v7 looks good to me. I have repeated the installcheck-world and given the changed documentation sections one last read-through, and will change the status to RfC. Regards, -Chap