CET fatal error : role “root” does not exist in postgresql-9. 3-main.log postgreSQL
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?
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 220.127.116.11 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.