Re: beginner help

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(dot)pirvu(at)gmail(dot)com]
Sent: Tuesday, June 06, 2017 12:32 PM
To: Mark Plimley <markp(at)nxrev(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] beginner help

No mention about root although may need to do the same thing as for jiradbuser

https://confluence.atlassian.com/adminjiraserver071/connecting-jira-applications-to-postgresql-802592176.html

Hope this helps a bit

— Armand

On Jun 6, 2017, at 1:34 PM, Mark Plimley <markp(at)nxrev(dot)com<mailto:markp(at)nxrev(dot)com>> wrote:

Experts:

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.

Thanks.

Mark Plimley
Sr. PLM Architect
Certified in Windchill MCAD Data Management
MarkP(at)NxRev(dot)com<mailto:MarkP(at)NxRev(dot)com>
NxRev Inc.
Product Development Solutions
39500 Stevenson Pl #108
Fremont, CA 94539

Please include your NxRev account representative on technical issues or questions.