Re: beginner help

From: armand pirvu <armand(dot)pirvu(at)gmail(dot)com>
To: Mark Plimley <markp(at)nxrev(dot)com>
Cc: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: beginner help
Date: 2017-06-06 19:32:28
Message-ID: 1523EC63-A236-43BD-A361-19897E89B2D5@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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 <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> 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.

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Mark Plimley 2017-06-06 20:10:21 Re: beginner help
Previous Message message 2017-06-06 19:21:42 multiple foreign keys for a row