Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uXgdE-00DBHT-G1 for pgsql-hackers@arkaria.postgresql.org; Fri, 04 Jul 2025 13:39:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uXgdB-000q9V-UK for pgsql-hackers@arkaria.postgresql.org; Fri, 04 Jul 2025 13:39:10 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uXgdB-000q9N-J2 for pgsql-hackers@lists.postgresql.org; Fri, 04 Jul 2025 13:39:10 +0000 Received: from bumble.maple.relay.mailchannels.net ([23.83.214.25]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uXgd9-005hif-2Z for pgsql-hackers@postgresql.org; Fri, 04 Jul 2025 13:39:09 +0000 X-Sender-Id: hostingeremail|x-authuser|david@pgbackrest.org Received: from relay.mailchannels.net (localhost [127.0.0.1]) by relay.mailchannels.net (Postfix) with ESMTP id DC0714E4928; Fri, 4 Jul 2025 13:39:03 +0000 (UTC) Received: from nl-srv-smtpout4.hostinger.io (trex-green-7.trex.outbound.svc.cluster.local [100.112.52.163]) (Authenticated sender: hostingeremail) by relay.mailchannels.net (Postfix) with ESMTPA id 236D94E4272; Fri, 4 Jul 2025 13:39:02 +0000 (UTC) ARC-Seal: i=1; s=arc-2022; d=mailchannels.net; t=1751636343; a=rsa-sha256; cv=none; b=BH79+U4HE6eA+oMg6EB4uvm0lojLdyJ8pBnd76uUVjm3gDccXb2DeGFFzC8OZAMQiGUiBV 8YOsSC+PPJsFI+4REWHIcrRxpjNZOU+aKxldxjZuhXNefB5lQ0alR6qlpUHAsHKqFw+O9l Gg3XH+YgfvZc+I2k2RjhPXJqkS7mN6qejoGHRfvWYB4VKdC3dJqKxJ2+jmlbhbJt578qNF TbJH/piaThyqDgo8uCUfQmrys+GabWb1mvGDBhvf3Y+PJuxdqmPGWqUf0PLqlfBzFD/ScZ uD42VlqMmtujgKAdph+8DJ6yFnJ198Gm0HNEaEC9+lAoWa9cxLfiRiKZaAPzxQ== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=mailchannels.net; s=arc-2022; t=1751636343; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references:dkim-signature; bh=e1sNVspmCYwwqV/WODiR6galEzgfvkIUkE++ZseCqG0=; b=dTBqv82mTay4WTWmBKvr1fwxjkOVgtxUjmHgReFJc6yjo9ahvZx4XPewHoTRUtp/KOrNIs hFrGSClYOl0OQ9KzOrPQSNArFaea2TLQVqc7WU15+wXnRU41v2yvJ7ByMuqcIR41ojfE5P dbx6DFCDjhqX+MiRycWF9yep1LCpN5R1cuuzVzbhHESw/O4NvrhR2OhB8BGATfsmRwroIf MRV4Aqx7tMY3XNSvpuygP8MNEFP8XnNtB2yar/pc7ED81G1CdStRBBwwTtrNiTHxCECJ9y 9DQZJAiSCvYrJSkcfOkHfLDauZxZpbNJJDeg33nNPpqZ+ucZvoGleTLLLKIGIA== ARC-Authentication-Results: i=1; rspamd-6597f9cdc7-c5xqx; auth=pass smtp.auth=hostingeremail smtp.mailfrom=david@pgbackrest.org X-Sender-Id: hostingeremail|x-authuser|david@pgbackrest.org X-MC-Relay: Neutral X-MailChannels-SenderId: hostingeremail|x-authuser|david@pgbackrest.org X-MailChannels-Auth-Id: hostingeremail X-Robust-Sponge: 3b3366931d0dc036_1751636343791_835341704 X-MC-Loop-Signature: 1751636343791:502904035 X-MC-Ingress-Time: 1751636343790 Received: from nl-srv-smtpout4.hostinger.io (nl-srv-smtpout4.hostinger.io [145.14.159.45]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384) by 100.112.52.163 (trex/7.1.3); Fri, 04 Jul 2025 13:39:03 +0000 Received: from [192.168.0.136] (ip98-169-79-170.dc.dc.cox.net [98.169.79.170]) (Authenticated sender: david@pgbackrest.org) by smtp.hostinger.com (smtp.hostinger.com) with ESMTPSA id 4bYZVD66NrzGFLN9; Fri, 04 Jul 2025 13:39:00 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=pgbackrest.org; s=hostingermail1; t=1751636341; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references; bh=e1sNVspmCYwwqV/WODiR6galEzgfvkIUkE++ZseCqG0=; b=KkP6WLue14V1sJzjY/1FoRqTDMiNfngF18zY2xurHjhjYW6rAejGCKGUCWHXwQb4RbPchA RN4382t5kVG/kyZdvW26o1eL0Daeisuy84aI+ZiZyti4zZrXqy5SsNShg3Q/nSU7sYIojx ptQSKJ1myLH6zOX4SS7qGel9Pad2LuHGM+cyls07zWqD1HOcpBlusLkx3BK/YNtRDnif1D E2T+ymYlDooniF05gHE1RgTdooy8vsVPqbV3rLe8D5S/Zm7G+ycOBQfnZtjiODK+Ae4qwF +91YvUSeLg7jRUeWTj+QqHTxZWVzqjWuvmd03LfBxFkpLIL99ZBAyAnvNzJvuw== Message-ID: MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Improve verification of recovery_target_timeline GUC. To: Michael Paquier Cc: Pg Hackers References: <08cf439a-4566-4698-b60f-d8e9ed348456@pgbackrest.org> Content-Language: en-US From: David Steele In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Date: Fri, 04 Jul 2025 13:39:00 +0000 (UTC) X-CM-Analysis: v=2.4 cv=OrcdyD/t c=1 sm=1 tr=0 ts=6867d975 a=YWrjpVSXF8u/wZwSiUedIA==:117 a=YWrjpVSXF8u/wZwSiUedIA==:17 a=IkcTkHD0fZMA:10 a=OD_Bih8J48dja3ln-_oA:9 a=QEXdDO2ut3YA:10 X-CM-Envelope: MS4xfFDoTCZUMUyrzdMdEb58oiK9LQkjb83emyrowv9f3Sajt87lrCnHV+yy8pMmwDYTzCI7wF3UJIxASfCTm6NptIgG7U1kphwGA3tSWbP83gYt27+SGgvj Mc/PgxkLGDFMQDitusniXzu0DzS8tE016WA89bXcNpZRO3GhTXevAR6Y7bK7DuIU4fjzxLQESlThb7jGxyVFbrWnI48fO36VZ3sAKMpQzxxdioDwdJEKG8sk X-AuthUser: david@pgbackrest.org List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 7/2/25 22:24, Michael Paquier wrote: > On Fri, Apr 25, 2025 at 01:50:16PM +0000, David Steele wrote: >> That was my expectation. I just had some time to get this patch updated so >> took the opportunity. > > And well, now is the time to get this patch done. So, applied after > an extra lookup, with a switch from UINT_MAX to PG_UINT32_MAX in the > code. Excellent, thank you! I'm also planning a similar improvement for check_recovery_target_xid as we discussed up thread. Regards, -David