Postgres Version for Sonarqube LTA 2025.1

SonarQube Server / Community Build
1

I’m planning to upgrade sonarqube from 10.0 to 2025.1 LTA Version.

Existing Configuration:
We have deployed sonarqube using docker and below 2 services are created in docker composer file
sonarqube : depends on db service
db : postgres:12 docker image has been used.

From the release upgrade notes, it seems that Postgres version should be from 13 to 17 for latest 2025.1 LTA

However, i tested the upgrade by setting up sonar in local and upgrade seems success (Sonar server has started) even without upgrading postgres from 12 to 13.

If we upgrade the postgres to 13, the data volume is large and it is time consuming to upgrade all the existing data (in postgres 12 format) to postgres 13 format.

So, would like to know what would be consequences if we don’t upgrade postgres to 13 since sonarqube application (2025 LTA) is started successfully in local with Postgres 12

1 Like
2

I’ve tried this from previous LTA releases and it won’t work. You can try hahaha but chances are logs will tell you one thing that it needs a compatible DB version or something to that effect.

3

To complement @popac00’s answer – not all requirements will cause SonarQube to fail on startup. However, the requirements always indicate that SonarQube is not tested against, nor will there be fixes for issues that are caused by using versions that don’t align with the requirements.

Considering that PostgreSQL 12 reached its End of Life (EOL) on November 14, 2024, you should make sure you update. At a minimum, it represents a real risk to your organization to use a version that no longer receives security updates.

1 Like