Feedback-ID: i76984098:Fastmail
Message-ID: <2b09033b-d375-488d-9188-17a0f214e823@aklaver.com>
Date: Fri, 24 Oct 2025 08:51:17 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Index corruption issue after migration from RHEL 7 to RHEL 9
 (PostgreSQL 11 streaming replication)
To: Ron Johnson <ronljohnsonjr@gmail.com>,
 "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
References: <CAJ4rSwspyYBppQS701C=BVFX2yrP1JErgDCZXbC15BQh2zAS1Q@mail.gmail.com>
 <CAKAnmmK47O_rYDB4iPe=K3QiqzJcCnnxCoYs_40Q1YWb=x0nDg@mail.gmail.com>
 <CAJ4rSwvsRJhwfuem0vsws1WwRZPN8Ju2Nw0e0Oc2j7n=MXUhMg@mail.gmail.com>
 <8d340169-b500-4048-a665-0700813313a3@aklaver.com>
 <CAKAnmmLDfgYRX8oC6S7jKZyovv6wy72Twq6-hx315GKTowMjew@mail.gmail.com>
 <c319a69b-a667-4536-9aba-d75a4235b786@aklaver.com>
 <CANzqJaBq3hcAUXhSi5ar0=Gw0QxqfmD_E47dxHAex9_D3Yv-WA@mail.gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <CANzqJaBq3hcAUXhSi5ar0=Gw0QxqfmD_E47dxHAex9_D3Yv-WA@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/2b09033b-d375-488d-9188-17a0f214e823%40aklaver.com>
Precedence: bulk

On 10/24/25 08:00, Ron Johnson wrote:
> On Fri, Oct 24, 2025 at 10:54 AM Adrian Klaver 
> <adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>> 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. Though the issue in this case is deciding what part of the 15 
TB you would test against or finding the resources to replicate the 
entire setup.


-- 
Adrian Klaver
adrian.klaver@aklaver.com