Values for database type for Postgresql

Aviad Shiber

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,

error.JPG

Nic Brough -Adaptavist-

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.