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 1wzOwc-003zd1-1J for pgsql-hackers@arkaria.postgresql.org; Thu, 27 Aug 2026 01:30:18 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wzOwb-00GpPd-0n for pgsql-hackers@arkaria.postgresql.org; Thu, 27 Aug 2026 01:30:17 +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 1wzOwa-00GpPV-34 for pgsql-hackers@lists.postgresql.org; Thu, 27 Aug 2026 01:30:16 +0000 Received: from mail-wm1-x32b.google.com ([2a00:1450:4864:20::32b]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wzOwY-00000001T2z-2R2S for pgsql-hackers@lists.postgresql.org; Thu, 27 Aug 2026 01:30:16 +0000 Received: by mail-wm1-x32b.google.com with SMTP id 5b1f17b1804b1-4996f1ee4a4so1120985e9.2 for ; Wed, 26 Aug 2026 18:30:14 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1787794213; x=1788399013; darn=lists.postgresql.org; h=in-reply-to:content-transfer-encoding:content-disposition :content-type:mime-version:references:message-id:subject:cc:to:from :date:from:to:cc:subject:date:message-id:reply-to:content-type; bh=iYByQ89Sb53+Dg+qNp0B5exZ9QwJ8l09VS5WapYKTGE=; b=eaZN3QAAsORF3giCORTATbboD5rTwCx/M6IEDGEWOPHwTGMmyBYGLAbWF2AmIjQQzo zTU/xgqHFc73WeeGJ7QKpz7rtKT4GTpAa2nSrVloBeLrMiIwNvzTR4hbl7FMOGxp/lh7 /O1QEiwbTFwThckQaNjCPKZmXv2KHkyqgqr9aoofw9ogAW6fp+J+PfAy/OWC3cdl2VB5 TGNym9G7MU9cZ/7yR7s0AtA57JGhc8YXOBO4qNwDLOIPhtl3e9dIMvl7IjwWC+CHk1za po83mQsQLohtUohAuzJ2SezoNqNo4nAw8fC7qCJ6o8WDao/O3ztxx6MU2L+5vkbzGN8Y Em/A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1787794213; x=1788399013; h=in-reply-to:content-transfer-encoding:content-disposition :content-type:mime-version:references:message-id:subject:cc:to:from :date:x-gm-gg:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to:content-type; bh=iYByQ89Sb53+Dg+qNp0B5exZ9QwJ8l09VS5WapYKTGE=; b=fzLplyp1WgaFIXy2rMXd33R/Xrmiqqf/tLOmugyjlpT+LPnTDzdeIRqtwqK6hMq6yi 5gJvgCoK4tufOp1zd9PHiva9TibGBltNOrv2voiNcq+q8jbeZWu5TfaMp/SY4l2GhrUH BfQQBA0c1qqFVY8uW8ZpSLyv5AzoxJkT/4jdr05e+fuM/GXOs5AtH8eKcl/R6Cp5UWdE rHGvUmTqC/V04Tk9YEoqHa4l2VGPSMwHxT3juhOwJjkHNbM5nN386aa6Al73ihP4QSlq m/S8CIg7cYX7d3qYv1BT4T2N5i3d6n0zU52pN00t0784S8NRlewvJcDgPcNFj9J48510 6XyQ== X-Gm-Message-State: AFuF++lGdr5tbQGAux+MO1kJAU+k10uC4nzory5jgDI+rtFEFSCXC+DS 0CA6Xdrbb4eO+uT0kbI4zMaYyLP2FPnbIlEfnMTtFG+BRqBS9YGsNpJ9 X-Gm-Gg: AR+sD12iw3jJh/mT39bCHdLlKslEHVweKue3dpvWFLH0duDuMR46bfN5YYifbhHkbLQ wwyj8JVzuc2X46Zlb3+IEKBVFaNXgi6Mon5SnOmQKa0IDVp02XWBPM4Kh/NUr5mJouVwaPHt8OO A5O//NeTi2/wK5xatVhU81mE8TP24KVZFFDGq/7POl6De/PFxMqPy7lJHxT18XS0Ti1tKuI4c9k /B2s1czfgsTTa7qQqTOI7rCWV/275ouOLC1dYSD1UOXJCnowjmSpf2rXlZZ5f2yUTfhldo9mKgJ M/88kpIMrHNN40EVeNdUf1E/wou2L3ePzrcvjFUdIHde3tg39b1EaZPDAZCfeyRszketgBwJK0I sbm671IZjp1BYYhU77/kWW2cUYrdJXyys8TDLsN9sVq6SH5KPd6l5k3nMe9Gw/gYUGDWWAAdd0s VMHvy/5YgUw04lzx7PaOGT1pQx0Yy5zlVc4Y0CFuZQTnLHMq9eS7Nw3q0HHoXMOZI0J81oS4Oeg g/uHNpYU6geh9sBP23iZC6nKIAHTOedMTezO8FaKDPcK9ss X-Received: by 2002:a05:600c:a43:b0:497:fecd:5b00 with SMTP id 5b1f17b1804b1-499dc717e27mr99311715e9.9.1787794213034; Wed, 26 Aug 2026 18:30:13 -0700 (PDT) Received: from bdtpg (ec2-15-237-197-144.eu-west-3.compute.amazonaws.com. [15.237.197.144]) by smtp.gmail.com with ESMTPSA id 5b1f17b1804b1-49b4dfdf00csm8333485e9.14.2026.08.26.18.30.12 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 26 Aug 2026 18:30:12 -0700 (PDT) Date: Thu, 27 Aug 2026 01:30:11 +0000 From: Bertrand Drouvot To: =?utf-8?Q?Mi=C5=82osz?= Bieniek Cc: pgsql-hackers@lists.postgresql.org, Amit Kapila Subject: Re: Persist slot invalidations before publishing them Message-ID: References: MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi Miłosz, On Wed, Aug 26, 2026 at 07:24:07PM +0000, Miłosz Bieniek wrote: > Hi Bertrand > > > 3/ I think 0001 should be backpatched down to 14. 14 and 15 would probably need > > some adaptations though (I did not look in detail yet). > > > > 4/ 0002 should be backpatched down to 17, where failover slot synchronization was > > introduced. > > I did a brief review and tried to test these changes locally. Thanks for looking at it! > I ran test for PG19 and master, and they passed, but couldn't > apply patches for PG18 and lower. Yeah, the back patch versions are not done. I think it's better to discuss the issue first and agree on what the fix should be on master. Once done the back patch versions will be prepared based on the agreement. Regards, -- Bertrand Drouvot PostgreSQL Contributors Team RDS Open Source Databases Amazon Web Services: https://aws.amazon.com