I am about to install JIRA but want to make sure if it is necessary to create a new database and user before installing it. My database is PostgreSQL version 9.3 and My JIRA version is 6.3.14 x64
Nice short answer. The longer version is that JIRA needs a data store of some sort, and you have to provide that because it cannot know what you want to do. You can use the internal one for an evaluation or test system, and migrate later, but it's not suitable for production, and it really does need a proper database if you're going to use it in production.
But, all you do need is that empty database and a single user with full access to it. You don't need to run any SQL - JIRA creates and populates all the tables it needs without you needing to get involved.
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG