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

On 10/22/25 11:18, Ron Johnson wrote: On Wed, Oct 22, 2025 at 1:35 PM Greg Sabino Mullane > wrote: On Wed, Oct 22, 2025 at 6:53 AM Bala M mailto:[email protected]>> wrote: * PostgreSQL Version: 11.15 Ouch! Not only is the major v

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

On Wed, Oct 22, 2025 at 1:35 PM Greg Sabino Mullane wrote: > On Wed, Oct 22, 2025 at 6:53 AM Bala M wrote: > >> >>- >> >>PostgreSQL Version: 11.15 >> >> > Ouch! Not only is the major version end of life, but that's not even the > latest revision of 11. > Do pre-built PG11 binaries even

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

On Wed, Oct 22, 2025 at 6:53 AM Bala M wrote: > >- > >PostgreSQL Version: 11.15 > > Ouch! Not only is the major version end of life, but that's not even the latest revision of 11. At this point, you should use logical replication to migrate from your v11 to a shiny new Postgres v18 on you

Re: typo in the license ?

On 2025-Oct-22, Álvaro Herrera wrote: > 2. note that this file is not a license, but a license template. If you > want to use this license, you're supposed to replace those keywords with > the name of your organization. I would think that if you use the template > and replace $ORGANIZATION with

Re: typo in the license ?

On 2025-Oct-22, Achilleas Mantzios wrote: > Greetings from pgconf eu 2025 , Riga, Latvia! > > While attending Karen Sandler's presentation on : The Foundation of Open > Source: Why Software Freedom? , I just looked up the license here : > > https://www.postgresql.org/about/licence/ and then here

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

On 10/22/25 02:03, Bala M wrote: 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). Postgres 11 is two years past EOL per: https://www.postgresql.org/support/versio

Re: typo in the license ?

On 10/22/25 00:44, Achilleas Mantzios wrote: Greetings from pgconf eu 2025 , Riga, Latvia! While attending Karen Sandler's presentation on : The Foundation of Open Source: Why Software Freedom? , I just looked up the license here : https://www.postgresql.org/about/licence/ and then here : htt

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

Hi Krishna, This might be due to the upgrade in glibc between RHEL7 and RHEL8, which includes updated collations that change sort orders and thus invalidate existing indexes, forcing them to be rebuilt (on a RHEL>7 system) if they contain any values which sort differently under the new collation t

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

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

typo in the license ?

Greetings from pgconf eu 2025 , Riga, Latvia! While attending Karen Sandler's presentation on : The Foundation of Open Source: Why Software Freedom? , I just looked up the license here : https://www.postgresql.org/about/licence/ and then here : https://opensource.org/license/postgresql the