Does SonarQube 10.5.x version support Postgresql 16

SonarQube
1

Hello,

We are using SonarQube 9.9.2 Developer Edition, running on PostgreSQL 11, which is already out of support.
We are planning to update SQ to version 10.5.x in a couple of months, and are aiming PostgreSQL 16 as it is our new enterprise standard for databases.

Are there some compatibility informations to share with us ?
The installation requirements page does not mention it.

Has SonarQube 10+ been tested over PGS16 ? Is it supported, or have problems already been reported on this version ?

Best regards,

Fabian

2

Hey there.

  • It hasnā€™t been tested
  • It almost definitely works
  • We tend to upgrade database requirements toward a new LTA, which you should look for towards the end of this year
1 Like
3

Hi Colin,

Where could I get more information about the database upgrade requirements?
I couldnā€™t find it in SonarQubeā€™s roadmap.

Best regards,
Trong

4

I confirm that even the LTA 9.9 works well with Postgres 16.3.

We upgraded 6 month ago from Postgres 11 to 16 on our SonarQube LTA 9.9 Enterprise and we didnā€™t find any issue. Due to yearly releases of Postgres and time taken to dump/restore data we prefered to go directly to 16 instead of 15

Just follow the upgrade guide and donā€™t forget the Upgrade guide Without those step unusable

5

I created a pull request for the helm chart to use the latest PostgreSQL version. Which also includes security fix.

I hope that someone could have a look.
Thank you in advance!

2 Likes