Code SonarQube 2019(2)PostgreSQL as Database

CodeSonarQube2019(2)PostgreSQLasDatabase

Createdatabaseusersonar

>createuser-P-s-esonar

Createdatabase

>createdb-Osonar-Eutf-8sonar

Connecttothedatabase

>psql-Usonar-dsonar-hlocalhost-p5432

Listthedatabase

>\l

Listofdatabases

Name|Owner|Encoding|Collate|Ctype|Accessprivileges

-----------+-------+----------+-------------+-------------+-------------------

demo|carl|UTF8|en_US.UTF-8|en_US.UTF-8|

postgres|carl|UTF8|en_US.UTF-8|en_US.UTF-8|

sonar|sonar|UTF8|en_US.UTF-8|en_US.UTF-8|

AdjusttheconfigurationforSonarQube

>viconf/sonar.properties

sonar.web.port=9000

sonar.web.host=0.0.0.0

sonar.jdbc.url=jdbc:postgresql://localhost/sonar

sonar.jdbc.username=sonar

sonar.jdbc.password=sonar

Starttheservice,itworksprettygood

>bin/linux-x86-64/sonar.shstart

References:

https://www.jianshu.com/p/6179927319e8