a year 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
a year ago
hello,
you're not missing PGHOST, you're missing PGUSER, PGPASSWORD, and PGDATABASE
a year 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?

a year ago
does the database have a public TCP proxy?
a year ago
yes, and then redeploy
a year ago
you didnt set the variables to the values i gave you, and you incorrectly modified a variable that i didnt mention
a year 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!
a year 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
a year ago
wouldnt that be done via n8n's ui
a year 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
a year ago
i dont know if you can, just saying that digging around in a database is probably not the way to go
a year 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
a year ago
sounds good, is it good to mark this as solved now?
a year ago
!s
Status changed to Solved brody • about 1 year ago




