After "updating" #PostgreSQL from the #PostgreSQL provided Version 17 to the one from #Debian 13 I get this:
DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41.
Is it harmless to call "ALTER DATABASE poi REFRESH COLLATION VERSION;"?
Oh and if so, can I alter all databases at once?
Follow
@giggls refreshing the collation version will make the warning go away. However you might have index corruption, from the underlying changes to the collation.
If you have any type of indexes on text columns, you should reindex those. To rebuild the index aligned with the new collation rules. Then you can refresh the collation version.
