The first thing we need to do is create a user and database that SonarQube can use. Just for the record, SonarQube can work with SQL Server, MySQL, and Oracle too, but PostgreSQL is always a good (and free) choice.
On Ubuntu, open the PostgreSQL terminal and run the script to create a sonar user and then the script to create a database, making the sonar user the owner:
sudo -u postgres psql\create user sonar with password 'sonar';\create database sonar with owner sonar encoding 'UTF8';\q
The UTF8 encoding is NOT optional, so be sure to include it. Also, don't forget the semicolons at the end of your statements.
On Windows, you can also create a user and database using the command prompt. It only differs from Ubuntu ...