DB Migration not reflected in SonarQube Developer Edition

We were trying to move to a new k8s cluster and wanted to upgrade from 9.6.1 to 9.9 lts version with developer edition. We used the helm chart to install the instance on a new cluster. We use the default postgresql db. So we took the backup from the postgresql pod using pg_dump and restore on the one pod instance. But in the UI we are not able to get the already scanned projects. So we also not requesting the license key as we are not sure it we will get the data in the new instance. We are not sure how to proceed further. Any leads or help would we great.

Hi,

Welcome to the community!

Your title mentions “DB Migration”. When you started up your 9.9 instance, did it come straight up, or did you have to perform the DB migration? If the former, then you’re not pointed at the DB you think you are.

 
Ann

It came straight up and after that we restored the db using pg_restore but after that the projects didn’t show up

Hi,

As I indicated above, if SonarQube 9.9 started immediately after your upgrade, then you didn’t point it at your existing database. I’m assuming there’s a yellow warning about using the embedded, H2 database at the bottom of each page. That would explain why your projects don’t show up. You need to check your server logs and your configuration.

 
HTH,
Ann