Postgresql DB Migration from SonarQube 8.3 to SonarQube 10.6

SonarQube Server / Community Build
1

Must-share information (formatted with Markdown):

  • which versions are you using (SonarQube, Scanner, Plugin, and any relevant extension)
  • SonarQube version 8.3 community, SonarQube version 10.5.1-community
  • how is SonarQube deployed: zip, Docker, Helm
  • Installed via Helm
  • what are you trying to achieve
  • Migrate postgresql DB from my SonarQube v8.3 to v10.6-community
  • what have you tried so far to achieve this
  • Spin up a fresh new installation of SonarQube 10.5.1-community with a new postgresql database

I tried to backup the SonarQube 8.3 Postgresql DB data and restore the dump in the freshly installed SonarQube Postgresql DB for our SonarQube 10.5.1 - and encountered some issues with the schema. Is there a way that I can backup my old database and restore it in my new database for use of my SonarQube 10.5.1?

Or any alternative migration suggestions between 2 existing SonarQube databases (8.3 and 10.5.1) ?

Do not share screenshots of logs – share the text itself (bonus points for being well-formatted)!

3

Hi @plambojon. Welcome to our community forums.

Did you check our Determining the server upgrade path docs?

Quoting it:

  • If there is at least one LTA version in your upgrade path, you must first upgrade to each intermediate LTA and then to your target version.

Meaning that you will need to go to 8.9, 9.9, and then 10.5.1 (or 10.6.0)

Just make sure to backup your DB, as stated in our upgrade roadmap.