post-upgrade health-check throws false warning: The database collation 'en_US.utf8' is not supported by Confluence. You need to use 'utf-8'.
Confluence 6.4 -> upgraded to 6.14.2, postgresql 9.6
- Create postgres database with en_US.utf8 collation/cset:
- Create new Confluence environment (using the oldest supported version of the installer), use database created in previous step
- Download latest Confluence installer file, proceed with upgrading existing environment
- Start Confluence after the upgrade
Confluence starts without any issues
Following warning is displayed during the startup:
This occurs because the health check verifies against all utf-8 collations, and does not include utf8. utf8 is a supported collation, we are incorrectly reporting this as a failure.
If using Docker, the initdb args can be overridden by setting POSTGRES_INITDB_ARGS to the below as per the example (this is using Kitematic).
It is safe to ignore the health check failure now and continue - it will only appear on upgrade.