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 1wggzw-006KyZ-36 for pgsql-admin@arkaria.postgresql.org; Mon, 06 Jul 2026 10:56:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wggzv-00GyP0-1u for pgsql-admin@arkaria.postgresql.org; Mon, 06 Jul 2026 10:56:23 +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 1wggzv-00GyOs-0g for pgsql-admin@lists.postgresql.org; Mon, 06 Jul 2026 10:56:23 +0000 Received: from mout.gmx.net ([212.227.17.22]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wggzs-000000022dG-3grM for pgsql-admin@lists.postgresql.org; Mon, 06 Jul 2026 10:56:22 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.net; s=s31663417; t=1783335380; x=1783940180; i=mbanck@gmx.net; bh=YlIxLzdzmhCOuU62XnGTsKfgLc3/QzCiLLNh7s5VunI=; h=X-UI-Sender-Class:Date:From:To:Cc:Subject:Message-ID:References: MIME-Version:Content-Type:Content-Transfer-Encoding:In-Reply-To: cc:content-transfer-encoding:content-type:date:from:message-id: mime-version:reply-to:subject:to; b=cbdGgUP6vPyp97VRKNZkm+1xEODHmRkMXDtHZOa4e2RqTrN+gsGKlBOa/2FJtnTD Gq3PxrxcUUr4rVUwO1sjlXenHvKPhyac1ImwP7EF7/Qe0T69KLCQ1Yms4WhCI4W7o pCVbwd3/yPtA9fB97BzfeDXewyterDfBMwN+bKacJ9oSbN5/Fvi8MGgzKlGuzKyn4 PVxLWHTn206sqGvQaF/Lc5LLhOmwiGAQHUy4eNxXt9jVeky1l1rDszCeLKMTYYoBg 5H8ST4ujeLgKMN7mSz7Vy0eNkjbDamv8o2v7W0KTGJzprJhUeh2KUKAvZqumJiqy3 DJa8X2kVeYTMPHVJBQ== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from client.hidden.invalid by mail.gmx.net (mrgmx104 [212.227.17.168]) with ESMTPSA (Nemesis) id 1MwfWU-1wzslt3sPC-00v00L; Mon, 06 Jul 2026 12:56:19 +0200 Received: from mbanck by lightning.p46.dedyn.io with local (Exim 4.92) (envelope-from ) id 1wggzr-0002Qu-Fr; Mon, 06 Jul 2026 12:56:19 +0200 Date: Mon, 6 Jul 2026 12:56:19 +0200 From: Michael Banck To: Mahesh Sathe Cc: Raj , Pgsql-admin Subject: Re: Major upgrade in patroni cluster Message-ID: <20260706105619.GB6368@p46.dedyn.io;lightning.p46.dedyn.io> References: MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable In-Reply-To: User-Agent: Mutt/1.10.1 (2018-07-13) X-Provags-ID: V03:K1:b2upulEuN1lDDNxKM5GWDRx/VdwaQxdq6sE5/9Xu89KT6qM5Ier lw7SCGoUSK+7rEsGiC5B6+UeYetyAqnvmKUC3HnlL9KljboXFjCP5IEfIAbLuZB5b3NBD4U K1ecjItqSLqjj0gEVTlvLBj7xcOtpqiGFSAIBA4/k2qIAnpDSrFQxPR8TGC6+gVgtshafuT yOIGdRgb4br8hzB8FXseA== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:RjP7ZeKhOSw=;mHj2Arg+nkFGqLPBDZjXR+7pyTR LI8nETLTeub/b9g8vthfJKer4Dj0+eFRktFMHfiEHyhWchgYcXBO/HheZ/oo5Pz67XXmuurgr DfXCirVCeRpdUUd+s2lyWg2nC8ghd6nra/R3F84ntKEb97m2IA+zc8t6p2cTKCTsUCUTOURSw WiJvMOQFxSp3OxmPgX1adI84rGRTXHgTtxB1cLp0rtbr0awY5tuiNXDk1JkrdENfBBBGfgZpX jBxJSrzoQBCoSN1CgUJY7rv9Lgom2KFQ5IphRnL+a42KAcXf5GKoRfvoYxlQnTn9H6Hnf9Vah VWZpB4ekJu+lQOY9OLxAdUKFH0vFXy3SL7YEo2cn0+Q0Pwhcdac7ETu9PhFbDJwZjTjlLAGGI n1wzDXe5GNoNqOXIAZbeuuEz8qCl+DP1JwURIT7EMWt49AfLkOhymWTRFhgcmf3DoAB7tvBhS h7H4Yoe/1bKkXjYvh8kZ9iQWu/52gsZ65v0bAWEO4vb597XWE+bLzdsEYhzOedOQyeFoS1wbj QRwtz8PtA13PjXiaWkxRz3D50whrMHnmJcZzbuSWTBy1pnC5ITUrBN/0Xsi6vg93KTh848Gmz dn7y9+idRYfmyN2kQ+go2cGTtBuN5RC2P48fEpJTwAUIiX/uFFRUJZXzJg5Q0Tqyz6uxhV9Uf yZQLDBYRM5vU4voCQAZba+74jTmlDmRbhAwIb8tREAjcGXsKfHKpTL3RES2fX0bbuf3AB7S0t hrXsD+WZHM0ciTyTjhxK7LPcr3h/DgMZC6j+1UEGX9e2azn+yTzbnvwN+x90GIFh1fpuzANzh 2du3xNZDBcYCqH/ciyl57WNHG99V9FFJOGt4xl2rnr5bxHRUnRYK4qi1qMysfdgKByhTB7oW3 UsHWrasZuPhhs+Zeblxy+Ls5DQj77FpHoNJYDMPiHj3kqND6BUPmu4Q6fcpVVrSj229w+Rjjv i61SRo4NIZEKI4Lsic8l7eKnwqIEoNyUi7jFVIzbupFD2ocPtIfShWvCurzYsEvyaQ4iA0lnk pxQpBayujteC616eRI/iSgCCYp1HT5gJKg4lDeDD5qkC9hV9/vxvAo8boe2NRA1fy0TIaqKRU 0eqPsvGIOee33P/I7XftRNbPC0nUr8HscHYSwQmO3dOPT3xMAUX5jumAzvku5HV5310aiFA1c T0U7n6pvY/iad3RpibJmpls2NojwS8/8LRRxdUuouHmxq4SPQ87oKhGB4OSlawkivcdvm88c3 mSWMBe/Yul576PO93zy64IQ0m/s+/vlhGQEtRJZjghgasvwr5K7w1zURPNjL6nn+73Z2P8TBE k8PxrPVOxcFsR4o91C1R+5uw5NVCpaSNpbQHd9OQML5wOb8SSZxQJRRz6dSMu5eft/AYRcuFI 1NYG0oCLCszs4Fa1cdH0l703xPskIcyU2unVZ7I4JaJERbI4ER3dWkkCbD7NwgIjTHndmyBvX TVpVAG41e+TE8/w4C2TjDsS9A3fFHx8/rn2J/oftETubLUHfBk9VuI0auk5GFBpnksdxmonNy 2inoDNDi6cpsna3saCIfvLmX2hSuvg1qfYaDWa2kxI10aPCaCwsFz123KcDDtP0Neu4+/HXCb Xh+e1NrBVnYkuW/IPbuUvVH/Y76u4nGs3dNaqIc9z624CTQKGYcmtiYO5QXl9KSjTa+bcwSP6 Jlte/+Vd4YiZKsltRLI08Bs5sBv+b8SDh9mF62SZ9EH5/n8l9baOKvvgqKmXZjesnHf2atsnG 9Jb7t6t8us5cGtNmfIMJxS44NUEQJjvDptZeNklJOkBrXczs1jvlaY6aXraCuz/Rz4NwrsKgc LIpBL3viNw2jURmkoqQnHmPlpa3hpftEdMRbvxt5MX+5yY3UCEHhPzVEDEE1tu5hiuG76bHOl 1hyXUD1H35CoCCNOodUrrPILXtfVF7ApWWzIRca7RBHEjjCCIQQ7Tkl/xguIUA5Fc4p+Y0nNO EJzJYqdoEfrJMKbmNGIAVKRCid4A0UVIGALJBat1TRqIIHqb5jxmZvKcLPNQFRsvevGh8bTiR A1t3hGujISDxNxwARvK/tlNO3ekbjDNtJW3a2MulY+gzB2UGEUTfRtzazn8XW3CH0Xs5JeBZk t9lejfWmidV4F6AeNTSJNJuXarNCBICyavuf3lvBZVs5DYR8XzaEQLwcNvMkO8m0I5iYwTjfy 2bKYDEIlKSUQ0bVZsV7zWznZ1yKXslpIhuedAIsT5PX+ZxIfEVFEVBiujhHj6BQSImjRu+KQu v+xxyOghXvF/P6qUvMvyP1CtjBVGJ8I58LOEPtXNcxUTYJKVDFisPqYkHV4D4Wwhgj/6Sn7dJ RXBwkjVZO0hn8PExhgZZWW4YPfBJhdisuYqBcsSOmfHERpRPPzo2++gcsqTHpV98LJmqB7+bt BT8WruDJcoGldfBYoTfsqIW8uTOcGurpQ3wugde8xbSocpHT193ltMc/aSPisSuJuENi33QA6 nPS4xihwfYw0BAERv4mNr39QK2a1fi6FG2qAGjArnG7LCVVBguKTLz5SSCXlbhUMxVfY3jhvo 63rswwP0pVRnupMzhMPYatXyMV12YDtk0uSWFwzSdOKhXy4Zs/mgCEqK7NLKjMDqNIYH1LPFB ACmx+tCotkjTYqdcrt6y7NhthjSWRGLfA4mXMhRgsZa5CSjYKTGJ4ggjc+nc1Yg1w5AGWb4l5 8TwImOj3QfMRcz3TydnQot/4Tkcj32hgayy2ihZ01coNZdC23WpXdupbXfthOwTzSojM3P8mG jRxxUNQbthF6aJdAyQN/Vo7HCEMk+Y+vOjvz/g8UXW3+ntPEZn1hY083SSvPxqBuinQAho8Dt qGLV9Tfvu7OIL9Gi4Sj05qOQxUYP+gQphoA7pxuPg8yKfT/jbrYhxmAx4JTB34jQKUu39zEGh CRkyZz/iOmNCHFI++N5HST0fRCTXUWdTjX5ASS+Y5bcDhDJ4nl9JY6vrqLWzFoDM2AhoF/XDq 665AvB/JqYSynywBfxb6YgyeEQs6/WSRogDqCsID+iXKqUR983e84m7H/JNChBJrA5+Apt3fD m80pdht3YZ//E0VGoupxtb//EfTC7UGSp8o+XpxlFNcaw6pSfmxRn905+MrVZz5VDnRfUi7hK 3im8uH+u845DHqalkUhsaNrbybqTrlXCHFuT0wmQ4N8IjRlRHfj9MBf3hlgMYCrQwDFtHumz8 ra3liHa3Ty6lGEdwBNaOshyYfoXav97LG19P9JIVzXpqz+rOipNTewuz6e06uYFD8jvv3acc2 G7mmJ57Yd8fWarpgSUQMLR9t6fJ7RScCfHV8w3R8XeNerH6E99oJ+7wvazWM+y+oXRQ3n4061 CcasrWeHHzcOzN7/TM8p0FTqqqFmPaM8QydWrv06yXytW6/B93f4oPgYIGB1iivQEwdX1U5sJ d/Fg7v+OH2S2KpvCIC3rI0LwA5QScWytV4RA0QED9l+Sidjniqu1sQgO3pLcI/tDCKeKS5bRF 2ZsKjkynpCdIjdVEz89R5RR4uS73WO6MC54D9G84RSWG0FePVyTUkPSMJ0jcJfrP/PVu9Rnux fA0Px22CgXzgr/hL+Ebh2Y5waHOBuBm8zYuX7nv+aDH0x1g/zIiu7jqBHszcFlpBoBljwFTyg kWDCszKB5miL73z41zHWxqPkDQDgu00+zCbhiQsxi1ol9eqXMAcJazKeWirfD/+pRoGQeBfUn wODaeORhvyNuT1V+r7WhzvZ9QsO/cmMMNsRyy85N2hT9/n5wM6N+roFAL2H2qXwI7WJOShFPN sUr5ss3UzmSErHNWKWju1gZYHMn/5aQxACJ0vQd1c5sgBRHcLul8IhsKGBRLNi1OCIx/EpNFA WYMTrSMExpMKZ6muYtyLEBc1LgvyL5IL/9yLGGlGgC3QfFaJxy2WjDGpBjrPEkCyj4/pkd/yd G7WOjLBNb4QDwgF6nRsGwUhNEwsSDReRQCy5KH9xdKpRd4wbk2wgjxeRYzpqBMBD1ktcrkKdU 0bUKkxVxXFk3UukE10q03By67ZIneCFS7NbNIxjiP2jokFMUPwp663i9J/6fTwHbFwWUyJ9hr XH40mhq4jguM8xFhIhrNmJ3lWnwkW/KywapvAwln72N4BGljr1IXA9s4bJeV5BwPuBN2mIASL vIkjR3qh/2zhEXaLMXC7NqAEPa+R13hc1/oVC2yjccLqgYO9x3SH5GOSIr5w3z/HSAKrkO1fl GOQO0zrf+1gjjLAav88PvNicBcxWvLZ5wYy09d/n72XtXQyxHZm0puA6dkJf0HKkrMc7hvOkn ntA3NQmiNzwh5JYbzPh99iFi4dxZjBc3/DFg4QE6hhjyugy8arS2KVddDUyWic7DgOGQ3PRFe GdHqbDiGY+PGWGv94kXVa5+0cAGmtMCFKRe5mjqdFhq51M5jdrjvfvbwp/22g2UtWCmxJqgyv x8FisyRvQgbr0PJsANswUNoEIEW+eGsWTSVPgcuKIXSAawfONKP+B1Wr5emTvwZgKP+3Jr8Hi sj4AjRgGd0MxKlaCAXV8pj9KN4Rclx4HFUsDdRCAeGt6+EpZDH85dqCS2eqlqYQ6npsCIE3wk PVbC3Yf6pt9OzeIvqKhsOyhpgqxDDH2Xx121c4F7MLkDftWBDdJpqdyLvJ5LUe4WnryZ6rird OsNd0/2XZx7Rm58Oq7yOJB/JqEKVJlPty9MCrwyBWMFuEm+8Q3K897tQlSt9LzkHCYfsbaN1V qxRWjmJ+fGZjC+THEV+WqKYEz7dRVV47CXNzU77nzuH1v40mQIxWYbImJQuthzwlfmj5shgcW 3coKqEXTQXIY4joobCMTWHxkxYB1ggAvFpHkXDOuIYjBg7jOvpJ3TiHyL8LP2Mh/ovuf3e02R JcQLdd4aDP57as909zhBplQUklAFXsJ5OeV8PD4/oi2uzDF8r4Dsk/LH2N9plLBSdqL34eaWA OzZhsXeSKCTtU2xhl4/TgZrwtholYh17vlH8UFJACzeijMQt62/4NYx9AQwIlfZkmIuWdoKS5 ecC9whk2T6szz/5eaPiYtr6plwAJEypXz7ZGkntl79RL1PGiJVq/v0Z1Hp/3JUnL7PrS8rZCs 0+pHnlUqfikzlVIaIyucW0LoNx2ehp62zYvPaYWK6y6NRbKEicdJl5BNhCLGnlL7pSJO+1IjO aUFRmAZ8NsxbTnfvdnJMFd8Pq5i2on9oNAIlFPLY0Of8oT2FxRK2qrzwBpKerHVb6l753cKRk cQCSjgMALmy8+kHC/ncwjBA0DNSH0i3oabJ/coWCuLRwbqbA+MWZOMBQRZqJiG0eMByBHdSXQ MjVqNHouPmVQuXM+lgNtXwBx7pHoYcFNmLH4Numhe1WxXz+ugb4MYuLAhQEdBDqpDTEsRitA9 WOiZpc2MiXDzeo7+9RzOxGZzbKgO5MF63BwIQvmFtsbwUfwV/zxybIrHUyy+SuCkYrOByre/5 lk50Hc6aCZXLD1jkL07W/Gp7QveDajTZaCsAUCDOIZfQ5YiT5Byu1gGJs/qmNa9XGRrX4GxFC CxP2VWFyopFGgxwPqj6aBDzeBlEZj1TrADCqt/B3vX40z4feyCZoRCsg2 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, On Mon, Jul 06, 2026 at 04:06:13PM +0530, Mahesh Sathe wrote: > For a 3-node Patroni cluster with PostgreSQL 17.10, here is the > high-level approach I typically follow for a major version upgrade to > 18.4 with minimal downtime. > High-Level Strategy > 2. *Upgrade Execution (Minimal Downtime)*: > - *Rolling Upgrade*: Utilize Patroni=E2=80=99s rolling upgrade cap= ability. > You can upgrade one replica at a time by stopping the Patroni serv= ice, > upgrading the PostgreSQL binaries, and restarting. I think you issued the wrong prompt here, because the AI answer describes a rolling minor-version upgrade. You cannot run a major-version upgrade on a standby. The proper high-level procedure is to run pg_upgrade on the leader and to re-build the standbys afterwards, either through re-clone or via rsync (see my other message). In terms of Patroni, one also needs to make sure the DCS configuration is updated, usually by removing it from DCS and letting Patroni recreate it. In general, the procedure is quite well described in the Patroni documentation here: https://patroni.readthedocs.io/en/latest/existing_data.html#major-upgrade-= of-postgresql-version Michael