Ynt: Replica servers hanging after the latest security patch update

From: recep gül <recep_29_(at)hotmail(dot)com>
To: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>, "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Ynt: Replica servers hanging after the latest security patch update
Date: 2026-05-21 14:09:24
Message-ID: GV1P192MB26837B770BC141D54AB8892CA50E2@GV1P192MB2683.EURP192.PROD.OUTLOOK.COM
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)gmail(dot)com>
Gönderildi: 21 Mayıs 2026 Perşembe 16:43
Kime: pgsql-admin(at)lists(dot)postgresql(dot)org <pgsql-admin(at)lists(dot)postgresql(dot)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_(at)hotmail(dot)com<mailto:recep_29_(at)hotmail(dot)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!

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Raj 2026-05-21 16:11:55 Re: Partitioning table - Update on partitioning key
Previous Message Ron Johnson 2026-05-21 13:43:16 Re: Replica servers hanging after the latest security patch update