MIME-Version: 1.0
References: 
 <CA+6HdutGU9Au=ADaa+Q6jp=HGXFeUrtBPcfdHKK2fLdeKnd+Tg@mail.gmail.com>
 <CAF4emOmk7ZOqQ0+0FDzaPY+ZkisMYVa4QAhC8MjdQdr2MQViTA@mail.gmail.com>
 <CAJ=80GUOozWnm14_vJ3MccTZ9LNJ7d6Rsd_bkszMr=MrWdFm-w@mail.gmail.com>
 <CA+6HduuHBaHju0xkuBUkOz5dYkkrotgyGTdt1dj75Et1NECeoQ@mail.gmail.com>
 <4A474738-14C3-46DA-AE54-BF9A308D0A85@elevated-dev.com>
In-Reply-To: <4A474738-14C3-46DA-AE54-BF9A308D0A85@elevated-dev.com>
From: Mohammed Afsar <vmdapsar@gmail.com>
Date: Fri, 16 Aug 2024 19:18:44 +0530
Message-ID: 
 <CA+6HdusYzHKxoUPHGrf6wVjBMe3Luo6S5iy+j9Dte+qija-0_w@mail.gmail.com>
Subject: =?UTF-8?Q?Re=3A_Reindex_doesn=E2=80=99t_not_working_replica_nodes?=
To: Scott Ribe <scott_ribe@elevated-dev.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000702157061fcd381c"
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2B6HdusYzHKxoUPHGrf6wVjBMe3Luo6S5iy%2Bj9Dte%2Bqija-0_w%40mail.gmail.com>
Precedence: bulk

--000000000000702157061fcd381c
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Got it thanks for the deep dive explanation.Scott =F0=9F=91=8D=F0=9F=8F=BB

And parallel  we got below error also included OS incompatibility?

postgres[265938]: segfault at 18 ip 00000000004cf11b

Regards,
Mohammed Afsar


On Fri, 16 Aug 2024 at 6:49=E2=80=AFPM, Scott Ribe <scott_ribe@elevated-dev=
.com>
wrote:

> > On Aug 16, 2024, at 7:08=E2=80=AFAM, 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 th=
e
> two sides have different glibc versions which have different collations,
> then the index structure of the primary will be a corrupted index on the
> replica. You have to fix your OS version incompatibility, or move to a
> version of postgres which can use ICU collations and make sure that libra=
ry
> is compatible on both sides.
>
>

--000000000000702157061fcd381c
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div><div dir=3D"auto">Got it thanks for the deep dive explanation.Scott =
=F0=9F=91=8D=F0=9F=8F=BB</div><div dir=3D"auto"><br></div><div dir=3D"auto"=
>And parallel =C2=A0we got below error also included OS incompatibility?</d=
iv><div dir=3D"auto"><br></div><div>postgres[265938]: segfault at 18 ip 000=
00000004cf11b</div><div dir=3D"auto"></div><div dir=3D"auto"><br></div><div=
 dir=3D"auto">Regards,</div><div dir=3D"auto">Mohammed Afsar</div></div><di=
v><div><br></div><div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=
=3D"gmail_attr">On Fri, 16 Aug 2024 at 6:49=E2=80=AFPM, Scott Ribe &lt;<a h=
ref=3D"mailto:scott_ribe@elevated-dev.com" target=3D"_blank">scott_ribe@ele=
vated-dev.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" sty=
le=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">&gt; O=
n Aug 16, 2024, at 7:08=E2=80=AFAM, Mohammed Afsar &lt;<a href=3D"mailto:vm=
dapsar@gmail.com" target=3D"_blank">vmdapsar@gmail.com</a>&gt; wrote:<br>
&gt; <br>
&gt; We are using streaming replications but still reindex is not working s=
ource db has 11.15replica has 11.11 PostgreSQL version.<br>
<br>
This is not your problem.<br>
<br>
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 in=
dex structure of the primary will be a corrupted index on the replica. You =
have to fix your OS version incompatibility, or move to a version of postgr=
es which can use ICU collations and make sure that library is compatible on=
 both sides.<br>
<br>
</blockquote></div></div>
</div>

--000000000000702157061fcd381c--