Values for database type for Postgresql

Hello,

I have installed Postgresql.

my psql is version 8.4, server version 9.3.

I have configured the dbconfig.xml with the following params:

<?xml version="1.0" encoding="UTF-8"?>
 
<jira-database-config>
  <name>defaultDS</name>
  <delegator-name>default</delegator-name>
  <database-type>postgres72</database-type>
  <schema-name>test</schema-name>
  <jdbc-datasource>
    <url>jdbc:postgresql://host:5432/jiradb</url>
    <driver-class>org.postgresql.Driver</driver-class>
    <username>jiradbuser</username>
    <password>jiradbuser</password>
    <pool-min-size>20</pool-min-size>
    <pool-max-size>20</pool-max-size>
    <pool-max-wait>30000</pool-max-wait>
    <pool-max-idle>20</pool-max-idle>
    <pool-remove-abandoned>true</pool-remove-abandoned>
    <pool-remove-abandoned-timeout>300</pool-remove-abandoned-timeout>
 
    <validation-query>select version();</validation-query>
    <min-evictable-idle-time-millis>60000</min-evictable-idle-time-millis>
    <time-between-eviction-runs-millis>300000</time-between-eviction-runs-millis>
   
    <pool-test-while-idle>true</pool-test-while-idle>
 
  </jdbc-datasource>
</jira-database-config>

and I get the following error:

 

 

 

error.JPG

 

what kind of database-type do i need for this version?

 

thanks in advance,

3 answers

1 vote

I don't think it's the database type at fault here - you get that error when it can't connect to the database server at all.

Hi, thanks for your replies.

the db is running.

JIRA and the db are on the same linux server.

that is why I wrote "host" instead of IP.

 

when I tried to write the server ip I get different error:

HTTP Status 500 - Could not determine database type. (Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.)
type Exception report
message Could not determine database type. (Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.)
description The server encountered an internal error that prevented it from fulfilling this request.

Your system is unable to connect to the database. Connection refused means the database is refusing to talk to the application because your settings are wrong.

0 vote

Yep sounds like there's no connection to the database. I'd do the following

  • Check the status of your database server to ensure that it is running.

  • If your database server is running, check your network configuration to ensure that it is accessible (ex. ping from your JIRA server).

Some times your database service might be turned off. Just start the PostgreSql service in Control Panel-> Services-> Postgresql-9.2

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,293 views 14 20
Join discussion

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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot