On Wed, Oct 27, 2021 at 11:49 AM Julien Rouhaud <rjuju123@gmail.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.