How to prepare PostgreSQL for Jira on Debian

Install PostreSQL if you haven't already

~$ sudo apt-get update

~$ sudo apt-get install postgresql postgresql-client

Create database user 'jira'

~$ sudo su - postgres

~$ createuser -P jira

Enter password for new role:

Enter it again:

~$ sudo -u postgres psql -c 'alter user jira with createdb' postgres

Create database 'jiradb'

~$ sudo su - jira

$ createdb -E UNICODE -l C -T template0 jiradb

$ exit

No go to jira set up by web browser, pick advanced configuration and set up the database as below.