Not sure why postgres service would complain about root/jiradbuser at startup
I wonder if it does not try to start other things as well (doubtfull though)
May want to make sure postgres is down and try to start manually using pg_ctl command as postgres , create root and jiradbuser roles , stop and start using systemctl and go from there
Sent from my iPhone
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.
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.