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,

[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.

[Aviad Shiber]

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.

[Nic Brough -Adaptavist-]

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.

[sajeev]

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

[David Di Blasio]

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).