Connecting JIRA to Postgresql

Nguyen Tran Community Champion Apr 17, 2017

I'm trying to connect JIRA to a postgres database following this instruction:

https://confluence.atlassian.com/adminjiraserver073/connecting-jira-applications-to-postgresql-861253040.html

However, I'm getting this message 

Error connecting to database

Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.

Connection refused

Is there any tips about what to configure and how to troubleshoot the problems?

Thanks

1 answer

1 accepted

0 vote

Hi Nguyen,

Hopefully you've been able to get around this by now, however, the error is that the connection is refused so I would start by checking that your firewall is allowing connections through the port Postgres is on - usually 5432.  There is a good response on the Stackoverflow site that can provide some things to check.  Hope that helps!

Cheers,

Branden

Nguyen Tran Community Champion May 28, 2017

Hi Branden,

I have managed to connect to the database. You can close the question :D

Thanks,

Nguyen

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Thursday in Jira Service Desk

How the Telegram Integration for Jira helps Sergey's team take their support efficiency to the bank

...+ reading Fantasy). The same is true for him at the bank he works for: Efficiency is key when time literally equals money. Read on to learn how Sergey makes most of the time he has by...

199 views 0 2
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you