How to switch to postgres v12 db from embedded db in docker-compose setup

anjanbacchu · February 8, 2023, 3:55pm

Must-share information (formatted with Markdown):

SonarQube : version 9.9 community
use postgres db version 12
MAC OS (Monterey) with M1 chip
tried running docker-compose up -d. Then going to localhost:9000. At the bottom of the homepage, observe that a notice about the embedded database being used is displayed. How should I switch this setup to use postgresql ? I also notice that the postgresql database is up and running because the directories postgresql and postgresql_data are created in the directory of docker-compose descriptor file.

What should I do to fix this ?

P.S : I’m a total newbie to SonarQube installation

Colin · February 9, 2023, 4:07pm

Hey there.

Have you seen this example?

github.com

SonarSource/docker-sonarqube/blob/master/example-compose-files/sq-with-postgres/docker-compose.yml

version: "3"
services:
  sonarqube:
    image: sonarqube:community
    hostname: sonarqube
    container_name: sonarqube
    depends_on:
      - db
    environment:
      SONAR_JDBC_URL: jdbc:postgresql://db:5432/sonar
      SONAR_JDBC_USERNAME: sonar
      SONAR_JDBC_PASSWORD: sonar
    volumes:
      - sonarqube_data:/opt/sonarqube/data
      - sonarqube_extensions:/opt/sonarqube/extensions
      - sonarqube_logs:/opt/sonarqube/logs
    ports:
      - "9000:9000"
  db:
    image: postgres:13

This file has been truncated. show original

Topic		Replies	Views
Need help migrating postgre-db from 7.1 to the latest version of sonarqube SonarQube Server / Community Build sonarqube	2	315	February 3, 2021
Problem in the configuration of the external database SonarQube Server / Community Build sonarqube	3	292	June 22, 2023
Postgres db integration with sonarqube SonarQube Server / Community Build sonarqube	1	667	July 20, 2021
Unable to use postgres DB with SonarQube 9.9 LTS SonarQube Server / Community Build	3	754	March 9, 2023
Upgrading production docker sonarqube instance to developer edition SonarQube Server / Community Build	5	714	September 19, 2022

How to switch to postgres v12 db from embedded db in docker-compose setup

Related topics