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

String comparison fails for some cases after migration

2021-10-26 Thread Jayadevan M
Hello all, 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. select * from accounts where email