public inbox for [email protected]
help / color / mirror / Atom feedFrom: Mohammed Afsar <[email protected]>
To: Scott Ribe <[email protected]>
Cc: pgsql-admin <[email protected]>
Subject: Re: Reindex doesn’t not working replica nodes
Date: Fri, 16 Aug 2024 19:18:44 +0530
Message-ID: <CA+6HdusYzHKxoUPHGrf6wVjBMe3Luo6S5iy+j9Dte+qija-0_w@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
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>
<[email protected]>
Got it thanks for the deep dive explanation.Scott 👍🏻
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 PM, Scott Ribe <[email protected]>
wrote:
> > On Aug 16, 2024, at 7:08 AM, Mohammed Afsar <[email protected]> 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 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 library
> is compatible on both sides.
>
>
view thread (8+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: Reindex doesn’t not working replica nodes
In-Reply-To: <CA+6HdusYzHKxoUPHGrf6wVjBMe3Luo6S5iy+j9Dte+qija-0_w@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox