On Wed, Oct 27, 2021 at 11:49 AM Julien Rouhaud <rjuju123@xxxxxxxxx> 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.
You can issue a REINDEX for each impacted index, or a database-wide REINDEX.
Tried creating a new env with the same approach - just reindexing solved the problem. Thanks a lot.
Regards,
Jayadevan
