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

2025-11-07 Thread Bala M
across large tables. Thanks & Regards Krishna. On Thu, 6 Nov 2025 at 23:53, Adrian Klaver wrote: > On 11/6/25 09:04, Bala M wrote: > > > > Hi Adrian, Thank you for your response. Please find the requested > > details below: > > > > > Since you hav

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

2025-11-07 Thread Bala M
arted is that not already to late for this? Yes We are currently in the *testing phase* and validating with the above parameters. However, the replication process has been *extremely slow — it’s been running for the past 5 days* with limited progress. Any specific tuning recommendations or best p

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

2025-11-05 Thread Bala M
Thank you all for your suggestions, Thanks for your quick response and for sharing the details. After reviewing the options, the logical replication approach seems to be the most feasible one with minimal downtime. However, we currently have 7 streaming replication setups running from production,

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

2025-10-22 Thread Bala M
Hi Team, We are facing an issue related to index corruption after migrating our PostgreSQL 11 setup from *RHEL 7* to *RHEL 9* using *streaming replication* (base backup method). After bringing up the standby on RHEL 9, we observed that certain tables are not returning results when queries use ind