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 1wQ3gU-001FvD-0O for pgsql-admin@arkaria.postgresql.org; Thu, 21 May 2026 13:43:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wQ3gQ-00ADEC-2Q for pgsql-admin@arkaria.postgresql.org; Thu, 21 May 2026 13:43:31 +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 1wQ3gQ-00ADE4-1C for pgsql-admin@lists.postgresql.org; Thu, 21 May 2026 13:43:31 +0000 Received: from mail-oa1-x32.google.com ([2001:4860:4864:20::32]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wQ3gP-00000000jqc-1Ut6 for pgsql-admin@lists.postgresql.org; Thu, 21 May 2026 13:43:31 +0000 Received: by mail-oa1-x32.google.com with SMTP id 586e51a60fabf-439bdb1d75bso3970555fac.1 for ; Thu, 21 May 2026 06:43:28 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1779371007; cv=none; d=google.com; s=arc-20240605; b=e2f7fkuoujqipj0EJByG6srJZBPQc3W2pW2XulJY76bhPeMhRTjGYir7M7SIym9MXp HAsF7kJ8SHNZt9JWegi+9aLCjcI8wX0e8aUMJOCrP9jgpAmoK7cmCatYSB31oZpc8OYu RIoqvtRHsCu1tfdzDGqHaeB6HHA7oBCRHToHNLmKsJ5mpDrLM3UsrdBNxfbFTKVZxdmB C7lWellJmn6H1jrKulLGD3ZTO6mOPQMX4NwA8Q1LqJxgqz7G5h1/nmo6L8E0URRR1MOI BR4wzLpRu64I03/P3IMyX6L7dAUM8GzCeryv2X1SswicGPilbx/64xteV0P5CKy30DrL wYOA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :dkim-signature; bh=EPFo4XkZ1koDAkbTIuHn+Ib8F99q0mxFlySsN+97FQc=; fh=NsrcDeWI48aIyx6zGns460Rs/KoAjFnlJFVaNlo6lMg=; b=HM4hg4o4lqsa6PTvXIH10zgB9XXmaQH34q8CY0soKp7u4LrumK5cosK3vfC/rGkrdS sBOQlWofDcJ2F4LlYwTF+tjLpVSfDA+vrrxOuuC0GJ5B4HUmy4AR8W/1JpPsAYslZIqA o+A8fl0MvZzp4yD5EnnIzpiLhgYw2OErZpM0TJ1QaP+7VK7lj0e0n1mywTvRDumJgOO9 z9Y6s3gAQ/U6GxPpc4QCZmudKNj8nBOriyl+/QboNHJVnpmKqN3HoUh46Op1/XHAas3e SY+ffyDjQp2gAVlTTwP8vQLXGsb3yKu0Tw2MSag1MexI090OUsnlyWgwQf323MzWKVf1 tElA==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1779371007; x=1779975807; darn=lists.postgresql.org; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=EPFo4XkZ1koDAkbTIuHn+Ib8F99q0mxFlySsN+97FQc=; b=SBPRO2R/HpBznCaqONg4K46wJdFuEEO8GD1AyDPAqwAGMcsWF1mC2+V1Y2ptwAP1oz YtmePv2nzEXpvByvzjmpPN/Or4omXfeK5DL52ToSmmxj6rSQ0BfI/p4y84Bl4/MZFVwk +MDbJDa7+Ynos5kbJUnZ2ysEXZlj42gCRs/UqqHg4KUTSzYlMKYUnkAGbWlAkfhTtDZr A42+6nFr51P4YwVonO0SU+72ZOiZ50xLTenGzspFUi2yQCtcBvTv0Q5bZVhloSz+4CSj MQJMywFVSU7SGYCocfIqC3UIy2pUDufxWUXptwK+epYKg1WqgY1RFU6vM7rwcy5ImCXz Ch8g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1779371007; x=1779975807; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :x-gm-gg:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=EPFo4XkZ1koDAkbTIuHn+Ib8F99q0mxFlySsN+97FQc=; b=Fk6pM41XPEvk7WOwSDQ8xLSrTfmogIWRCnHT4FeP0tV5g+jsKfXlVqAPvCbxqVJySB w4cUFFvgdfwGMe0yNKWdv2fmPqJXQe/ycZ2Oqewp8Sy/LUygh9KWnsHZSC8QHAO5az7V DtUTGQMj0sJVoGgadOoTx4Je0UTOLCUDI0awvYFj9oe++rTaJdkuvVcHDr3+MHILaefp p+rTe1uhkFQbCJp212cX0XgkAcLbE6kY/wTiA5+fYCRpPStIh1quMzy5xHHY+btfMgTa OF1e5VvNCswyzI9qFAd3/mx+VevXtrGqsNs4857i1YWRH5wBM0pdZrqgAkaZvGKplvWD LuEA== X-Gm-Message-State: AOJu0YztyedHTcfKHf6oH2AREgs0rUsZdryYAVb5n9HMnMLe2JT5SuvH tr+0wpG/YILgid45mBJhRsyKzSUvD2YnM3QEk9CWPNqCpQCB6r7lbT2YcOQcLUEyatB6O1MEzq4 j++F626UlkGqG6f4/bZJA7UwhLFuybcHJuQ== X-Gm-Gg: Acq92OEKzkVeMMxqz341CDnOFyYB2vY/y418w4kRMxH3qUM1XV2e1fMVvibgBTN+p/7 NUS7ZWWnTqUqOS359QyEhP+/n2sGPoKzekpvshyj6uS4C+wN0ct9qSipmqDrgD2ughP+pbVQwsy aNiT+JlQaZU/m00XWrFtUC6JgxcwiwWAVdYpWvXEmuabe1kobhOLeyt8Ob7RHvyyGW5SQcXu+DS fHKbL9yGSmRqYI+uW3T9INTGJ3ewzpPuQIjjZQoJeoABX3gO7k5352spkNv5+Y1MNJVVIaJtttj YKvZR0PY X-Received: by 2002:a05:6870:c232:b0:43b:25d:ebe1 with SMTP id 586e51a60fabf-43b2ea864e9mr1820018fac.23.1779371007153; Thu, 21 May 2026 06:43:27 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Ron Johnson Date: Thu, 21 May 2026 09:43:16 -0400 X-Gm-Features: AVHnY4JiJ9NJEvmYeb-gLYKVyi-feP5EjMklnXYgqGFsMX-kf4si2tdwBbgO7DE Message-ID: Subject: Re: Replica servers hanging after the latest security patch update To: "pgsql-admin@lists.postgresql.org" Content-Type: multipart/alternative; boundary="000000000000ce1bdb0652541813" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000ce1bdb0652541813 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Thu, May 21, 2026 at 8:58=E2=80=AFAM recep g=C3=BCl 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 t= he > 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? --=20 Death to , and butter sauce. Don't boil me, I'm still alive. lobster! --000000000000ce1bdb0652541813 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Thu, May 21, 2026 at 8:58=E2=80=AFAM r= ecep g=C3=BCl <recep_29_@hotmai= l.com> wrote:
=
Hi;

=E2=80=82=E2=80=82=E2=80=82=E2=80=82After applying the latest published Pos= tgreSQL security patches, we experienced issues on our replicas. We first u= pdated two of our replica servers running pg14 and pg15. The replica servic= es were running during the binary update. After the binary update was completed, we restarted the relevant replica services. Upon observatio= n, we noticed that the replicas were waiting at the last checkpointed redo = file during the startup phase. Meanwhile, although we performed the same op= eration on our other servers, we did not encounter such an issue on those. Has anyone else encountered a si= milar problem?
=C2=A0
1. What = specific=C2=A0minor 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!
--000000000000ce1bdb0652541813--