Where can I find what version of Postgres I am running on Bitbucket

[Ed Cook]

I just did an upgrade of Postgres and restarted Bitbucket. I want to confirm Bitbucket is using the new version of Postgres. Where can I see what Postgres version my Bitbucket is using?

[Christian Glockner]

Hi Ed,

You can generate a support zip and then look at the application-properties/application.xml file in that zip. Search for <database-information> in that file and you should get what you're looking for.

Cheers,

Christian

Premier Support Engineer

Atlassian

[Mikael Sandberg]

If you look in the atlassian-bitbucket.log you should see which version of Postgres the startup script is using, just search for Starting Bitbucket.

[Ed Cook]

Are there some other words I should search for? I do not see anything about Postgres by the "Start Bitbucket" 

2022-03-17 18:55:54,859 INFO  [main]  c.a.b.i.b.BitbucketServerApplication Starting BitbucketServerApplication v7.17.4 using Java 1.8.0_144 on stash.aws-us-east-1.test.com w

ith PID 3828 (/atlassian/stash/atlassian-bitbucket-7.17.4/app/WEB-INF/classes started by stash in /atlassian/stash/atlassian-bitbucket-7.17.4/bin)

2022-03-17 18:55:54,863 INFO  [main]  c.a.b.i.b.BitbucketServerApplication No active profile set, falling back to default profiles: default

2022-03-17 18:55:55,595 INFO  [main]  c.a.b.i.boot.log.BuildInfoLogger Starting Bitbucket 7.17.4 (6d8324a built on Wed Dec 15 00:51:12 EST 2021)

2022-03-17 18:55:55,596 INFO  [main]  c.a.b.i.boot.log.BuildInfoLogger JVM: Oracle Corporation Java HotSpot(TM) 64-Bit Server VM 1.8.0_144-b01

2022-03-17 18:55:56,753 INFO  [main]  c.a.b.i.b.BitbucketServerApplication Started BitbucketServerApplication in 2.944 seconds (JVM running for 3.548)

2022-03-17 18:56:00,689 INFO  [spring-startup]  c.a.s.internal.home.HomeLockAcquirer Successfully acquired lock on home directory /atlassian/atlassian-home/stash

2022-03-17 18:56:10,101 INFO  [spring-startup]  c.a.s.internal.home.HomeLockAcquirer Successfully acquired lock on home directory /atlassian/atlassian-home/stash/shared

2022-03-17 18:56:12,092 WARN  [spring-startup]  com.hazelcast.instance.Node [10.148.xx.yy]:5701 [stash] [3.12.9] No join method is enabled! Starting standalone.

2022-03-17 18:56:28,825 WARN  [hz.hazelcast.event-4]  org.hibernate Switching to log level [INFO]

2022-03-17 18:56:28,825 INFO  [hz.hazelcast.event-1]  com.atlassian.bitbucket Switching to log level [DEBUG]

2022-03-17 18:56:28,825 WARN  [hz.hazelcast.event-3]  ROOT Switching to log level [INFO]

2022-03-17 18:56:28,829 INFO  [hz.hazelcast.event-1]  com.atlassian.stash Switching to log level [DEBUG]

2022-03-17 18:56:28,829 WARN  [hz.hazelcast.event-4]  org.springframework Switching to log level [INFO]

2022-03-17 18:56:28,829 ERROR [hz.hazelcast.event-3]  com.atlassian.event.remote Switching to log level [DEBUG]

2022-03-17 18:56:28,829 INFO  [hz.hazelcast.event-3]  c.h.i.diagnostics.HealthMonitor Switching to log level [DEBUG]

[Mikael Sandberg]

Hmm, I wondering if that info is not sent to the log file... If you go to Settings > Database does it show the version? You should also be able to look at the process to see which path it is using for the database. (It's been 2+ years since I used Bitbucket Server, so trying to remember from memory...)

[Ed Cook]

No, that does not show the version, only the DB type, JDBC URL, username and password.