Thanks for the link, but I have already browsed much of the JIRA documentation.
I am not able to “Create a database user (login role)” or “Create a database for JIRA” because of the errors starting the PostgreSQL service. I think need to get past the errors first, and I don’t know how to do that. I don’t know what user I should use to create database users or create the database.
Mark Plimley
Sr. PLM Architect
408.708.0916 office
NxRev Inc.
From: armand pirvu [mailto:armand.pirvu@gmail.com]
Sent: Tuesday, June 06, 2017 12:32 PM
To: Mark Plimley <markp@nxrev.com>
Cc: pgsql-novice@postgresql.org
Subject: Re: [NOVICE] beginner help
No mention about root although may need to do the same thing as for jiradbuser
I’m trying to get PostgreSQL set up to use with JIRA service desk on CentOS 7. I am totally new to PostgreSQL.
I installed PostgreSQL 9.6 and apparently got it enabled with ‘systemctl enable postgresql.service’. When I tried ‘systemctl start postgresql.service’, it fails to start. Postgresql-Mon.log reports “FATAL: role “root” does not exist” and “FATAL: role “jiradbuser” does not exist” because of trying to create those users.
I assume that I need to drop those users if I can figure out how to. Can someone provide some pointers on where to start or what I need to do to move forward? I have a postgres user and group and apparently I need to run some commands as that user if I can get the service to start.
I looked at the documentation but need to get past the startup errors before I can do anything.
Certified in Windchill MCAD Data Management
Product Development Solutions
Please include your NxRev account representative on technical issues or questions.