Just recently a new release of postgres-flex was published. Because the Debian version of the base image has been updated, you may see a message like this:
database [DATABASE NAME] has a collation version mismatch.
There are a few things you need to do here, but in many cases you should be able to resolve this in the following steps:
Update the app’s image to the latest available version:
fly image update ...
List all available databases:
If you’re not sure about the backslash commands you run, you can check here: PostgreSQL: Documentation: 15: psql
\?in the document page and go ahead.
Connect to database:
postgres=# \c [DATABASE NAME]
Consult: PostgreSQL: Documentation: 15: ALTER COLLATION
postgres=# REINDEX DATABASE [DATABASE NAME]; ALTER DATABASE [DATABASE NAME] REFRESH COLLATION VERSION;