Linux – CET fatal error : role “root” does not exist in postgresql-9. 3-main.log postgreSQL

CET fatal error : role “root” does not exist in postgresql-9. 3-main.log postgreSQL… here is a solution to the problem.

CET fatal error : role “root” does not exist in postgresql-9. 3-main.log postgreSQL

less /var/log/postgresql/postgresql-9.3-main.log

Looking at the postgresql log file, I found a lot of lines:

CET FATAL:  role "root" does not exist

After a lot of Google research, I only found a way to create users, but that’s not what I’m looking for.
How do I check what type of PostgreSQL cron job this is?

Thanks

Solution

I have a solution.

CEST FATAL:  role "root" does not exist

This also appears in my postgres log every 5 minutes.
I searched htop for this nasty program that pollutes my logs.
This is monit! Monit checks every 5 minutes if postgres is still running.
Here is the monitoring configuration (monitrc):

 check process postgres with pidfile /var/postgres/postmaster.pid
 group database
 start program = "/etc/init.d/postgresql start"
 stop  program = "/etc/init.d/postgresql stop"
 if failed unixsocket /var/run/postgresql/.s.PGSQL.5432 protocol pgsql 
 then restart
 if failed host 111.111.111.111 port 5432 protocol pgsql then restart 

Now I just kicked it out of my config because I don’t know how to fix it.
I think the problem is with unixsockets and access permissions.

Related Problems and Solutions