Self hosting n8n postgres connection problems


Hi guys, I’m running n8n node locally and I also created postgres chat memory.
Problem is database connection is failing with authorization, but when I trigger it again for few times it starts working
This is the error: [ERROR: password authentication failed for user “n8n”]
Does anyone know why is it happening?

Hi there, so it only fails the first time and now its working? is the issue still reproducible?

when I click execute, 80% of time that error happens. Then I need to execute it again or go to the node > edit connection > click retry until it gives green feedback that it is connected. Connection is not consistent but I don’t know why

how do you run your n8n locally? with docker-compose or just the usual docker?

and how do you setup your postgres? also locally? with docker? or how?

and how do you connect n8n to your docker?

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.