Re: String comparison fails for some cases after migration

2021-10-27 Thread Jayadevan M
On Wed, Oct 27, 2021 at 11:49 AM Julien Rouhaud wrote: > > > Most likely you had a different version of the glibc or ICU libraries > on the new system, which lead to your indexes on collatable datatypes > partially corrupted. See https://wiki.postgresql.org/wiki/Collations > for more details. >

Re: String comparison fails for some cases after migration

2021-10-26 Thread Tom Lane
Jayadevan M writes: > We moved our PostgreSQL database from one hosting provider to another using > pgbackrest. In the new environment, some comparison operations were > failing. The issue was fixed by running an update. But I am trying to find > out what would have happened. Did the underlyin

Re: String comparison fails for some cases after migration

2021-10-26 Thread Julien Rouhaud
Hi, On Wed, Oct 27, 2021 at 2:12 PM Jayadevan M wrote: > > We moved our PostgreSQL database from one hosting provider to another using > pgbackrest. In the new environment, some comparison operations were > failing. The issue was fixed by running an update. But I am trying to find > out wha