Now you will create a database where the Atlassian JIRA application will store its data, and a user role that JIRA will use to connect to the database. We are assuming that you have already created your PostgreSQL database server in a previous step.
We are using pgAdmin III, the administration user interface supplied with PostgreSQL. If you used the one-click installer when installing PostgreSQL, pgAdmin III will be already installed on your computer.
pgAdmin III instructions
Start pgAdmin III.
Right-click (or double-click) the database server name and log in using the password that you specified for the 'postgres' super user.
Add a new login role called 'jirauser':
Right-click Login Roles and select New Login Role.
Enter the role Role name: jirauser
Enter a Password and enter it again to confirm it.
Click the Role privileges tab.
Select Can create database objects.
Select Can create roles.
Click OK to create the user.
Add a new database called 'jira':
Right-click Databases and select New Database.
Enter the database Name: jira
Select the Owner: jirauser
Click OK to create the database.
Screenshot 1 (click to enlarge): JIRA database and user in PostgreSQL
Alternatively, If you are on UNIX and do not have pgAdmin III, you can use the command line interface instead. Assuming that you are using the default installation directory of /opt/PostgreSQL/8.4/bin/, enter the following commands: