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.96) (envelope-from ) id 1vy82H-00HSZT-2w for pgsql-hackers@arkaria.postgresql.org; Thu, 05 Mar 2026 12:42:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vy82G-00H9Gj-0q for pgsql-hackers@arkaria.postgresql.org; Thu, 05 Mar 2026 12:42:36 +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.96) (envelope-from ) id 1vy82F-00H9Ga-36 for pgsql-hackers@lists.postgresql.org; Thu, 05 Mar 2026 12:42:36 +0000 Received: from mail-oi1-x235.google.com ([2607:f8b0:4864:20::235]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vy82E-00000000w3k-11ju for pgsql-hackers@postgresql.org; Thu, 05 Mar 2026 12:42:36 +0000 Received: by mail-oi1-x235.google.com with SMTP id 5614622812f47-4648447e29bso3205625b6e.0 for ; Thu, 05 Mar 2026 04:42:33 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1772714552; cv=none; d=google.com; s=arc-20240605; b=SzThqsng+xEVLendz/okNnVCjZ1p2sxbaKcD7kuh257QJJ8YVzzYd5qQI8QBBkVrL+ dxF4u/yVDG2T0yigTjBjLBzQp2UAQuBkWBIVR+AJA3L5AIjKQkhRJiwPtBV6/jnFkcIK ojprCdGGWwougBS/CzamRIX2+VTv04Rjdupe4Y2eFDokz4aBIZdlJEcx/4Em3pv5Uoxg Lcv+ne5apDfJi1kRqV0FYPZE8jIqrB9KMk0O4dnR1CNK/G5tdk5QRsRb8TPaDSPRheFI T8G3WTqC6tczVFRyC6QY59DLIJ8+zXFsC/p3kzDfNOAA4FfeSI1HXhb5GHG1ae5rWX9r RybA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=zEyAuHOtoOqFvVCvZ/6D5vYJizu1VD+yv6mLyGS/ZR4=; fh=l+OaNKSK0Ce69SK2AYIgK4UW2sBWfiknkDR8GYTnUR8=; b=N5rtPJdXJHCDroIBWxmGVtmcuwXVVl11oUkK61CWXEgYUbeui706chp+DWHe+ZninH D5kDIjmdfm1A8RiHpY5HQZ+xr7qoauHw+Te6brco/dSksv0Ic4XC+NT7HesDgCh441Qt PbTqa1z11vMZRj5Q1K4CsR+4v/lGEzcaP1czAyuna9i9lhqaIZjJg0oRP5MPiy4lZGuK mmv6qy5hFK3xVUeW+X8Ae7lQEI/fua9EuDzo4K+vIAHfIS3iRshTC7oydFav0RZqi5m5 9NopkIMBbdCUUZ17G/0YynprG4b2ZGfmGmw6rO2WRI9Rpwg4YTcYNGLLQsfAm/gvAogK 418Q==; darn=postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1772714552; x=1773319352; darn=postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=zEyAuHOtoOqFvVCvZ/6D5vYJizu1VD+yv6mLyGS/ZR4=; b=K3v+Sdp9BLFe1kN5wgSiLNZLekQieAiClRVVzK30j5GumBctageF6mcsZiSMdnCaAk OCZn2C6p/YKdkHkuC6HjOni8I2JOhXUtfFYuoTgYNwyt7lP2DSwB0rjWEQLchL9bwbqg qS3rB7iZMqgO4x3VX655Fb8noplssAWDCW5xvzTDg633TLOgzgbBBY+dG5mfGfYQNqkL NNDZH9TGMg+AmaimPNgVekWJ1F70hd9PyrPc+V//dY+hUd6W7FUyABn9LtH6yE5UeNRf l0AHXuG+kVxixxNb48id0LkDnb0f+zMVosn6dZUq1vv6ZQsHVBtxZx7Npwz0VAXkto77 r+NQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1772714552; x=1773319352; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-gg:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=zEyAuHOtoOqFvVCvZ/6D5vYJizu1VD+yv6mLyGS/ZR4=; b=E5UyEVT2/Qzcsk6kRQRmLwT0j2IVl5pn5GnIr+L9NkCV8BXZnZ5C/rLckJAUNBCXnQ GDzMYugLazvhLSidwPlYq3OrOF5tBtuTSKSRwlZJiE/7BFejDDvaE+jOeGHO3QntlOQy z3swQ9xwuVXP+z35o1OVWVn/hPdxXYhtqZu0J2MblrrRnwX0B5GpcYwDincvneDZ1plI /3jE1A3HU6PVb5AdLeYcX6o9kHIgCISo9j1XA6TKBxIwXUWzsW1hh8RpCU1f71WCOmCt s6UiSAk9cm3uSBeepzX/1kLfmySJfAwzrh/Xb8LS+BL/F/pDfQ1t6BLOt2G+Gudbo3Oo TJzg== X-Forwarded-Encrypted: i=1; AJvYcCXNEJ45RCRGqN8bcWwhL0N2TV7fNPyDCTp33myBIw2OxNlv8c1C1fIAjrm5cM0lEhx4Ez/yETcD0SRH3C4E@postgresql.org X-Gm-Message-State: AOJu0YzyvZUCfoFqjn1T/HL2jBBb7IMDVgmRtFGyhPs7T6g2fgq0ZzDc mo+5cr0Stfbscl3J7S3frOqFVKPIbh10/jFeIb7UXjYc9o1ud8WCXMOtuIQiUSdsE8QqsTNKlks 5xdZ0En5840iQuCcowVBJiSRi4bjfXVqMomuDqHc= X-Gm-Gg: ATEYQzwuBBJquq47GhR/skaoxId5y0uqnrQsb5PYqIxwzoRYtI6L5DHpCia09uimDC2 amY2nKuyhRJcFpJWOxX/AI7QfdMmYkD4CeO/76oLnpwZ8ADPzOSbfrsxGJ6mfIAdaYmkwPpo+1H Um7XqQxaLahYDYI+YavSVm0NQzFrdFeKeagEQJQ7Efe5uYKcANCBipMRxw5IMUyu1vzobYr5kNr lX0aHEtkT3xvnpChtd2gw4apu1+5MtFKDvDxyMsi3eGoCgEQ+Yx9Pbc5MwqSlm51Pr8Ba/Toyh4 RyHbLdWq1jEpaAprBOxQ/WlK8RO1ocXOBoaEFTuLRg== X-Received: by 2002:a05:6820:488d:b0:672:9d81:a765 with SMTP id 006d021491bc7-67b1e8fc2e3mr2553606eaf.65.1772714551912; Thu, 05 Mar 2026 04:42:31 -0800 (PST) MIME-Version: 1.0 References: <9e8b7ee9-4a16-477a-baa5-0cdf37a04798@pgbackrest.org> In-Reply-To: From: Fujii Masao Date: Thu, 5 Mar 2026 21:42:19 +0900 X-Gm-Features: AaiRm53PI9-ihgJ0FFOgIV0AExDQ8gRjOQmhAJxUeHAqvWFI87i9Lru-RSZdBSs Message-ID: Subject: Re: Improve checks for GUC recovery_target_xid To: David Steele Cc: Michael Paquier , =?UTF-8?Q?H=C3=BCseyin_Demir?= , Pg Hackers Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, Mar 5, 2026 at 5:15=E2=80=AFPM David Steele = wrote: > > On 3/5/26 12:03, Fujii Masao wrote: > > On Thu, Mar 5, 2026 at 1:21=E2=80=AFPM David Steele wrote: > >> The prior standby is not running because of the invalid config. I > >> figured it was better to start clean but when I update the > >> recovery_target_timeline tests I was planning to use the same standby > >> for all the new tests. > > > > Alternatively, we can use $node_primary, since ALTER SYSTEM SET with > > invalid recovery_target_timeline or recovery_target_xid does not > > affect the primary. > > Well, as it turns out I was using the primary after all because I copied > your example and forgot to update the host. Seems weird to set these > GUCs on the primary but as long as we get the expected errors I don't > suppose it matters. Thanks for updating the patch! I've pushed the patch. Regards, --=20 Fujii Masao