Fix PostgreSQL Collation version miss-match

The following is an example of what you need to do to fix PostgreSQL Collation version miss-match issues on Arch Linux.

REINDEX DATABASE dummy;
ALTER DATABASE dummy REFRESH COLLATION VERSION;

Basically my understanding is that PostgreSQL depends on certain libraries and the version of those libraries are effectively snapshotted when the indexing is done. Hence the COLLATION VERSION. So when libraries are upgraded on the system and PostgreSQL is now linking to a different version of the library. There is no guarantee that it behaves 100% the same as it did with the previous.

Therefore, you need to reindex things and then update the COLLATION VERSION.