Re: Reindex doesn’t not working replica nodes - Mailing list pgsql-admin

From Scott Ribe
Subject Re: Reindex doesn’t not working replica nodes
Date
Msg-id 4A474738-14C3-46DA-AE54-BF9A308D0A85@elevated-dev.com
Whole thread Raw
In response to Re: Reindex doesn’t not working replica nodes  (Mohammed Afsar <vmdapsar@gmail.com>)
Responses Re: Reindex doesn’t not working replica nodes
List pgsql-admin
> On Aug 16, 2024, at 7:08 AM, Mohammed Afsar <vmdapsar@gmail.com> wrote:
>
> We are using streaming replications but still reindex is not working source db has 11.15replica has 11.11 PostgreSQL
version.

This is not your problem.

As you understand, I think, with streaming replication all files, including indexes, are exactly duplicated on the
replica.If the OS on the two sides have different glibc versions which have different collations, then the index
structureof the primary will be a corrupted index on the replica. You have to fix your OS version incompatibility, or
moveto a version of postgres which can use ICU collations and make sure that library is compatible on both sides. 




pgsql-admin by date:

Previous
From: Mohammed Afsar
Date:
Subject: Re: Reindex doesn’t not working replica nodes
Next
From: Mohammed Afsar
Date:
Subject: Re: Reindex doesn’t not working replica nodes