Postgres UI Variable Configuration Issue
rcapdepaula
HOBBYOP

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.

Solved

24 Replies

rcapdepaula
HOBBYOP

2 years ago

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


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

rcapdepaula
HOBBYOP

2 years ago

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

1331328444201570406


rcapdepaula
HOBBYOP

2 years ago

It keeps loading


2 years ago

does the database have a public TCP proxy?


rcapdepaula
HOBBYOP

2 years ago

I don't think so

1331329149448753203


rcapdepaula
HOBBYOP

2 years ago

do i just have to add the port?


2 years ago

yes, and then redeploy


rcapdepaula
HOBBYOP

2 years ago

it's still just loading 🙂

1331348388926718043

1331348389337763970

1331348389647880304

1331348390021169192


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


rcapdepaula
HOBBYOP

2 years 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!


2 years ago

may i ask why you needed to use the data tab though?


rcapdepaula
HOBBYOP

2 years 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


2 years ago

wouldnt that be done via n8n's ui


2 years ago

doesnt seem like something the end user should be modifying?


rcapdepaula
HOBBYOP

2 years 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


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


rcapdepaula
HOBBYOP

2 years 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


2 years ago

sounds good, is it good to mark this as solved now?


rcapdepaula
HOBBYOP

2 years ago

ok. Thanks 🙂


2 years ago

!s


Status changed to Solved brody over 1 year ago


Welcome!

Sign in to your Railway account to join the conversation.

Loading...