Code SonarQube 2019(2)PostgreSQL as Database

Code SonarQube 2019(2)PostgreSQL as Database

Create database user sonar
> createuser -P -s -e sonar

Create database
> createdb -Osonar -Eutf-8 sonar

Connect to the database
> psql -U sonar -d sonar -h localhost -p 5432

List the database
> \l
                              List of databases
   Name    | Owner | Encoding |   Collate   |    Ctype    | Access privileges
-----------+-------+----------+-------------+-------------+-------------------
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 |

Adjust the configuration for SonarQube
> vi conf/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

Start the service, it works pretty good
> bin/linux-x86-64/sonar.sh start

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