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 1vCWFK-00F7xa-Uv for pgsql-general@arkaria.postgresql.org; Sat, 25 Oct 2025 04:51:18 +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 1vCWFJ-002FGx-Uc for pgsql-general@arkaria.postgresql.org; Sat, 25 Oct 2025 04:51:16 +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 1vCWFJ-002FGo-If for pgsql-general@lists.postgresql.org; Sat, 25 Oct 2025 04:51:16 +0000 Received: from mail-lj1-x234.google.com ([2a00:1450:4864:20::234]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vCWFG-003eKB-1v for pgsql-general@lists.postgresql.org; Sat, 25 Oct 2025 04:51:15 +0000 Received: by mail-lj1-x234.google.com with SMTP id 38308e7fff4ca-3696f1d5102so24009631fa.3 for ; Fri, 24 Oct 2025 21:51:14 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1761367871; x=1761972671; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=jLDpi7bC/284+zumRWlfCEwugYZIKs73uIWKZ9OYfDs=; b=TCU4lHo1OZwo0EWOjS0xt1dI31q2kHjgtvJmqNO18u5tSjxRPWwyqrW+v8/fWfXx87 lJwDEbZ6GacerebozM675nC5K3DYHjnupn5ASvuIttAkUt8DF3KguDPDQu8TD497u5GG gCeTeB+TW+ivoG6aBU3FDqtXWNqp8nX1a3WhMJgUmaviXACbSi6Ulc656vV+Y0VI+LlB kgEkYzK//GXufXQLTMgSnlRThCnRHtYMbNL+8mnDISZAHTL1TOnUTxfDOwwDPFokVA9L b5NkUezqHfyqoyL118481q9oHXR7nNBBHJ+q68CfWKxhbuFgFHf6omk7mAJSfBj4yADN hr4A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1761367871; x=1761972671; h=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=jLDpi7bC/284+zumRWlfCEwugYZIKs73uIWKZ9OYfDs=; b=MWl9GJGsQYA5/pVQrrvgxQnO2Tl8FOaEx6CIZBbJ6kqutMI7J0hFeEFRm2mczt5kCo +yjeVr4SsP2YG0DOCjVD7Hps7tZypbiQ0emDrcSLs/fDfaGf6oSZSTzE++hxCHA8igch 8fd57YSZXh8/un8ZnR6qwis876wgEh2QEIclqOpelvVy4wRSwb2d6B66OVEj3ywHDNuI uOAIF5+1eygU2trKubqv2Po22EqOQlaS/KUNdkfLxaD2h3Mj7COQMEO1RD5URMcAcR4T DV1FWLrgmNFRUJRi9uOX+WZrJ5dt/XNQkIEX3rUpvwg79aI87tnUlI9AFZFMfE5K2BM/ 71ww== X-Forwarded-Encrypted: i=1; AJvYcCWYnwee04oBsji3G0lQ4wRdLPjSj+d3DcbOhvqv8OnTLWVqiFL+86cMYvBYirUwiomE50hhbfscDW4PA0Cf@lists.postgresql.org X-Gm-Message-State: AOJu0YwDGS8xllx86EiHdQytbPWdyueMv62Hm3ZRWaL7tkMXXF9XEcwr KuaDkXmiylUhwnCF2PKB5UWFeQGBBYqZ8GxzYIFoS4P+VOflGkteEMXyFnBC8kxJdlfw0gDTuNV GjY7cXNjo45L95/HSxB0K/rAyR79L3C4= X-Gm-Gg: ASbGncu7sSbS5mJwTmAyQPPbbSWVIBIB795JWlERAP2TlkAdi4ifb6m0y5Xbu+AE5Qr xGrQdgTFX9DFj8l4RLSDw83gp2tgT7YX16hFtE6lmmvYSlfMPC+a6vt4NTp/uV2J9DCYL99O1cF 7s88iSgRtDtjUtXTW5KrK1qx7VIFvLEbBMlZMrIrb27nYJSWvtMn9O9C3eH+tGEBusXREycd28e hNBouk+p3XilwKZ5QwpJQyFV9X2nPQZVvLqqMN6d9AVv594UE9vBXx/txUbny74+GWpDkWHwTEx iIHPdUBEz19I3uF3y6Y66rq9L2Ovoc1Mxsx/7nIBPonxfKvYx27ra+USOnRoRQ== X-Google-Smtp-Source: AGHT+IEzY2geXYypAKC6n3ZBmE7R2eX9oM1Iyq6pW5sr2GrxOqnmFhGBfbnGzFJPIR46qs4oeeIRlS4rTdkoxilEjJ0= X-Received: by 2002:a05:651c:a07:b0:378:dc57:eda6 with SMTP id 38308e7fff4ca-378dc57f123mr23882661fa.10.1761367871146; Fri, 24 Oct 2025 21:51:11 -0700 (PDT) MIME-Version: 1.0 References: <8d340169-b500-4048-a665-0700813313a3@aklaver.com> <2b09033b-d375-488d-9188-17a0f214e823@aklaver.com> <4babadbd-cc61-43e7-b7fb-3053dcdaadac@aklaver.com> In-Reply-To: From: David Rowley Date: Sat, 25 Oct 2025 17:50:59 +1300 X-Gm-Features: AWmQ_blbt25rNcS8HixYpJrm5-XKf-B-g3bfJxCGLKUkCdAVMgNc4lP9Tvz3d9k 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" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Sat, 25 Oct 2025 at 17:36, Adrian Klaver wrote: > I am not following, from your previous post: > > "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" > > That seems to be the opposite of what you say above. I think you think that because you misunderstood what I said in [1]. I'll rephrase it for you: Because people promote the .0 as not yet production-ready, it means that fewer people bother testing with beta and RC versions. Lack of beta testing is what causes .0 to contain more bugs than it otherwise might, so my suggestion is that we should be encouraging people to run beta and RC in their test environments to try to increase the stability of .0 versions. I struggle to imagine anyone with any respect for the PostgreSQL project disagreeing with that, so I suspect you and Johnson must have misunderstood. Also, I was highlighting that I agreed with the paradox pointed out by Ron. Clear? > >> 3) Progress happens and you need to keep up. A little caution is good > >> thing though, especially if you are the one who is being held > >> responsible for any adverse outcomes. > > > > We're talking test servers here. I assume they can be recreated > > without too much trouble. > > Yes, but the OP was talking about upgrading a production database > directly to 18. That was what my reply was referring to and what I was > counseling against. You should pay more attention to the quotes above my reply. I don't see any of my replies quoting anything about upgrading a production database to 18.0. David [1] https://postgr.es/m/CAApHDvo5pLSwD4JVxW8t94Vc88djKrrSyrL-GbQJ=hb2NVT5zg@mail.gmail.com