How to Migrate Sonarqube from H2 to Postgresql?

Step 1 – Run Postgresql using docker command

$ docker run --name postgres -p 5432:5432 -e POSTGRES_PASSWORD=mysecretpassword -d postgres

Step 2 – Modify sonar.properties

sonar.jdbc.username=postgres
sonar.jdbc.password=mysecretpassword
sonar.jdbc.url=jdbc:postgresql://172.31.13.0:5432/postgres?currentSchema=public

Step 3 – Do this

Step 4 – Do this

Step 5 – Start SonarQube

Step 6 – Access http://52.66.187.172:9000/

admin
admin

• Author
• Recent Posts

Follow me

Rajesh Kumar

Mentor for DevOps - DevSecOps - SRE - Cloud - Container & Micorservices at Software AG

Join my following certification courses...
- DevOps Certified Professionals (DCP)
- Site Reliability Engineering Certified Professionals (SRECP)
- Master in DevOps Engineering (MDE)
- DevSecOps Certified Professionals (DSOCP)
URL - https://www.devopsschool.com/certification/

My Linkedin - https://www.linkedin.com/in/rajeshkumarin

Follow me

Latest posts by Rajesh Kumar (see all)

• Best AI tools for Software Engineers - November 4, 2024
• Installing Jupyter: Get up and running on your computer - November 2, 2024
• An Introduction of SymOps by SymOps.com - October 30, 2024