public inbox for pgsql-admin@postgresql.org
help / color / mirror / Atom feedFrom: recep gül <recep_29_@hotmail.com>
To: Ron Johnson <ronljohnsonjr@gmail.com>
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Ynt: Replica servers hanging after the latest security patch update
Date: Thu, 21 May 2026 14:09:24 +0000
Message-ID: <GV1P192MB26837B770BC141D54AB8892CA50E2@GV1P192MB2683.EURP192.PROD.OUTLOOK.COM> (raw)
In-Reply-To: <CANzqJaA0i41sjsOEYQApoqoap12hMrxiskT3ZGHmMiAiCB-bdw@mail.gmail.com>
References: <GV1P192MB2683BEA93EEC772A22F150C3A50E2@GV1P192MB2683.EURP192.PROD.OUTLOOK.COM>
<CANzqJaA0i41sjsOEYQApoqoap12hMrxiskT3ZGHmMiAiCB-bdw@mail.gmail.com>
Hi,
We performed a minor update from 15.14 to 15.18. We applied the binary update while the replica instance was running, then restarted the service. Meanwhile, the master server is still on version 15.14 and has not been updated yet.
We experienced the same issue yesterday on a different instance running version 14, using exactly the same method. We updated from 14.17 to 14.23.
________________________________
Gönderen: Ron Johnson <ronljohnsonjr@gmail.com>
Gönderildi: 21 Mayıs 2026 Perşembe 16:43
Kime: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Konu: Re: Replica servers hanging after the latest security patch update
On Thu, May 21, 2026 at 8:58 AM recep gül <recep_29_@hotmail.com<mailto:recep_29_@hotmail.com>> wrote:
Hi;
After applying the latest published PostgreSQL security patches, we experienced issues on our replicas. We first updated two of our replica servers running pg14 and pg15. The replica services were running during the binary update. After the binary update was completed, we restarted the relevant replica services. Upon observation, we noticed that the replicas were waiting at the last checkpointed redo file during the startup phase. Meanwhile, although we performed the same operation on our other servers, we did not encounter such an issue on those. Has anyone else encountered a similar problem?
1. What specific minor version numbers?
2. Did you shut down PG before applying the patches?
3. How did you apply the patches?
--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: recep_29_@hotmail.com, ronljohnsonjr@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Ynt: Replica servers hanging after the latest security patch update
In-Reply-To: <GV1P192MB26837B770BC141D54AB8892CA50E2@GV1P192MB2683.EURP192.PROD.OUTLOOK.COM>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox