On 10/23/25 07:51, Bala M wrote:
Hi All,
Thank you for the valuable responses regarding the *index corruption
issue* we observed during our test migration of a *PostgreSQL 11*
environment from *RHEL 7 to RHEL 9* using *streaming replication*.
Based on the replies, I understand that.
Suggested upgrading to a newer PostgreSQL version (e.g., v16 or v18)
and using *logical replication* or *pg_dump/restore* for a clean
rebuild.
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.
--
Adrian Klaver
[email protected]
