Re: Reindex doesn’t not working replica nodes

Поиск
Список
Период
Сортировка
От Scott Ribe
Тема Re: Reindex doesn’t not working replica nodes
Дата
Msg-id 4A474738-14C3-46DA-AE54-BF9A308D0A85@elevated-dev.com
обсуждение исходный текст
Ответ на Re: Reindex doesn’t not working replica nodes  (Mohammed Afsar <vmdapsar@gmail.com>)
Ответы Re: Reindex doesn’t not working replica nodes
Список 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 по дате отправления: