Feedback-ID: i76984098:Fastmail
Message-ID: <c319a69b-a667-4536-9aba-d75a4235b786@aklaver.com>
Date: Fri, 24 Oct 2025 07:54:02 -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: Greg Sabino Mullane <htamfids@gmail.com>
Cc: Bala M <krishna.pgdba@gmail.com>, chris+google@qwirx.com,
 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>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <CAKAnmmLDfgYRX8oC6S7jKZyovv6wy72Twq6-hx315GKTowMjew@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/c319a69b-a667-4536-9aba-d75a4235b786%40aklaver.com>
Precedence: bulk

On 10/24/25 05:53, Greg Sabino Mullane wrote:
> On Thu, Oct 23, 2025 at 11:49 AM Adrian Klaver 
> <adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>> 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. Given
>     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, 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.

> are on version 11 (eleven!) so obviously major upgrades are a rare 
> thing, so might as well buy themselves another year. :)

Major upgrade being the operative phrase here. The OP and company are 
going to face enough new hoops to jump through in the move from 11, 
adding a new release to that mix is pushing it a little too far in my 
estimation.

> 
> Cheers,
> Greg
> 
> --
> Crunchy Data - https://www.crunchydata.com <https://www.crunchydata.com>
> Enterprise Postgres Software Products & Tech Support
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com