Postgres UI Variable Configuration Issue
rcapdepaula
HOBBYOP

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.

Solved

24 Replies

rcapdepaula
HOBBYOP

a year ago

48626e5a-5e0f-40c0-ac71-644d737e07d0


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}}

rcapdepaula
HOBBYOP

a year ago

Thank you very much! It worked. Is this delay in connecting to the database common?

1331328444201570300


rcapdepaula
HOBBYOP

a year ago

It keeps loading


a year ago

does the database have a public TCP proxy?


rcapdepaula
HOBBYOP

a year ago

I don't think so

1331329149448753200


rcapdepaula
HOBBYOP

a year ago

do i just have to add the port?


a year ago

yes, and then redeploy


rcapdepaula
HOBBYOP

a year ago

it's still just loading 🙂

1331348388926718000
1331348389337764000
1331348389647880200
1331348390021169200


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


rcapdepaula
HOBBYOP

a year ago

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?


rcapdepaula
HOBBYOP

a year ago

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?


rcapdepaula
HOBBYOP

a year ago

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


rcapdepaula
HOBBYOP

a year ago

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?


rcapdepaula
HOBBYOP

a year ago

ok. Thanks 🙂


a year ago

!s


Status changed to Solved brody about 1 year ago


Loading...