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 1vCSjq-00ENaE-SH for pgsql-general@arkaria.postgresql.org; Sat, 25 Oct 2025 01:06:34 +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 1vCSjo-001jWM-P8 for pgsql-general@arkaria.postgresql.org; Sat, 25 Oct 2025 01:06: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.94.2) (envelope-from ) id 1vCSjo-001jWD-EH for pgsql-general@lists.postgresql.org; Sat, 25 Oct 2025 01:06:31 +0000 Received: from mail-lj1-x235.google.com ([2a00:1450:4864:20::235]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vCSjk-00452X-35 for pgsql-general@lists.postgresql.org; Sat, 25 Oct 2025 01:06:30 +0000 Received: by mail-lj1-x235.google.com with SMTP id 38308e7fff4ca-378d50e1c82so27436401fa.3 for ; Fri, 24 Oct 2025 18:06:28 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1761354388; x=1761959188; 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=ltk2yJNobE1zXbd8FR1cnvKQDVatPYDT0bOteFGoCgE=; b=cyGhJN4LNooj1F6gCkVTWX9udNJkvSOxcwY0Efae8C+g0cr+ch4HFO14FUeEG2Y3vi A8LjPZ+92pG8ddZNrFTPvQNkHCTiqBBpf90eOUCHO7UO0rKPMO5WgnikHm0S8zRTxvzU Sjj9Z4nHX7mSobJqzZjZJZwY1nrwrKotzzFXvV8WxYFewWmtuMocC+CHArXieSEePo5v GqLLgrej9BaqDYpVFfd9TyJ6WVgwcnt+Qo/gqSKNG0PyiaasR4K8NLDFYZsojLEn5Enq hu0Q5GdJx19YIcHiV/bQvIm9s/KksE+6s8VY5DL9Zfs412kiA/tjNH0/5xRx/s56/0lB Fjvg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1761354388; x=1761959188; 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=ltk2yJNobE1zXbd8FR1cnvKQDVatPYDT0bOteFGoCgE=; b=b2oWPVpfZdWYKCQ8vZxNBQx9YY0eh05GkZ9dOj2DR1CUgWmWjKIUq4xHg57nsArFwI J8JZQUHLIw/4K8iYmoMsSw6OUU35q4bmQeY+X4UK+q7+g45m3J7yv3GPLPrOgi5OcCjv AWzMDSqMI5vHmCtSTN77LpASLgdT8HC6AVcOE5rn0/CVaUvVMKZyHetMwe3OcRMTKezT IInrfSQwTm8mZfbUnK7Fr/Ll+HH5qOq5yPEVP6j94hFNIpo9ri5W2B+yw2meI4gojPEF 3HSTPYy3VGEsBhtPSOgjZN8g78boUZVL0MqmixTTWWhbfQz1C/92yNgZArd2JpqQQP26 ZfSQ== X-Forwarded-Encrypted: i=1; AJvYcCW31T+dt27f5LCIjkhILMAG634iYXmm/PDo8pIRaBuhLB/16YkdfNSGBj1dnld7mdAT6g+/b4zDtUPo/CSf@lists.postgresql.org X-Gm-Message-State: AOJu0Yz9l1mBzCXaLpF1NomBUiYuBZy8bzRucoyDKQ0mFX4i1hkx/XXj gqusneApCUVWVGAB6dKwxaRRDKEzdPeHFsKKY9BhjnktUzBWkI0B+JsmDt/a73x55V0OSmT9igm VoJvZ+nXTbrfNxHMIafC/7wsikgIO+lw= X-Gm-Gg: ASbGnctLm6hnG2r0hVJmhd7nvPjX/hc/hxfKB/ZT7Gl9GuqvYAZhQC5o0CqOWRPWM1J OndvFAD6R8wFe4rEhKEbRtuYdD2TLPCAFOlh/BBuaqyoOCogVQ14OQEyVrDUflEjh+DHB6o2X/1 LOEMgzt8nB+X5HhVKlOmcE8a0DFMIK9eZ7yY3BBtkdGuMhgLodAZnzDjKlUsp/Lgo8UF1F7Obki Mi5i4Za8CguLXkHQmeLyce+i5+UobRx03wGyj4IEAG7Qcx7y+5fkB3aB5XSZpGvMyUHMC0OgYIA +GVsAkgBA1P0on8jVKzZSJEiM/3gP8puq/gLOIT3hKnW1Hbe4yM= X-Google-Smtp-Source: AGHT+IHgTOoxCh7/tpFM5kzJI3wxPb22O/wb86lnVjYWtuLrjyJKcZwDQZEEua1YYRTheJn+zWcvUe/z/+sQ/ONFWBU= X-Received: by 2002:a05:651c:12c3:b0:375:f6bf:880 with SMTP id 38308e7fff4ca-377978aefe5mr102974231fa.19.1761354387238; Fri, 24 Oct 2025 18:06:27 -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: <4babadbd-cc61-43e7-b7fb-3053dcdaadac@aklaver.com> From: David Rowley Date: Sat, 25 Oct 2025 14:06:15 +1300 X-Gm-Features: AWmQ_bkcSXiNnM6-JhHz_rQw2Mbh6ik6Y_Uxc3-oWqpbTwGUvOHrZRlXISbcy3Q 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 13:40, Adrian Klaver wrote: > > On 10/24/25 15:37, David Rowley wrote: > > On Sat, 25 Oct 2025 at 04:51, Adrian Klaver wrote: > >> > >> On 10/24/25 08:00, Ron Johnson wrote: > > 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. > > 1) From previous posts to this list folks have mentioned their > organizations prohibit touching anything less then a GA or maybe a late > RC. That comes from on high and I doubt the folks issuing the orders are > on this list. That seems bizarre to me. If they want new releases of PostgreSQL to be as stable as possible as early as possible, then beta and RC are much better times to test than .0 is. > 2) The attitude comes from lessons learned in the School of Hard Knocks. > Until someone or someones can guarantee a new GA release will not eat > your data or spring security leaks then the prudent thing to do is wait > to see what happens when it hits the world at large. I learned this > lesson, pitfalls of jumping into something new, across fields outside of > software as well. In other words 'new and improved' is not always the > case, see 737 MAX as case in point. I don't see why this reason is applicable at all to my statement. I didn't state that everyone should go and run with .0. I said we shouldn't encourage people to test beta and RC versions, as if they don't do that then .0 won't be as stable as if they did test (and report issues). It seems like simple cause and effect to me. > 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. David