2 years ago
I've encountered an unusual behavior in the Postgres UI. The interface is showing PGHOST as a "Required Variable" that needs to be configured, even though it's already set up in the environment variables (as shown in the variables list with masked values).
Interestingly, the Postgres node within n8n is working correctly with these same environment variables values, which confirms they are properly configured and accessible.
Other variables like PGPORT, PGUSER, PGPASSWORD, PGDATABASE, and DATABASE_URL are also flagged as required despite being configured and working in n8n.
24 Replies
2 years ago
hello,
you're not missing PGHOST, you're missing PGUSER, PGPASSWORD, and PGDATABASE
2 years ago
Set these variables -
PGUSER=${{POSTGRES_USER}}
PGPASSWORD=${{POSTGRES_PASSWORD}}
PGDATABASE=${{POSTGRES_DB}}Thank you very much! It worked. Is this delay in connecting to the database common?

2 years ago
does the database have a public TCP proxy?
2 years ago
yes, and then redeploy
2 years ago
you didnt set the variables to the values i gave you, and you incorrectly modified a variable that i didnt mention
2 years ago
fixed that for you, works now
Thank you very much! It's my first time on Railway and I started with a template, I didn't really know what to do. Now it's working perfectly!
2 years ago
may i ask why you needed to use the data tab though?
I want to create a table to store all the conversations of a particular ID (WhatsApp) in the n8n chat bot. At first, it would be
2 years ago
wouldnt that be done via n8n's ui
2 years ago
doesnt seem like something the end user should be modifying?
If I can create a table directly via n8n, all the better. I'm a frontend developer and know a bit about backend. This is the first time I've used n8n. I used to automate with Express and Supabase. That's why I also intend to use postgres
2 years ago
i dont know if you can, just saying that digging around in a database is probably not the way to go
2 years ago
remember, the platform will not help if you lose any data
It would be another instance, this one I'm not going to touch because it's a template and I don't know what's in it
2 years ago
sounds good, is it good to mark this as solved now?
2 years ago
!s
Status changed to Solved brody • over 1 year ago




