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