Jayadevan M <maymala.jayadevan@gmail.com> 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 underlying OS version change? If so, see
https://wiki.postgresql.org/wiki/Locale_data_changes
regards, tom lane