Re: beginner help

On Tue, Jun 6, 2017 at 11:34 AM, Mark Plimley <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.