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