Odi's astoundingly incomplete notes
New entries | CodeHow to migrate SonarQube to Postgresql
Perform the migration on an existing SonarQube installation. You can not do it at the same time as upgrading to a newer SonarQube version!
1. Create an emtpy Postgresql DB (no password is used here, depending on settings in
4. Shut down the SonarQube instance again for migration.
5. Delete the
4. Run the mysql-migrator utility.
5. Startup the SonarQube instance again.
6. If you want to update to a newer SonarQube version then do that now.
1. Create an emtpy Postgresql DB (no password is used here, depending on settings in
pg_hba.conf
):
psql -U postgres create user sonar; create database sonarqube owner sonar;2. Change the DB connection of the existing SonarQube installation in
sonar.properties
:
sonar.jdbc.username=sonar #sonar.jdbc.password= sonar.jdbc.url=jdbc:postgresql://localhost/sonarqube?currentSchema=public3. Start up the SonarQube instance so that it creates the DB schema in Postgresql.
4. Shut down the SonarQube instance again for migration.
5. Delete the
sonar/data/es6/nodes
folder.4. Run the mysql-migrator utility.
5. Startup the SonarQube instance again.
6. If you want to update to a newer SonarQube version then do that now.
Add comment