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 1wglmB-006O5y-0G for pgsql-admin@arkaria.postgresql.org; Mon, 06 Jul 2026 16:02:31 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wglmA-001bRY-04 for pgsql-admin@arkaria.postgresql.org; Mon, 06 Jul 2026 16:02:30 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wglm9-001bRQ-1l for pgsql-admin@lists.postgresql.org; Mon, 06 Jul 2026 16:02:29 +0000 Received: from mout.gmx.net ([212.227.15.15]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wglm7-00000001s2c-1EA0 for pgsql-admin@postgresql.org; Mon, 06 Jul 2026 16:02:28 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.net; s=s31663417; t=1783353744; x=1783958544; i=mbanck@gmx.net; bh=4W3MshbTBDXsKhpGNQQdbnYSGQG+5xOlguenuUtajTM=; h=X-UI-Sender-Class:Date:From:To:Cc:Subject:Message-ID:References: MIME-Version:Content-Type:In-Reply-To:Content-Transfer-Encoding: cc:content-transfer-encoding:content-type:date:from:message-id: mime-version:reply-to:subject:to; b=Rf/pNajrmAsNN1+aPpl/FYNdVCtNBxva+lEM/ZsdGnjfNHDqBlu81pImTk8JNorD W/G7/dmphdKM9ch2SN31OaJk3tudgVO75VWtBJytyDasZCYe+Bg9isrBr0zUrh/tx nfa2P3vERrDMKlSZiysEViOQaEQE8zvYT2pwp2inHZjg2rvhKI/CCRINqS35CamGF cNyB3RFlnRDaTIix86vYoIRMVL40q3YwoOk2Kp+M07688K7R+VMbMRDI1nOI8vYAR gqnlFTkU422wNOx3vpSFNKYnkLlMbIFrnMel5tRD11bGN85Gk8kcPHGZ4cY7lt/uY bRe+d5zP5hURFdHWtg== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from client.hidden.invalid by mail.gmx.net (mrgmx004 [212.227.17.190]) with ESMTPSA (Nemesis) id 1N1wq3-1x4WpS3KJN-00x2ul; Mon, 06 Jul 2026 18:02:23 +0200 Received: from mbanck by lightning.p46.dedyn.io with local (Exim 4.92) (envelope-from ) id 1wglm3-0004Rc-BX; Mon, 06 Jul 2026 18:02:23 +0200 Date: Mon, 6 Jul 2026 18:02:23 +0200 From: Michael Banck To: Laurenz Albe Cc: K P Manoj , "pgsql-admin@postgresql.org" Subject: Re: PG version 16.14 upgrade went recovery state Message-ID: <20260706160223.GC6368@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:ia4/zYMyDJvUl90NbdCNJU3Gtd3e4z1eO1sNZ0miEYhYoTEGXeM yo9ft9kGmgJ6ZnYdakwhxxpO0U1AIE88V6ny3cEYCl0saR4f03o2UzE+YBE4D82D76MCKT4 avHUdNTSqthf1eP65omSdIO+Qx+3uIGIMuTW1oa0EpUO2fjaXPI1wkzR5/BUkAt66yHiBG2 kwcwUUFT33Z1pwMvUmeYg== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:zdjOdewjRsA=;zdj7zEXTtkN+S85LMp0r6CHrXw9 FxwxOgCS0WfAzGI4gwWEglQL98+axFokFZnFhz6hNUGcgRFaP7kCTB0JEtpU5RqvERLUntACd EQ1nv5EA0lYx4b7xznAB8cBnNBVVX1hq6PzIvyaDNulcj0HvHwdLrnkkKk9fJxEZF7NXfRSLb sRN/cblP6it+thvGWXfyO0Bsq1t8ll0r9NB0lbcYe/8VAlnCCxnPHqbQej/LdOUSTst6SCVkv NvYTOrqTypHNBwtKGOE/mEILQ4qB1gTF3ocJFaZX4B7BTT6J7WJhZEPu9YdoUH+sSioMKYpeO yOIfVea/5c5lfXTJjJRNZHIihroUyG4mtCd+CWXQQh7v/3LKF8PULnBm9EB4EVCZWs8jQZGaS 8zBHEDEZkRLxLSR1X6ic98rTV+LAdSVJ2PW9sYQ9hCh0wamUhLz+dZqB893UAMeIsxC4ST+UD 3nvki5w3dZHX0Xc/e2mQ8Y1Vjv66Ofy8BYFfJ8S6DBm0kHq4SLcv9KbvIjRbq+JDaGlWQzcjh x2p/5M5CKJ2m5pl0d/rT5DGJldfNl0xx6xQHV2Ub5cY4O5ms+qsxaF/o8cqdY8rcsZ/qQIB8t jM94mrTHnlS5GWF1eLKY7yVUKhzX2uIEAQfUfSwzGFVLO/2/SXNlU3CAxXGk4sZxPlsvstHX3 BUsF6l5nBNa7XdUUorks3gIvLBW0MH789RFPIaTvPi/MHEFPTTW9SXsrUHp+2ZykKVGfM/QYs 4rD8sR3kwTnvGhF1+Y2XDk71TFBs75rUA8e7w1AR1hXzdiU6UScrV9XHJLdHLkMs5zUbhY91N fSirYTF79kfO925ghZbN6ACOdsp8QHeXCL6wpOkR3wf/xO/60G5G/IYnvvpIAXn5W7i4C9vRw n2yB/m4LgrklB0ABTu7dptxnLM3j0+bfYOL7YWOa8nDqce5cIsctrCKJd5lZOeJxZnplxw/q2 yqeXUiHjhqet4s4YAoiiFwsOSKAl2clatXseplmuyq5opSiuA6pkajWQwRAe0P59jQhKIief/ PR/pcYRE+EkFXvoR9dSHQblUzvd1gxt5yTL2k31eNC2K6CXmkHefeXdJqRLj+gbR30UbuIIRa +uWUOli9HKZtn/BbNrEUZ5Y58/Z37eiKEmIJXWrXu/Rh6sQebChQq8DsGJeK2ulk9nZbhLubh 4hr9MGjSj/IM/XqlpoNqSAeREIhOAJUty6AYNqWg2E7GqRJwFBlhja14Axv7nv7wzpE/ufpMm 6ROpuBacykt/9klHbU0Hys/xYz028sLY4frM+lRF9WkhOVF3e0t79vW9n3nbJGr2pg/NyMAte VpJprwoxXyBJhQ9nSpSafWUO5TsS0s4JouPIjPnt1DFH3p9yVk9TuY1phWRjNsdE7Le97nbxM 3gRyW/fEkZ2zaS5twCIVmOp3QqCHRiPfWGu9f3dNB4Qr0L7vesHp9z0NUVaOnvCP+ISJFakQP YECZvQX27QCONx2XecpD+ct4XDTXcRcVjY1xjsjZyz/BLLSA2uhXeh3hiV8DgjLEzBkpoBrgj +Bex46zK001BvwmT8cOtDHHySPRnjqeYnIAZUr9BerV7YciCQW7JMBCOWo1bs4Nk53u7Vave7 dHme9myj11VQY6/JBlL9HIffRQmtiY8ySA3LanEeL7jNTrywPqDhUbHfzwsjrcpdTWvARXGn3 pLjaeidiRigXaxplk+tABNygIoiMNVbR6NJXIxiq6+3T0P8/s/iViu3ex008h10ePadH+ovLH AkW0Iq4fvn7ce5lucqsbRCWA4gYGEDQ0QPIAFNU4qDAX/km7LZoULCvsezOHMU110YFG0SAqJ 54MEplwBGxPl6SdqHB3DYor3QUzeVSRk5wVdkwG9zBzdu8s23ZAGtRUjy2C82f/vc9Ii7sh/K V4PyMOfe5OiXrMsAIUrqqwHqCflHqTEJ9O/gmuo/fI2Td54QtnW0V3oR9NA9jSsHbzyFV2YO+ /liSWwezgl8K6dJaPvxaJZhLiWQ9YqWbKqsJ9ipjm7gyFWKtxBr45jwxlS/RAPaLoAEomywfD vnNcCSUhsjRrb3XKYnrqlGOqdPYDq3wZYzRQoorXyBPJI8o2UoxZahwuU1pMpx9qME6nWPWa3 wnnkTylxNG3fKC9yqF1arcW2Gs5W28h02RDvCJBFgXKM9YLQT1vX+7UE7K1gwijD+5DE0Abo2 s7dNxKMHEcC4gFvoLGO0u/7IQ0Ly3+e4Tsm7XwaAx3rX00OeZEugTPDi5NsgZYmgyHTcl+Qny sNhxBdLt6gO4ywqW6RLY++Jx92DDhi6WfkY1na511PUvS48Z/5ixcPmcLmCHWe0PNWJyLKolw Eyd8eC6PoeHptOy0Ysu56ZsYZDUx+eWQV5qxAzPSkUVEvfDsMFIqg+JEjSKeC71Ij3Xscqsj6 IGKIgqRDXzYeMOYs7/JmI4SamurLv+R2Bo7oZROParEBL+X7c3FtR5zQ7OaunFtnYqmAwA1Es rHz6XtjLN0e4yy6rtyt+iUPXxyCr3zBeDfxex0IKHpkNCycqGyPQD1oMY1SGYNWwH4/FurIhR oA0zfpmKi04JC0X6mp2UNDzIcREJN3mxMg0INjq+QIpKXJs1Xm0xWn7kATqvoeokNqRYi/x9e Gg/y8v74/bZh5G1yaqzA+P9KDGyEWqhye/TK9Hwj7t+cN7f7uvtgHDSE34u1ooShPoCSyUgcv ISxdEAPf6jtfkH5EVpw9BujQ/kAdKbqoBXMHM0jnu2I7xhy0KyAexSiAPggpyVlCRJjmYSIDh CnctlcbjRQtr/wEITXNI1H7bJmtUBU/AeHYsGQoCP/dc/hEwUVOVfF0ZVyEBiC2l/lCRqVpr0 Uw2BISn0FAQF95Il5N+J8q0NGmFP45fI6Wz/Aha75GyzLvWTjM16+eh4y3qADq+neMzWeB1SC FUBWncu5odhQ8yNdLvznzWH6QddvfAGDb9SubwGxGz6FlgZznlPe4u162zlVTgy7f0fDLwY3R tFyR/F/zrEjKPElSqlITLTLuElqOHCxESfuJw7041HiixFdbpyJtpt3/08WdarhfHyvStxTG0 rgOTEHiBgNctVWLBw9sUjAmC4SyWv1VT93omATzzAHrnc6FfKktI108BTKtmievEtyXAG6wUP UQpmUXqHk5EkXWhp/d3kdhfub+Ax3eEFL29UUmMc8PHDm7mbeC/ywrcLnZpx7SZ/xmpwx9mBe c7/kE+S83YjhxWIlXMCtu1wWg4v84wyjYYlQl7U3qK4AcfIzvn95ick5MiEYM2w1FyxhOaLyW udqVnJfpCyJ8hlf2GFLvhP1T/CWpstfi0hvPvzqA7m4FkGTkn1c5HZnIlJhkHJeQ4qp5GSt7t GUVuVJHfsgAqyKVO28VA+qi98gb+2TMMYEYJu8V8SjJ2rrhGX+Uqn3EqnD6WljyD0BUUzGcV8 9Fh2LQcYvDC355onYVM0mNfAzOhDok6KAWAqnYDrH48vfURIzHUqtUbn3hhRszggC+lhjSP9y 5aK+nlijrJ0dZloAbmFxugh+tbEjhjWRmqi1zUmkelqaC484oKrBk4pEERbnUy6bW4gouen6D CMc5YeLqjJVeJc1d28xZl+J8Rn31SGmWJgKGJ2pNiVTdZcxeqm4bUyIr0/wK2eQRWQin7zBQa MDh8b6Bfte7LrWsp3uegxgrByq3MPHijRTKLEFKAhyhm4BUNfc/iKIdy1zEsxLLgJ07WYrUW0 a/qfqglY1GlkmpQPblltfQ5+S/mmKvA5j1x8888LAwOTHZn9R4wPM9sfEc49u6Cv8dEYljep/ 6119lXG7gZ4E7rhYDbnUSFUKPKZsdVAG4WILRBtQNriU/++jtKY5tVIKuRriqM13JS7eum5TM OUhNSDse8jd/7dalh5xd475hzVUv0gmGd9MS2brp+NMwqK7If2GxSe0Hf4SpptnCPH7tmgK4s pl9abalKGG95O4rbUup2zo3zLvu218TM4G4gz/Ek72beiZbQZbpYcKXt5QmVfmG9QidCZhRVP OuB+081pIgeuyheGyfj0N2RYQz/Y5ezHHr1fcPsU02OHUa5AmyBAGvKFQvMbcMMw7ZBnCdcYw CGKSW8r1JLSU/+zB80Y+43rOOJG/uZ4x/P1Np+hc+6kwhQzxiygEt20RFcLpfwjk2+H1gUpqo Y2WZB+hN5AktiiTxHWxsKa1TPLzXakBe5CKPokdyraHl9wrlJsDkoD9FbBBlmpPjzCWudGiuZ 5LWZUcNGNY8Ohf66t/XOwEhCTCHW693G+GUL6OXw0dtBOwOGqBir538jfbuA3wjeC+HtuMAHA RohCDVvqwwFOP9x9/KHxgdYAysd5/36pRhtEgqxOM6t6UX2UEIG23/IDEhUGdp714mwP6qzF2 vFTg39OhyWfB4Zqq4evxYJY/Wpdkrgj39GAMAbNtajgDYYHdVRvNDqohDqm8mDqTMxUDQuKfn PQ1s3gOkfswUc1VpZusHs1gO7unGVx5inJlxqsUboc9R9eAAVpvftCEqOfXmL5pVTz6vKctYX sus89bPxWuSXA3qg8kQiLnkGgzKxcspVhQ8ZUIItFnJhvwCA44gRvP1+1EMeGev/9777Ebqy3 VAXe0W7fLvg0bXU7hsZ89UznCdz8oyAE5iScb3AEQDzejATcwYOf5f1Y0GIaBwxfs16f4jm4L FdqjzcGSjboczsN02hzfVc9vJ0VDJLBFoVqzZ8nWmKQbzrwnwuewyxFYYkuyxIdS4a6HhGVEA D6I0IbVrG9Gan0M0McgZbbO87madjslNDYDzFh5AVz8xSPl3pU4MP5Tyc3cdxLReewy+b1rRF elR5awUVYxBsNxPvHg4IzttrqO+gAZdScMq2LvIEZU8gE3ri4Q8xcq0x9XuK1VKQFDCvSl9dq +0jZ9Wa7iS16U0X9Uati06KBoe9iKUs9Yv1iKuk6/GKUHn2HRNV/rAWt3WeTHhA0fQkyVeApq c135kcXgaG/XvSO0kYY1yBN4FVASrR+e8P+SCPqhWfq2LwAwP4uCjGnzo7e1/5luZl4BsybcG H0cHni2nmxxv0hY1NoUjGeoh+EAerW1RPbbY15cDuMbR21Gvy5sr62k1PcegqxzSmKvEavHll 8GVn0LGE4MbNqvUnyCyJYWxxsZZQMjEk6MRRJtBSom4woyyNKtJoBZE1FWKSiM0WYZhjH8bgQ NhFPjvItnhbelt+TcIG3lYktRz8i2L/e20kApW/aUUEOjf4qPaR1ekoR9n5NTMcKmrdaRgXRT Xn9EdHq9GIOctQF5rxxMdl+LAvu7iRmTkmxrCDRxmAmgKBLcvg00CPUJ+dIc2FfFMkZ6flm5M BB/8cpA4Fi8h08r/Ng/T40LVVTX0kIvno21SrGLlQcgZJJXQbT9wMpqnja5saiP0sX+5w1x+l zA80A23GKdoAaaplAq1xu8V5Yn9JU1wHepO6vmAwUyP9Q3othzYm1mr2r4PvFlv0Z+JUN5x9U Uezhzs01swg37NERxOvK16EcN7wNVxa2s5aGdOf0LLI4e2Q+zQy7v9cKodnm0BN/4E5QrGDXW Uc4aLVpWN6KE9Yel227VrQVGxVOKmjMiiuPlmCz48BCjxM7ppAZj2Es1KoSKg4AgMi61nIBkS WenRD0o5clyA7F9DvgkKEs5iAZyCkQ4INfVDLsJXuHy/95Q40eEmz6NTktlLSmf18XlOFnj+L FPdwue45s0KI3vTZO727+zSxQClgtPC6cgF67pm Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Sun, Jul 05, 2026 at 03:06:48PM +0200, Laurenz Albe wrote: > On Fri, 2026-07-03 at 15:25 +0530, K P Manoj wrote: > > I am encountering an issue when upgrading our PostgreSQL database from= minor version 16.10 to 16.14. > >=20 > > During the upgrade, the database enters an indefinite recovery mode ac= ross the master, standby, > > and multiple cascading replicas. Due to legacy requirements, we are ut= ilizing streaming replication > > for this setup. Interestingly, when performing the same migration to v= ersion 16.13, the process > > completes successfully without any issues. > >=20 > > Could you please confirm if there are any known bugs regarding this be= havior in version 16.14? >=20 > Yes, this could be bug 19490: > https://postgr.es/m/flat/19490-9c59c6a583513b99%40postgresql.org >=20 > Best wait for 16.15 before updating. The alternatve is to do a two-step process, where you ugprade everything to 16.13, then upgrade the standbys to 16.14. As far as I know, the leader needs to be on 16.11 or earlier (while the standbys needs to be on 16.4) to hit this bug, so updating it to 16.12 or 16.13 should circumvent this as well. I wrote a blog-post summarizing the issue here: https://www.credativ.de/en/blog/postgresql-en/replication-deadlock-bug-in-= current-postgres-releases-14-16/ Michael