Postgresql version for Bitbucket and Bamboo

[1vishal_kashyap_ravikumar]

So we have a situation, currently the bit bucket is installed on Microsoft Windows 2016 server using the database PostgreSQL 11.7

And I want to install Bamboo also on the same server using the database PostgreSQL, but the latest support for bamboo is only up to PostgreSQL 10.

Q1: Is it okay to have two versions of PostgreSQL on a single server but different ports 

Q2. Shall I downgrade the version of PostgreSQL which is already installed, and install the PostgreSQL 10 which supports both for bit-bucket and bamboo.

[Barry Allen]

Hi,

Short answer: yes for both.

Q1: Is it okay to have two versions of PostgreSQL on a single server but different ports 

A1:

Yes, it is okay to have two versions of PostgreSQL on different ports. But make sure that you are giving the correct port while setting up connection for Bamboo. Please check Database URL from Screenshot 1 in this https://confluence.atlassian.com/bamboo/postgresql-289276816.html help docs.

Q2. Shall I downgrade the version of PostgreSQL which is already installed, and install the PostgreSQL 10 which supports both for bit-bucket and bamboo.

A2:

Yes, it wouldn't affect anything, since Bitbucket server required minimum version is PostgreSQL's 9.4. But make sure you have backed up the current data before doing this steps. Please checkout  https://confluence.atlassian.com/bitbucketserver/supported-platforms-776640981.html to know more about required min-max versions.

Please let me know, if my answer helps you.