On Wed, Oct 27, 2021 at 11:49 AM Julien Rouhaud <rjuju123(at)gmail(dot)com> 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