Notes for JIRA installation

jira-installation.md

PostgreSQL installation for JIRA Server and Data Center

-- Create DB user for JIRA
-bash-4.2$ createuser --interactive -P jirauser
Enter password for new role: 
Enter it again: 
Shall the new role be a superuser? (y/n) n
Shall the new role be allowed to create databases? (y/n) y
Shall the new role be allowed to create more new roles? (y/n) n
-bash-4.2$ 

-- Create Database for JIRA
postgres=# CREATE DATABASE jiradb WITH ENCODING 'UNICODE' LC_COLLATE 'C' LC_CTYPE 'C' TEMPLATE template0;
CREATE DATABASE
postgres=# 
postgres=# GRANT ALL PRIVILEGES ON DATABASE jiradb TO jirauser;
GRANT
postgres=# 

Edit pg_hba.conf file to remote connection

-- show pg_hba.conf location
postgres=# SHOW hba_file;
-- example: /var/lib/pgsql/9.3/data/pg_hba.conf

Edit postgresql.conf file to allow remote connection

postgres=# SHOW config_file;
--example: /var/lib/pgsql/9.3/data/postgresql.conf

# Add below line in postgresql.conf file
listen_addresses = '*'

Add remote connection details

# JIRA DC Node 1
host    all             all             192.168.104.217/24            trust
# JIRA DC Node 2
host    all             all             192.168.104.218/24            trust

Restart PostgreSQL

sudo systemctl restart postgresql-9.3