JIRA Data Center

Question

Hello All,

I am trying to install Jira data center on my local PC, windows operating system but getting below error. let me know how to fix it.

"connect localhost: 5432 refused error, check the hostname and port are correct and the post master accepting the tcp/IP connection"

Carlos Garcia Navarro · Answer

Btw, have you thought of using Cloud instead? Atlassian announced end of support for Server licenses:

https://confluence.atlassian.com/adminjiraserver/end-of-support-announcements-938846831.html#:~:text=All%20Jira%20releases%20after%20Jira,with%20a%20Data%20Center%20license.

Jira 9.12 is the last feature release available to download for Server, prior to the Server end of support date on Feb 15, 2024.

All Jira releases after Jira 9.12 will only support our Data Center offering. Jira 9.12 will continue to receive security and bug fixes until the end of support date on February 15, 2024, for customers with a Server license and until March 19, 2024, for customers with a Data Center license.

Carlos Garcia Navarro · Answer

Hi @Nidhi singh ,

While doing some research found some tips on how to troubleshoot. Have you checked these?

* Make sure PostgreSQL is running

* Confirm you're connecting to the right port( is 5432 right?)* cat /etc/postgresql/9.6/main/postgresql.conf | grep port, to identify the right port

* Confirm PostgreSQL is listening for TCP/IP connections (listen_addresses in postgresql.conf)-

* sudo lsof -n -u postgres |grep LISTEN or sudo netstat -ltnp | grep postgres should show the TCP/IP addresses and ports PostgreSQL is listening on

* Check if PostgreSQL is only listening on IPv4 (0.0.0.0 or 127.0.0.1) and you're connecting on IPv6 (::1) or vice versa. This seems to be an issue on some older Mac OS X versions that have weird IPv6 socket behavior, and on some older Windows versions.