Connecting JIRA to Postgresql

[Nguyen Tran]

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

[somethingblue · Accepted solution]

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]

Hi Branden,

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

Thanks,

Nguyen