| From: | Mark Plimley <markp(at)nxrev(dot)com> |
|---|---|
| To: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
| Subject: | beginner help |
| Date: | 2017-06-06 18:34:16 |
| Message-ID: | 327a37e2f11843bfaf1a5f1908afb4c6@MBX083-E3-VA-3.EXCH083.serverpod.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | message | 2017-06-06 19:21:42 | multiple foreign keys for a row |
| Previous Message | William Colls | 2017-05-31 14:41:38 | Re: Error Relation xxxx does not exist when trying to insert new row |