Does sonarqube-6.7.7 require UTF8 for postgresql?

The web server failed to start with the following error about the db charset needing to be changed. I am attempting to upgrade from 5.6.6 to 6.7.7 on ubuntu linux. Is upgrading the db to support UTF8 a requirement? And the advice to browse to /setup is not helpful since the web interface didn’t start :slight_smile:

Any pointer to helping with the db charset conversion will be appreciated. postgresql 9.3.5

2019.11.08 14:48:53 WARN web[o.s.s.p.DatabaseServerCompatibility] Database must be upgraded. Please backup database and browse /setup
2019.11.08 14:48:53 INFO web[o.s.s.p.d.m.c.PostgresCharsetHandler] Verify that database charset supports UTF8
2019.11.08 14:48:53 ERROR web[o.s.s.p.Platform] Web server startup failed: Database charset is SQL_ASCII. It must support UTF8.

Hello, Yes indeed SonarQube does require your PostgreSQL schema to be UTF-8.

This is visible in the DB requirements here

To change your PostgreSQL encoding, the only way i know is to :

  1. Dump your database
  2. Drop your database (or create the new one with another schema name)
  3. Create new database with the different encoding
  4. Reload your data

yes, I was afraid you’d say that! :smiley: Thanks!