PostgreSQL – How to Connect Jira to PostgreSQL with Pgpool-II

pgpoolpostgresql

I gotta problem with connecting Jira 6 to Pgpool-II which is responsible for load balancing and replication in Postgresql bases(2 instances).

enter image description here

Pgpool is started on port 9999, I just want to connect to it in this (Jira)installation step but Jira tolds that connection attempt failed….

Best Answer

Well ... check the pgpool logs and your servlet container logs.

I'd also try psql 'host=localhost port=9999 dbname=postgres username=postgres password=whatever'

Most likely the PgPool configuration has issues. If it works from psql, you'd need to check out the server logs to see what's up.

Related Question