Can you confirm that the service named postgres is up and running?

We are unable to connect to the database over the public network

Actually, this implies it's trying over public with the private domain

Have you modified the template's variables? I'll have to look at what the potential variables are

what does the red box say below the "Database Connection" ?

oh okay

In this context, the n8n template sets up the variables on the Postgres database slightly incorrectly, and then it inadvertently results in this error.

Ooop please don't share your postgres password :P

my bad sorry this is my first time when it comes to hosting

not really experienced in devops

That password is now permanently public.

🤦 sorry.

Do i have to redoploy the templates again?

I'm deploying the template myself to see if I can find the issue

I see.

You're seeing these logs in the worker container? Or in the interface?

Railway interface I am seeing that error.

For example

even on my redis I have this issue.

Works fine for me with no modifications <:hmm_noted:1383623507509903420>

Are you using the first template that shows up when you search n8n?

Redis shouldn't even have the REDIS_PASSWORD with my deployment.

The only modification as you can see I followed that required variable to put it in redis. I have put in a random string

That is correct that is the one.

Who's in your PFP

uhh not to be rude

but how does this help resolve our current issue. <:AE_confused:864885656638980117>

I see your issue now. 1 sec.

I was curious 🙁

Your issue won't actually cause issues with N8N I believe, just the built in UI

Oh I see.

In my n8n flows I do plan on using the DB itself. Should it work if I provided the correct connection string?

Please don't use N8N's own database in your flows, the database the template deploys with is for N8N to use internally.

Oh make sense.

But just in case you do want to view it:

DATABASE_PUBLIC_URL="postgresql://${{PGUSER}}:${{POSTGRES_PASSWORD}}@${{RAILWAY_TCP_PROXY_DOMAIN}}:${{RAILWAY_TCP_PROXY_PORT}}/${{PGDATABASE}}"

You can create that variable and the UI will work.

Amazing!

Thank you Gentlemen.

Out of curiosity, why does Railway even try the internal domain? Is DATABASE_URL the backup to DATABASE_PUBLIC_URL?

-# Wow I really cannot spell today

Correct.

Historical context would be that DATABASE_URL used to be the public url

So for very old database deploys, the data tab will still work.

Before I close this thread. Buckets are currently out but for Feature Flags. Does that mean there some techinical bugs to be fixed before full deployment or is just looking feedback from the community?

I believe both of those but Brody will have a better response

It's fairly stable but I wouldn't recommend putting any production apps on it (yet) because it's technically "subject to change"

Besides having to use path style syntax, and there not being any billing for it yet, there are no known technical issues.

But of course, beta is beta, so what Sam said.

Great.
Thank you both Sam and Brody. I hope you guys have a great evening/night.

So who is the PFP? 🙂

The Eminence in Shadow - Beta Season 2 Episode 09 14:02.

Knew it looks familiar.

All the best devs have an anime PFP