Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication)

From: Greg Sabino Mullane <htamfids(at)gmail(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: Bala M <krishna(dot)pgdba(at)gmail(dot)com>, chris+google(at)qwirx(dot)com, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication)
Date: 2025-10-24 12:53:47
Message-ID: CAKAnmmLDfgYRX8oC6S7jKZyovv6wy72Twq6-hx315GKTowMjew@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Oct 23, 2025 at 11:49 AM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)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
are on version 11 (eleven!) so obviously major upgrades are a rare thing,
so might as well buy themselves another year. :)

Cheers,
Greg

--
Crunchy Data - https://www.crunchydata.com
Enterprise Postgres Software Products & Tech Support

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2025-10-24 12:54:06 Re: Why is this query touching 4gb of buffers?
Previous Message hubert depesz lubaczewski 2025-10-24 11:19:03 Re: Why is this query touching 4gb of buffers?