Jira Database

dbconfig.xml

/var/atlassian/application-data/jira/dbconfig.xml

Note that in an AWS CloudFormation configuration you should not update this file directly
<?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>public</schema-name>  <jdbc-datasource>    <url>jdbc:postgresql://mydbhostname:5432/jira</url>    <username>atljira</username>    <password>UnencryptedPassword!</password>    <driver-class>org.postgresql.Driver</driver-class>
    <pool-min-size>20</pool-min-size>    <pool-max-size>20</pool-max-size>    <pool-min-idle>10</pool-min-idle>    <pool-max-idle>20</pool-max-idle>
    <pool-max-wait>10000</pool-max-wait>    <validation-query>select 1</validation-query>    <time-between-eviction-runs-millis>60000</time-between-eviction-runs-millis>    <min-evictable-idle-time-millis>180000</min-evictable-idle-time-millis>    <pool-remove-abandoned>true</pool-remove-abandoned>    <pool-remove-abandoned-timeout>60</pool-remove-abandoned-timeout>    <pool-test-while-idle>true</pool-test-while-idle>    <pool-test-on-borrow>false</pool-test-on-borrow>  </jdbc-datasource></jira-database-config>

Useful Queries

SELECT *

  FROM fileattachment;

Bibliography