Re: beginner help

In my ignorance, I think I ran a db command as root, which is why that shows up.

How do I add the jiradbuser that I attempted to create as a db user?

Mark Plimley
Sr. PLM Architect
408.708.0916 office
NxRev Inc.

From: David G. Johnston [mailto:david(dot)g(dot)johnston(at)gmail(dot)com]
Sent: Tuesday, June 06, 2017 1:13 PM
To: Mark Plimley <markp(at)nxrev(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] beginner help

On Tue, Jun 6, 2017 at 11:34 AM, Mark Plimley <markp(at)nxrev(dot)com<mailto:markp(at)nxrev(dot)com>> wrote:
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.

​Those log message imply that you have a functioning PostgreSQL instance since that instance is what is writing those log messages.

The default install, however you may have done it, generally creates a "postgres" DB superuser and sets up access permissions so that only the​ "postgres" O/S user can connect. Most people do something like: "sudo -u postgres psql" to get into the default "postgres" database. At that point you can start creating other users.

The O/S user "root" user is apparently trying to connect for some reason. You should try and figure out if you can avoid that.

The "jiradbuser" is expected given your usage and you will need to add that name as a DB user with whatever permissions JIRA says.

David J.