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 1vCQQH-00DujM-0y for pgsql-general@arkaria.postgresql.org; Fri, 24 Oct 2025 22:38:12 +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 1vCQQF-001HS9-Tr for pgsql-general@arkaria.postgresql.org; Fri, 24 Oct 2025 22:38:10 +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 1vCQQF-001HRz-IW for pgsql-general@lists.postgresql.org; Fri, 24 Oct 2025 22:38:10 +0000 Received: from mail-lf1-x12d.google.com ([2a00:1450:4864:20::12d]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vCQQD-003bs3-09 for pgsql-general@lists.postgresql.org; Fri, 24 Oct 2025 22:38:09 +0000 Received: by mail-lf1-x12d.google.com with SMTP id 2adb3069b0e04-592fcf7a1ceso1347367e87.1 for ; Fri, 24 Oct 2025 15:38:08 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1761345487; x=1761950287; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=Ni4gXwiRrSpenfHB29bbBBTG4O7BliOP3gnBMS/mbBw=; b=ZfdAIbvK4T26+aOCfbvbgXEtzD92jeS198Qox8VtevdxFNujVubj7kGs4rWI8QGNO5 L/qyJza6vfhYQ9LxTW+bSifz245Jrll189qOltGWcP+WSXLxaD26/KVoUaScXg+Vk00j XxNzy4sDH33riIoRqPdi/x/0F27Xa4FSDtJaonJFCdbd9RJFaOHczASwryDw5MLlPyuO DlluuXK/jL3Lv79E6VxGKMKi8+Q+K2xl/UVuAWvo8mMMXPRTC7O/gf4E8t5Tnubas8D5 mBKbYjR10xEJWs17YAP1Wd4Q2/vmr7xkVfF9XyBwIKzNRiWDP3qwYYEbFR8sR8qQaTHo oMRQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1761345487; x=1761950287; h=content-transfer-encoding:cc: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=Ni4gXwiRrSpenfHB29bbBBTG4O7BliOP3gnBMS/mbBw=; b=pX8yV28aH6mV0mvYBSteXjD58A+HOQfCkbbIRoZBGcSw13yvnoo1BMCO7zSrM47Y9R uB2plTdLG1YDFGxZM2hrXM3dNrSIMGfPfw2qr1mvImxfUujySYN2JPRxCkQrjTGEG6mD o+qoyB41Er64d1DR7NaEoRP3RRr0R6wVDI+Cc3teWS5A6aaRSxaIGAYPRcdk+1bScaGj JVsg/v0zP8h/u85+peE93tQy2lJob8y9KA/RiAeVyZU8gxsp4EGAzj5VGr9wxc4CAB3m yXePN/oUUvfcOe1OVvIWRtz6uP2OituhiJmSVBtXffkf42l04zmQ6N1J8nOqfTKJTmSl Nf9Q== X-Forwarded-Encrypted: i=1; AJvYcCVNtBcUtAZja6jbeuT78H7j3f99nI57HrbYaNViI3DbpSiaMOG3leDaDMPd++7MLt4MF7Yw6o0/mUMWQoYZ@lists.postgresql.org X-Gm-Message-State: AOJu0Yz2Z7sle67UbdTOkyKsd/PPBoZSfA7jU2ldgb4ONoAj9R50ZEah CNBs6e6qt9dBtiZJZcQHVjF5YmA8ncztcXNkJc6AN8kGTeZlLO+7k7qevcGzJlnQ3hz34NWdTIS 4Z7ayfxFkID2a87RxTxKwGnaDG9xaFs8= X-Gm-Gg: ASbGnctadNw0xUghRFe7WeZEhC97i+JHe4fAHCjxDMOWpsI3MkpELj2M3/OJMx7d/jX vR7TtFMLqlP7RGVYnUzevALLLYm5Fr+jfMqXUiE1EFFWVxEmK4DxyYIpJCRkNP5CvUP/It7yI+K SOgSIj2sQIR8zvyK7unte9osnN0JFU5q3pB0e79P/cJIL/swh0bqQALUWP9ycLNdUDCMJ+2BKYH FFN3a85hjlXGAq2ZO1RfHVEMOJFQIgIZmsst8sPQiOjS1vTm4NvGZMLLujEHadJJXmMcCY6YJ1o gdk1oYnbG952wrS4A/i4yZyBCfWALhOz5IO3Rk3eFyuN0I7UNcg= X-Google-Smtp-Source: AGHT+IHQunbbhX5zo1OwTptfBTEAwq+WHj8J0ItOGN8EQBQDmxCMYsIOrGSUI14dQgibR91fPAPo72sJsgd5riYS7DU= X-Received: by 2002:a05:6512:224f:b0:578:ed03:7b87 with SMTP id 2adb3069b0e04-592fca55da0mr1367628e87.33.1761345487100; Fri, 24 Oct 2025 15:38:07 -0700 (PDT) MIME-Version: 1.0 References: <8d340169-b500-4048-a665-0700813313a3@aklaver.com> <2b09033b-d375-488d-9188-17a0f214e823@aklaver.com> In-Reply-To: <2b09033b-d375-488d-9188-17a0f214e823@aklaver.com> From: David Rowley Date: Sat, 25 Oct 2025 11:37:55 +1300 X-Gm-Features: AWmQ_blIoIwaBCjNDNfe50iLOotr_vFxGTZEJmcH24dr5bGlwbkdKIRI4JlXaDA Message-ID: Subject: Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication) To: Adrian Klaver Cc: Ron Johnson , "pgsql-generallists.postgresql.org" Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Sat, 25 Oct 2025 at 04:51, Adrian Klaver wro= te: > > On 10/24/25 08:00, Ron Johnson wrote: > > On Fri, Oct 24, 2025 at 10:54=E2=80=AFAM Adrian Klaver > > > wrote: > > > "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? > > There is nothing stopping you from setting up a test instance and > kicking the tires on a new release to see if your setup will work > correctly. I'd say it's exactly that attitude that causes people to think .0 should be avoided. Beta versions are meant for test instances. It'd be good if people encouraged their use more often rather than pushing people to defer til GA. David