sonarqube-install with postgresql

##Minimum Requirement for sonarqube 
2 vCpu and 4GB RAM

sudo apt-get update -y
# increase the vm.max_map_count kernal, file discriptor and ulimit for current session at runtime

sudo sysctl -w vm.max_map_count=262144

sudo sysctl -w fs.file-max=65536

ulimit -n 65536

ulimit -u 4096
sudo apt-get install openjdk-11-jdk openjdk-11-jre -y
sudo apt install postgresql postgresql-contrib
sudo adduser sonar
groups sonar
sudo usermod -aG sudo sonar
sudo visudo
sonar ALL=(ALL:ALL) NOPASSWD:ALL
cd /opt

sudo wget https://binaries.sonarsource.com/Distribution/sonarqube/sonarqube-8.9.10.61524.zip

sudo unzip sonarqube-8.9.10.61524.zip 

sudo mv sonarqube-8.9.10.61524 sonarqube

sudo chown -R sonar:sonar /opt/sonarqube

## login postgres 
sudo -i -u postgres

# check the version
psql

# change the password postgres user
\password postgres

# Create user with password
create user sonar with encrypted password 'Linux@123';

# Create Database
create database sonarqube;

# provide privileges for sonar and postgres
# Enter 2 times one its showing error as syntax error at or near grant
grant all privileges on database sonarqube to sonar;
grant all privileges on database sonarqube to postgres;

# exit the postgres
\q
exit


# Update the sonarqube configuration file

cd /opt/sonarqube/conf

vim sonar.properties
## Change the below lines

# Databases Section
sonar.jdbc.username="your created user"
onar.jdbc.password="your created password"

# postgreql section remove after sonarqube 
sonar.jdbc.url="jdbc:postgresql://localhost:5432/sonarqube"