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 1wggvz-006KwV-14 for pgsql-admin@arkaria.postgresql.org; Mon, 06 Jul 2026 10:52:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wggvw-00GuuX-2a for pgsql-admin@arkaria.postgresql.org; Mon, 06 Jul 2026 10:52:16 +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 1wggvw-00GuuO-1J for pgsql-admin@lists.postgresql.org; Mon, 06 Jul 2026 10:52:16 +0000 Received: from mout.gmx.net ([212.227.17.21]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wggvu-000000022aA-12QI for pgsql-admin@lists.postgresql.org; Mon, 06 Jul 2026 10:52:16 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.net; s=s31663417; t=1783335131; x=1783939931; i=mbanck@gmx.net; bh=b2dVhR3cEo4zhJnMw1Ml31fm65AWkVt8o+dM8unXKDY=; h=X-UI-Sender-Class:Date:From:To:Cc:Subject:Message-ID:References: MIME-Version:Content-Type:In-Reply-To:cc: content-transfer-encoding:content-type:date:from:message-id: mime-version:reply-to:subject:to; b=rGoAo03dakTn3/Ienh98hw46L4irRGGEO6pp2Xa6PHyR8MRM+iMeWpVYouDWyj8k JsmfSU4Dun7A6dqeQsK9hGDButaXgvDAzXwAx4bZ577sbuJRtc0IF1uWWvChvEf3b TBGkktAMP8pbA+4qQ4m+O39+VQdWupK+7sF/F3uAkurOiazN2XmrLygpBHeAgp3Ls 3owQxEsYTcsMYP0LJlvrhahwqkFSVdVM/2GyRIr1vkVtzjuFi9sQ2QLrXgpVDOR/b q472vsEC0erd3YBNDGQSiilFkG5itwIf17gLUihvsbejd4fEZ4KMQNTR6g6WoZnl1 voww3Xnuzl2eUzBp1Q== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from client.hidden.invalid by mail.gmx.net (mrgmx105 [212.227.17.168]) with ESMTPSA (Nemesis) id 1MXp9Y-1wbJ8J0P8e-00We5Y; Mon, 06 Jul 2026 12:52:11 +0200 Received: from mbanck by lightning.p46.dedyn.io with local (Exim 4.92) (envelope-from ) id 1wggvq-0002Oe-Dj; Mon, 06 Jul 2026 12:52:10 +0200 Date: Mon, 6 Jul 2026 12:52:10 +0200 From: Michael Banck To: Klaus Darilion Cc: Mahesh Sathe , Raj , Pgsql-admin Subject: Re: Major upgrade in patroni cluster Message-ID: <20260706105210.GA6368@p46.dedyn.io;lightning.p46.dedyn.io> References: MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.10.1 (2018-07-13) X-Provags-ID: V03:K1:0lTyOLrQcz85DYMUSIe6WZiTXLSHsGkrPP6JZHnzsGIGiqthsMn TkUQKjJwUBWP1riLviMY2h8fwlLNYWM7MFdTpkXfzSU1rzGSEX4vOsdFiRsLIJKI/brH9LT 2LdJn+H3RyxwO1nwB48tRU4OvVfaegy7TbSiKkl9AKsYnV9Oc7WBTdcqCMA80vMecf/+I9l BpooCq95Ev/ZQEETqqpJQ== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:E1lqIH452s8=;Bl5hp0T/XjRSlV0qWsleIUhjhgg EktDVfYvLturtUA6+QXo0mtFh6YvQ44gP0oPDLuP3M2nYfzWZQ7LmHqBL1KmVstoXU98HKEJm Ct0Bu9G9qHTtOuN+7e6N+ep3l+z+1YSEF+j6byTeiUnGmxAoHjD6xFtHXnx/0n8xWAmP6JOxx OV71ro8To7eLXL7t/6/oyPfAlfCmFPXHW6eFCLgFv0YxHgft8wA3EnKQxTW6rW9MDtghsMDb7 ZWKUXusCaDmPbh8CyNQqjuDMvlxDt+OouQgjkShLC163OiykJLpxgG2XNYRPqp4YwBDi5Ccga LknNNGIxzEpz5N/qamXFXYmTnjWVVdWMfLdAsD25K+N/1KU/eT6kuqfhAXaFv3hoPyGJqhqLO 2MHf1kvJjRaL5XxDmozSmPW45ycKdh6dn/WL9PJQoFY5ew15zoVb/1Ge/Svfqon0gr6QAkr6N eMqnO2H0NbWPdNbWQQ+HZRSbzdnhHZdrIP0G78zFBgX3MiXEqz5e8bo4N5Mn7XVl2Rd1EHI/A HSSYv7PhGYmpAJrr0oyfHZMHN1AKo8tOYOrfdw41039frjALiEMGus8WAeTDEdCCMIRqluux8 dUIJELKn4/M7nXz0wksJlUYPqBjubBLOJB/w5Eto1ztOhkV+lQoDklBtI4J1N/HfNb/Ix4Wul hGwz2w5sBWvKnFpFrJKG21/JdQGO5Ksjs16S5CgrgU3mIFZIhLd7v7JpW+K+9QiKebXL0Lw/w +QsZffBlcMMPLRihPQ1b6jjoNfmfw9gj0HJX2TykXrWF0ptmOCACy8z0EhNYrsOHoLdWkiX6K qZJXYTUwMmCVvpg6Rf9uU9BzyUq2THj1ePX8MCmVfZvgib4izbCWUAZJIvUTGyJAHiEvNfrCz cajWh8IXT/hYBLB1zV2opeVA1PQI7Cb53clZzHBVM4GoKFsK/cXlDBJxI9qldeqeqIrHEG4e5 EjDAnCKs/14+OXUFtSIpewCG09Ot6C8mAVqTrHaNTna/2lvn3Ori7m9qafaB/09d3ckJrtEa8 BGBpKJul+Mjm13mzAhEJZzTvSJinuazUKBfDSjz1H/uXjzEikYVjefKrRt8fQWhiiyye86zbR uSmBOw7WEP/hMnPcnUcuhWOzgBM0RvA7qHKn6ML+VnmT8Y/zplaMpINefV064oEEaWMqVXhOo 22sRSrZalNL+O57ymn+AhgC4z9pVzGOE7PGu0rxKQ4UbbYOAhTbFatjts62Fsm02EKCn3VO2b BIP1s+N1kzeKCSo8U3MNNSQON88iuQcV6nf9XFLeydLy+E47Wx6HY+A3HSoXDsU/Cz5WauxlR alHKh1lV6VDzgK8QCNPJ7VEiHJAf6m8fAwu9OxxXt0KB4scbz3x0eNrmB52wAGG7f3F3950SJ fXLTktJVrsPG/g7GdNTdKmBPnLsgf3eYOJ49DhF27EaSidf8zvE0hJEJM+aFRWMYzVfyH5QNM 64V91/65NxrnrcmIsOar33NdE/psllFiFj0oEEFt68kSdqaQ1z/Ll4aRXS+5FKBj5uniJdvT7 lFf/a/jU1zxEhWgbASG0t/xg5vSw2N6bZWyqdmBCkhBkylLDSkQ6zeJsxH3oY+QfwKvN6Jz+9 xtin97Ce3piYis/HXA4lROHjxrUTVSfZFj/REU2GDm5xva5hdDcs5903QgS11WRYmAcbBI8fE /vA7GelT8S3kJBO4coND9FcJtoiHBunTzjmhwOqv0sTlQ2e1vgYYCg0Bhwhnkr/+sPoVRBzlE uVbIM2HDlfFNpZ+cQB0qcO4acn3gNe6u+XhWpWlzSg9X239NOE3NMkHQfdhIygU3O+xwlx27X 7AouUhh2htOhlnhvHfgncxf1gBVZB7dcuSgA07E176zns9OauO1LjnAFqlfMbnYtWyd06ncuJ TZw2vAhQ5goNChKeEz68eyPnbmzEAggvn1IuLPyPh5gIViE+4mvJ7eLYwpJmiwu6rYv5wRuDK aSa8hbf3Vbi8oUOmpzdh97BDn7NWHKMuZ4FVkJ/KB+5NIODhP60fHjV6RCa7dSF7z1ZxCN47O XC5ITqdlzjQYAtu6y9AWsJzPMTCSqrGwpX+SuDcOMzY3lUljF+Pw7LGVNgxCHI9A4Godhgzet S7+/27wj9psHqn4IIh8dMGyc56CgDvd7QwkKC328GVyCkUzOtnTLpdy217T0BgFRf/+CQ+RAJ C+V8yetUN9AofyIemKw24Tlom3LVTYYPpnNHamNSsPpNIl/yf4BQ4VDYuFqwFs0wXsJoMV+ML 1jsL2zbRi6cESw4UBQo4ntQXbVn4zQtqQ/qtQMurh9GNpBHAiZuxrLA/HKliB1qzaft+NGZkD ZDx9tyuB98G+LydDK0rP9sCKOMDKkAz2dX8+o46cKwmWjkHBzXhswd5Zg1QiTlAXqJvR0dO8t uA3081lMGnEoOvcb8vXGcDwIP80A40j0MSjeJGwtcwpd0XPbpziakYA8fhqmi0XYPElnxeDkG bZ8g7HWXDSZM78D3SjGYFZ34Fq8sHG0sZvnVVtmke0jJ7ObazuzKwB7NJkyOo9taAZ7cyHEPH tkij8QNaHOIglAAUKWxZQxxaViNOZ8+QSm79yxYc7uWrYjUNs5OiIHUg0ctjoFSD1MPY+kSUk oD0CgC6xdRPVqDgfIHcxHa0oir04ArSW5hTXUf7q7f1ZIRhJ1olWPR33YHBegpSNrzapeIBsS X37bD7AIO99JaF6jCMnDpr6ddPepBTP9iJKumeiVTQacNVr03sSdZm43eC9r4dGUWFurm4CMX +Awn1Xw/bRs5N1vGlO1ua7opSycwb4uwkuApb19sVhdPSvI6LJc0RgG0h1BAo3TiLasQUgxaJ +2hT8TY/q6iuVPj/ZSt/sKjSuXheplImbBBwaEHhU1P1K7KU0sLa+YVF6JRwbInOL4MrK07Bi a4kS5mk2I9iEy05Z3rIc413W4Ty/HHOInk9ghckCviNjoGgCL1KdKV6MMrM4YferuDxVEGoXB DFYmVzpurmwunPA8+eJKKWcZjDKx+AmTbhufTUhdkbkG3B7mR+GW/XyVOThQ4oWTmYvZld8I3 W5TtKihQVzNwGwLrH1gO8PR7+J94bd/BKlfw6G5ILG9aA+bVef1ZZ6oXmKzpPDzz0adQUoBj8 /lf3FAnPnzFJROqoIbYsSjgXJD3bEtWnDmU9WIJ0U9wJOuHaCBtiplLYX1DYrpgFm9o9DwEWP GdznFeJ9MFRlyzEucDkDG4voatkfxFZnTuhsQ9ERLY1Bfeg4ZBBIiiB9qTGDTCGUdL/zWzUdu EKej4gZgUBmIHcVN6EY2gnybNgdklaZNGpBm3TVBhlgqzDlUbOXfgrEkBjv7qnGwPgnKcoNYz 2/GHP9RZX3e75u3kKn+iH98OrA0mqzjDUqRh+2P2Sc3WTzgNDQqHayepynrkD6i+nQ6zu83SW vqdo5AXDrTdnh57SVDzB2skc8ltq9OHDnY+Op3oobtUAANNeQoHzOMIBchD/FbOl/9PyY93Sx aNCOmQ9PIgICMde1NAhpcj1Q4gUfwPvf0JPfoszCzPlSZE/jOgISSjhHrId2AS5T47S6WDIUl Iwt1ZZKATZJMetHitpjwsTXIZ3ztSWK7Ql1bXo1exFE9LEaEo0vYHhJjh6806gTaoSSw4C1jf /jVaKXrjnQtDZWh3jMnyf0UMB3VwV5dCYmjW0trMQLxVe9m1LOi+yy/azvZqz2DZ+BREoMQf8 ztdlut5kb3dJdUxBo8jtsSdwtyElSaNPMFxTJ6mwU4DOnxFdqKqZW68AN5DozEmbtXNVBORth YUPj3otP4b/cQ8SNgIQVI5uGIIDdOcBhWqz+7vd2Byodmuodn3o55wR99Zqc0ugwcVJMC7jw7 Zg/KSSQtOt6xmUEfY4FZ4mbDkFJhjVlxiR06PvAlJ+OsYP3Ai80cmFuLt8+uqsDEi1S0qj7uZ M0Xvpz+ojSFrpxHvM65S9nQvy1+9QwShn+riSiIRWK/PbtjcS4+Z/UK2yk91fhNtH6ZZaqFSs pEJ9p4ru8a0h0dGTanKsW7rBfBgSQgWB1hSNX0cLkG9LxE+lozZ+YbtU58cI8qolUHswJjrOR B5RjtI8o4eu4J7InZZAmUahV+qz63KzlvuOopvkyNoTskQOYI93SbsCvwmMYSWUbB/RewZdKi miNn3sgklW7wyWQRkRXIG136KoGerkybHzjS4T8/6zUjSgxmo1/CIdzv0+FpQrBxiiU+g8PV4 wJNrveGKqYqkTBBqjJDw5lKTemg4N1hMpq2hf6E7wdBUc/+OcBVtLtveWFe/CnEz09/ZzKmxa eaHQ2iMbrn/sF+7Ys57UptIq16+/qwLc0ZdgtqEqTMrXrs+OlJ1+uvvPQmmBGtaDDsnWFkXEF kOJZ8zPcfXf4DTetIQlxzr3TnpxWQWM6uYJ740PQacTunoT3O7yU91jeXr362DMAtevKrFkm5 9/YzLy4ym/R7Kc6IaVO3yMsUkECY3nj2mUjErS89weHqibMCPuY2EVRXCzARY6K5J1ijVaJ8L Ao2taMPTsXji+MTteVxZgbExghnBhPfBS6QPruy33sZ7pWdjhiVXBGitYgz07kkZ1u/yo+PMP tAv+wSza/Wi1r3HL53XhKcSDWguZCVynhwuDRusvVGdOzhENcZlgiwl94oilGRF5+lf4t0SaK 0hrV8gIieKM9mZ8Eo6ViwsItZfEwzy8FzEqcIjE77Wb5p9gLZPR/MrG/ZTZElLX+J5ZMsbyJG qOpbw2+N/urRs3Y9mluFubaP1dFr7xFeZ5zxIY/uiF060TVlwEMplYURAQ6n+6ESSmtXHdqZl ogfNLCkT6atitmvEeIf2hVAVcGEUYayWhoOqmUKAsi8JPFq68u2vy3MUKEyWqfOLkqfGGPF5b lfussH/GPhCAQ9avCs4Z0/i9FrpLcepdXXFla7XzATs5OKS80cZ71z5xYBvf2RBGiKaKWWV7Y LNldQET2FTttgg727LwyTXuCNSKVgchLAKImEgrWLPJZyhkJBeVipFcodYRdsD2UF+FyxETPe gWiog3MJaPTK5DRLsjmpZV9Bzggi0RFKCtYd2kTVeDZm+XPrHd1NCv287tDbis1ufmKSlCt37 GvzgvYxKJjKWG+wfN7kZkMnFMRck4Am9FceswHrrStePVrJ0GaN5lXj85cYIt1nJbogTJduh2 vNf7WPccNwhc/wQFAbPu4hEZKxUcIElYURhfhzWeR0SRtqhxImo2vhzd8/FssRA0oc4YtQfFh ccLdFQn/xOHNoESfuil5R64vU6J/06MlG78s4+2S3seU0123P9Tzq0OqSPFlgUlPa0WbuatCl 5UwohDY38K5p6zwvBijcU4TPOwDyqjdfRyj51U2pNF0DjWcxeGksLmj5UCOQpsH7zCQUYl+uZ UTpDufMbItbHlBR2bfyZDV/Apl1McM7FCDzA2IuTYhfTXJ086+mYEQh96OQznr2xnaohcQmmL Eaaf9s1EqadAu6YZVpMPWlccVshr7U0fPIYWQQhFqHHa8G1ZtxXxE0Pp8gZeDcHRiRpoDZV/D f4IX/Il1rruc6sC6mY63UJX+gzFjbSsMJga8= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, Jul 06, 2026 at 10:43:52AM +0000, Klaus Darilion wrote: > Do I understand it right, that during the rolling upgrade you loose > High Availability as for short time the Patroni nodes use a different > Postgres version and hence the streaming replication will not work? That is correct, and short of using logical replication for zero-downtime upgrade into a separate, new, Patroni cluster, I don't see how to circumvent this. One can make the upgrade window smaller by upgrading the standbys with rsync, but that is quite brittle and should only be done in controlled environments after lots of testing. Also, it only works with the --link pg_upgrade option, not --copy or --clone. Michael