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 1wgMYk-0068qJ-0L for pgsql-admin@arkaria.postgresql.org; Sun, 05 Jul 2026 13:06:58 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wgMYi-00C0Fn-2I for pgsql-admin@arkaria.postgresql.org; Sun, 05 Jul 2026 13:06:56 +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 1wgMYi-00C0Fe-13 for pgsql-admin@lists.postgresql.org; Sun, 05 Jul 2026 13:06:56 +0000 Received: from mail-wm1-x343.google.com ([2a00:1450:4864:20::343]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wgMYf-00000001rp8-2thm for pgsql-admin@postgresql.org; Sun, 05 Jul 2026 13:06:55 +0000 Received: by mail-wm1-x343.google.com with SMTP id 5b1f17b1804b1-493c733f15aso21257175e9.0 for ; Sun, 05 Jul 2026 06:06:52 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1783256811; x=1783861611; darn=postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=C7M6KI3sQK4B2j/3R1rv2LGdhnGOy9zUHtyAPGuGxGo=; b=H0R7/jUccx1ArrPYM+XQBIcpNi7wABkmyIXt/9RtMjKYWwvF08E77NVgmVtLpeBDbK WREoMMk1LWIIALMYXD+GUJbeVRyIhMm373D423OLJKrP284VU+NcncnWVFSaQOdJ7DjI Vv4SHJh/tC6VhE/8NdXMuvOPD3LIjADU/1PjgVwlUqCRMzgRSTiOueNkfyFHleH6L5ED otYBGhcQ9UlX4SLLXtt6E0Hwb5Lvnq6YO8KBoZqAXUiJk8VL59dTSGFIh/50prRy92Gz MNmgusm9O+z8nmKpJatgvFB8fRpF7nOMB0VGdHyXGK1uyQ36s2B27b9mfCzwdTJjKMJN Y+4w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1783256811; x=1783861611; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=C7M6KI3sQK4B2j/3R1rv2LGdhnGOy9zUHtyAPGuGxGo=; b=hFeW0CiOEqBBJwHD9vBlZ8a65SpVBkU/vnnV2yKW0ZqhGd9J0iAEJh6ph6v6uwjjAE s3L/HROBKtStAo0ytXIGjujgI3WIWG3PSaIk55EyUmFzMDwD+9UiJ5pX0cRuwoMkt9Uj vAz1lT8LTRRYciOwBIBcne8ZXyr4XQgcusT7ndkfpcloHxgHJwYwowgeJgXk2IEuOibG bVAPiCjOYTE32flz4PTG2Y/IBAlaa6dtNTwyKREL/+1Nis37GCrfTsSq5/qnpISc3Z2R pq0hwLMKohXjOylcs43kl3ExgwIKbK/xK0ACGYLAO0qxlQrNuw1+MbU1G2aWKTawrADx 6KUA== X-Forwarded-Encrypted: i=1; AFNElJ+aX9NPQKRswYcN6eOH/OIoRAsAhA9PdONdE0J3TDZc8IBPokzWLwVd8oAvzraPopqNj94Tl+hJWxC+Pg==@postgresql.org X-Gm-Message-State: AOJu0YwyluaiByvKArbEDJqJhA0o7Cz5q7q6bF6UbYM7KqP89FYJ28id /HrWOgH9Utm22sOy+XfG3no9vSNWO2/eSdYuS8/o7HrhNUux3DJvmq9c8rJ9p8V+1C4vEY52RVO iWCO5qhsrcg== X-Gm-Gg: AfdE7cnd31JaAFKFeeo4v4IbFBUONX7XA0ZH7yOmEFUvN5rvqV9MEeYKptLCYMvUGPN +apFuOURl9coShSLwuuD/PFoxA+S6Yrpn5t2xv2mkFoWLVvWiJ1Nt9LBE6aOhjZmaq40C4snvj+ 2Bi97UtTZp6+HgentU725nrjCGRnc2UREkqzVlu6IpX4tSC2VGvTcZtUoP+goADBlZWFvLPkVgK YTJ1KlcSB1ZeMpGInfZsKwbl+xKGJqgEi6pZJnUy5O72vgK/huOgbUnutZhNHsTWibFTfoVILGS Jw+sCaudmSoXM206Kcz+DRDrLtZBmiGdUhbloJdYBHpx+CVS2c/ZBElYh5vgSnhXTO9OlfA5I9v u/cMHJUsA++Ncy3qs3/Pvs8K9dqDrU3QJfKcAvNZCjhOdanejzgwbn7nui35z2ty8jiggc2/3FI JVB7NlKh5jwv616fQ29TyPPT8cA+dcQwsd8AQJYY17QF67S96wyMKV9A== X-Received: by 2002:a05:600c:37cd:b0:493:c82d:f3fb with SMTP id 5b1f17b1804b1-493d11f6d3fmr80228425e9.28.1783256810713; Sun, 05 Jul 2026 06:06:50 -0700 (PDT) Received: from laurenz.albe-K4N0CV00F97414D ([2001:871:260:4dd0:6300:482f:13fb:b161]) by smtp.gmail.com with ESMTPSA id 5b1f17b1804b1-493cce040b4sm272162985e9.10.2026.07.05.06.06.49 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Sun, 05 Jul 2026 06:06:50 -0700 (PDT) Message-ID: Subject: Re: PG version 16.14 upgrade went recovery state From: Laurenz Albe To: K P Manoj , "pgsql-admin@postgresql.org" Date: Sun, 05 Jul 2026 15:06:48 +0200 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.58.3 (3.58.3-1.fc43) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, 2026-07-03 at 15:25 +0530, K P Manoj wrote: > I am encountering an issue when upgrading our PostgreSQL database from mi= nor version 16.10 to 16.14. >=20 > During the upgrade, the database enters an indefinite recovery mode acros= s the master, standby, > and multiple cascading replicas. Due to legacy requirements, we are utili= zing streaming replication > for this setup. Interestingly, when performing the same migration to vers= ion 16.13, the process > completes successfully without any issues. >=20 > Could you please confirm if there are any known bugs regarding this behav= ior in version 16.14? Yes, this could be bug 19490: https://postgr.es/m/flat/19490-9c59c6a583513b99%40postgresql.org Best wait for 16.15 before updating. Yours, Laurenz Albe