Describe the problem/error/question
I went ahead and restarted my n8n instance that is self-hosted on Coolify. I had a postgres db attached to it too, and after restarting I am getting the following error.
So this is from my n8n instance logs in coolfiy:
2025-08-17T00:15:33.809050299Z Permissions 0644 for n8n settings file /home/node/.n8n/config are too wide. This is ignored for now, but in the future n8n will attempt to change the permissions automatically. To automatically enforce correct permissions now set N8N_ENFORCE_SETTINGS_FILE_PERMISSIONS=true (recommended), or turn this check off set N8N_ENFORCE_SETTINGS_FILE_PERMISSIONS=false. 2025-08-17T00:15:35.296273291Z Last session crashed 2025-08-17T00:15:45.302520828Z Initializing n8n process 2025-08-17T00:15:45.948291945Z There was an error initializing DB 2025-08-17T00:15:45.948773899Z password authentication failed for user "anas" 2025-08-17T00:15:50.699167388Z Permissions 0644 for n8n settings file /home/node/.n8n/config are too wide. This is ignored for now, but in the future n8n will attempt to change the permissions automatically. To automatically enforce correct permissions now set N8N_ENFORCE_SETTINGS_FILE_PERMISSIONS=true (recommended), or turn this check off set N8N_ENFORCE_SETTINGS_FILE_PERMISSIONS=false. 2025-08-17T00:15:51.992864553Z Last session crashed 2025-08-17T00:16:01.998511428Z Initializing n8n process 2025-08-17T00:16:03.001359430Z There was an error initializing DB
And this is from my Postgresql logs also self hosted, n8n:
2025-08-17T00:16:36.366577121Z Connection matched file "/var/lib/postgresql/data/pg_hba.conf" line 128: "host all all all scram-sha-256" 2025-08-17T00:16:36.918488459Z 2025-08-17 00:16:36.918 UTC [136] FATAL: role "anas" does not exist 2025-08-17T00:16:42.009373494Z 2025-08-17 00:16:42.008 UTC [143] FATAL: role "anas" does not exist
I never changed the password or anything for my postgres database so idk wtf it is talking about… It has alwauys been the default setup. Someone please help me with this, I got a lot of workflows on my instance.
What is the error message (if any)?
Shared above
Please share your workflow
(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)
Share the output returned by the last node
Information on your n8n setup
- n8n version:
- Database (default: SQLite): Postgres
- n8n EXECUTIONS_PROCESS setting (default: own, main): self hosted
- Running n8n via (Docker, npm, n8n cloud, desktop app): coolify
- Operating system:
