jira db setup

[Padmasree P]

I am trying to connect my postgres db and test the connection using Jira setup. 

I have created a new db and postgres user. but it throws tcp/ip error

should we need any jdbc connector for postgres . please help

[Gonchik Tsymzhitov]

Hi! 

Have you followed this instruction?

https://confluence.atlassian.com/adminjiraserver/connecting-jira-applications-to-postgresql-938846851.html

From your input info, looks like your pg_hba.conf is not allowed. 

Cheers,

Gonchik Tsymzhitov

[Padmasree P]

Hi Gonchik,Do we need postgres jdbc driver to connect jira

[Gonchik Tsymzhitov]

It should be in package. 

Feel free provide error log

[Padmasree P]

Hi Gonchik,

so postgres yum installation would have installed jdbc . please correct if I'm wrong.I got below error in ui.

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

[Gonchik Tsymzhitov]

Please, read the related KB.  pg_hba and postgresql.conf. It will be nice if you provide more info. (like RDBMS and Jira located on the same host or not? Configuration of postgresql.conf and pg_hba.conf)