Jira Database

Atlassian

Jira Service Desk

Jira AWS Lifecycle

Jira AWS Backups

dbconfig.xml

Useful Queries

Bibliography

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;

Jira Users

Bibliography

https://confluence.atlassian.com/adminjiraserver/switching-databases-938846867.html https://community.atlassian.com/t5/Jira-questions/How-do-I-change-database-settings-in-Jira/qaq-p/710841 https://confluence.atlassian.com/adminjiraserver/jira-application-home-directory-938847746.html
https://stackoverflow.com/questions/32255309/how-do-i-restore-rds-snapshot-into-a-cloudformation
https://confluence.atlassian.com/jirakb/attachments-health-check-fails-in-jira-server-744526718.html
https://developer.atlassian.com/server/jira/platform/database-schema/

Page updated

Google Sites

Report abuse