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.