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.94.2) (envelope-from ) id 1vCJHi-00Bw22-F3 for pgsql-general@arkaria.postgresql.org; Fri, 24 Oct 2025 15:00:53 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1vCJHh-00HGM4-9m for pgsql-general@arkaria.postgresql.org; Fri, 24 Oct 2025 15:00:52 +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.94.2) (envelope-from ) id 1vCJHg-00HGLu-VH for pgsql-general@lists.postgresql.org; Fri, 24 Oct 2025 15:00:51 +0000 Received: from mail-oa1-x29.google.com ([2001:4860:4864:20::29]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vCJHe-003Ya7-07 for pgsql-general@lists.postgresql.org; Fri, 24 Oct 2025 15:00:50 +0000 Received: by mail-oa1-x29.google.com with SMTP id 586e51a60fabf-3c988d13473so1339797fac.1 for ; Fri, 24 Oct 2025 08:00:49 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1761318049; x=1761922849; 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=p/f1DRZhqa5bGLZ+t5OhUF/8utLnfNtIJjiuB3MrzEc=; b=arWLZF7m4zALYkHctOjjwKAzKldU67dKssWvKzDaFrOGh+huciq8EZRd3LxclxbR4X u/D8kgakBHApEzoPvoWPMHRg8bQMW+9fFRxbB9XrWuYG1BFzU5Xcbw6zt+IL8K7Gb6hk QJPeYhjy4rfsETGOV3rNlEEtBwLnjKkIHHrQO2EiXdm0l7lAC/0hMQMu4fKGQn3Z+Wrf iqY41KhMl+REbXVSNbTHhYxZpdmJiB/BU5vnWbkiM7ON9c/9tbsuGhjRQ3hFIwAfzqZM he4S/mLQiyfMeVVjO2UWQ1PNqKxGJV0IcOY7/QQ5GWxy5BTkMJO4Nt/cVG5f1+tunFeF UO9w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1761318049; x=1761922849; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=p/f1DRZhqa5bGLZ+t5OhUF/8utLnfNtIJjiuB3MrzEc=; b=Tq++AUM20Rjzy9EH4O5Q0qpSNfFzeOcNZsx374PnXAtOB7i34kgpnRbVl8hRetD0nl Z6BVghsoYI81YpLyESj6G9yVI6Lz22FVmn2e2zXHvCSjXA6VgjOcIDkok8by1rDSQEWW 6vlTUS9ba7fqkGNBwpTt1X/qP58/RPxi4sdt2YBhi0puyrv9b69VM0aG56SQ46enpiCS lzRluR580n5LW3fIDTh5B95ism76nFA66U8RCYZX4KhDZHcZcuD17HNTQhJrMsVfUa1U Qkwg+f+brRj/HL3l9OmVbuZm2GYj4VDjW7am/gHbObrWm9YJz6XvE3mba+qUoAu5Mdml 6YEA== X-Gm-Message-State: AOJu0YwXUuP/lcc64fVx0wdR4sUP3XzDjGguYe53SRrjqjComlCAuMpb 6SEi0SDWC5ECbHpHllkw/U5ncrInKNHFT9DP6HC6INM+zQB1vUi1vl6wSjrbxClK+1LWIG3F7ot CL2fVoNIJgpCKaOseUAx5hXsgCkpaO9ReTNz4 X-Gm-Gg: ASbGnctNsNSC0cQZ4LSENcEJFxqiMOvBcVOk3qcrIFPbI+XEvWPvXEWuwsdMXSk3xwN r7W8eztDLKLnTNy8BV5Axh0lZ6ilUcdJB20J0raN7Y2DOmA9K9arWiSCUkgYq2CbgRTpVeOeFWd zYIKvEiABuiiJa4IgxFNhafRYCjSldga+F+XInKDhY9CoHN16ckKKVV2JMFZrQ4XpyVH9XeZ16Z gWqYMcNElNgCMoH0qYhH3C7Y7EoLhe1GB31eA20H/ZgHzLuvVAiI3au/1rU2KLOC5uvMKwh X-Google-Smtp-Source: AGHT+IG21olXZjesXSgze0fg68Ndy9QaT82RTecwbJ5EA8ZFjoGiGfprKu06A8yqFtoNU0HyT6Fgl2BJcknItc5dtGc= X-Received: by 2002:a05:6871:6e17:b0:3c9:c364:a47c with SMTP id 586e51a60fabf-3c9c364b50emr7064225fac.32.1761318048430; Fri, 24 Oct 2025 08:00:48 -0700 (PDT) MIME-Version: 1.0 References: <8d340169-b500-4048-a665-0700813313a3@aklaver.com> In-Reply-To: From: Ron Johnson Date: Fri, 24 Oct 2025 11:00:35 -0400 X-Gm-Features: AWmQ_bno_VtqE2hr503daLX_CH0M2bYwcFWxKywezAAQlblJtxMZq9ICCy1wBtk Message-ID: Subject: Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication) To: "pgsql-generallists.postgresql.org" Content-Type: multipart/alternative; boundary="0000000000009d0c100641e8d09d" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000009d0c100641e8d09d Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Fri, Oct 24, 2025 at 10:54=E2=80=AFAM Adrian Klaver wrote: > On 10/24/25 05:53, Greg Sabino Mullane wrote: > > On Thu, Oct 23, 2025 at 11:49=E2=80=AFAM Adrian Klaver > > > wrote: > > > > I am not sure version 18 would a good choice at this time, it has > > just been released and has no bug fix releases against it yet. Give= n > > the > > other complications in your upgrade, OS upgrade and multi-version > > jump, I don't think you want to add a brand new version to the mix. > > Postgres > > 17 on the other hand has been out a year and has had 6 bug/security > > fixes. It is probably a more stable target version. > > > > > > I hear your concern, but I'm pretty confident in v18. Additionally, the= y > > Which is pretty much the criteria for a GA release, confidence that it > is ready to face the general public. That is not the same thing as it > being guaranteed bug free. Only time facing the manipulations of said > public proves how many bugs there are and how bad they are. > "Never trust a .0 release with important data" is just as true in 2025 as it was in 1985. That's a chicken and egg problem, though, isn't it? --=20 Death to , and butter sauce. Don't boil me, I'm still alive. lobster! --0000000000009d0c100641e8d09d Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Fri, Oct 24, 2025 at 10:54=E2=80=AFAM = Adrian Klaver <adrian.klave= r@aklaver.com> wrote:
On 10/24/25 05:53= , Greg Sabino Mullane wrote:
> On Thu, Oct 23, 2025 at 11:49=E2=80=AFAM Adrian Klaver
> <adr= ian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>> wrote:
>
>=C2=A0 =C2=A0 =C2=A0I am not sure version 18 would a good choice at thi= s time, it has
>=C2=A0 =C2=A0 =C2=A0just been released and has no bug fix releases agai= nst it yet. Given
>=C2=A0 =C2=A0 =C2=A0the
>=C2=A0 =C2=A0 =C2=A0other complications in your upgrade, OS upgrade and= multi-version
>=C2=A0 =C2=A0 =C2=A0jump, I don't think you want to add a brand new= version to the mix.
>=C2=A0 =C2=A0 =C2=A0Postgres
>=C2=A0 =C2=A0 =C2=A017 on the other hand has been out a year and has ha= d 6 bug/security
>=C2=A0 =C2=A0 =C2=A0fixes. It is probably a more stable target version.=
>
>
> I hear your concern, but I'm pretty confident in v18. Additionally= , they

Which is pretty much the criteria for a GA release, confidence that it
is ready to face the general public. That is not the same thing as it
being guaranteed bug free. Only time facing the manipulations of said
public proves how many bugs there are and how bad they are.

"Never trust a .0 release with i= mportant data" is just as true in 2025 as it was in 1985.
That's a chicken and egg problem, though, isn't it?

--
Death to <Redact= ed>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
--0000000000009d0c100641e8d09d--