Postgres
Collation version mismatch in Postgres
You may encounter Postgres warning logs about a collation version mismatch, for example:
The warning indicates that the OS collation library in the image is newer than the one used when the database was created. The problem does not indicate a data corruption issue. Instead, it is a warning asking to reindex the data so it can be preserved.
To fix the problem, update the collation metadata and rebuild the affected indexes:
The above Postgres (PostgreSQL) utility command updates the recorded version and reindexes the affected objects.
Reindexing locks the database, so it’s best to run this command during a short maintenance window.
