Configure PostgreSQL in SonarQube
In a previous post we saw how to Install SonarQube in its community version. In that post, nothing was configured regarding the database since SonarQube uses an embedded database if one is not configured. Today, we will see how to configure our own dedicated database in PostgreSQL.
If you do not have PostgreSQL installed on your computer yet, or SonarQube, we invite you to check out the following posts.
- Installing PostgreSQL on MacOS
- SonarQube Installation
Creating the user and database
The first thing you should do is to create the database user.
CREATE USER sonarqube;
ALTER USER sonarqube WITH ENCRYPTED password 'mypasssord';After that, we create the database and assign the user created in the previous command as its owner.
CREATE DATABASE sonarqube OWNER sonarqube;SonarQube configuration
To configure SonarQube, you must enter the configuration file sonar.properties, which should be in the installation path, and properly disconnect and configure the username and password variables of the database. According to the previous section, this configuration should look like this.
sonar.jdbc.username=sonarqube
sonar.jdbc.password=mypasswordYou should also uncomment the following line.
sonar.jdbc.url=jdbc:postgresql://localhost/sonarqubeAnd finally, to improve performance, activate the server mode by uncommenting or adding the following line.
sonar.web.javaOpts=-server