2 months ago
Just tried to self host n8n with workers and when looking at my database.
I am getting this error
Database Connection
We are unable to connect to the database over the public network.
getaddrinfo ENOTFOUND postgres.railway.internal
how to resolve?
0 Replies
2 months ago
Can you confirm that the service named postgres is up and running?
2 months ago
We are unable to connect to the database over the public network
Actually, this implies it's trying over public with the private domain
2 months ago
Have you modified the template's variables? I'll have to look at what the potential variables are
2 months ago
what does the red box say below the "Database Connection" ?
2 months ago
oh okay
2 months ago
In this context, the n8n template sets up the variables on the Postgres database slightly incorrectly, and then it inadvertently results in this error.
DATABASE_URL="postgres://${{POSTGRES_USER}}:${{POSTGRES_PASSWORD}}@${{PGHOST}}:${{PGPORT}}/${{POSTGRES_DB}}"
PGDATA="/var/lib/postgresql/data/pgdata"
PGDATABASE="${{POSTGRES_DB}}"
PGHOST="${{RAILWAY_PRIVATE_DOMAIN}}"
PGPASSWORD="${{POSTGRES_PASSWORD}}"
PGPORT="5432"
PGUSER="${{POSTGRES_USER}}"
POSTGRES_DB="railway"
POSTGRES_PASSWORD="YbgRNWjKDhMOKrF5HsS5zSAwBssSPwl~"
POSTGRES_USER="railway"
SSL_CERT_DAYS="820"2 months ago
Ooop please don't share your postgres password :P
2 months ago
That password is now permanently public.
2 months ago
I'm deploying the template myself to see if I can find the issue
2 months ago
You're seeing these logs in the worker container? Or in the interface?
2 months ago
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.

2 months ago

The only modification as you can see I followed that required variable to put it in redis. I have put in a random string
2 months ago
Who's in your PFP
but how does this help resolve our current issue. <:AE_confused:864885656638980117>
2 months ago
I see your issue now. 1 sec.
2 months ago
I was curious 🙁
2 months ago
Your issue won't actually cause issues with N8N I believe, just the built in UI
In my n8n flows I do plan on using the DB itself. Should it work if I provided the correct connection string?
2 months ago
Please don't use N8N's own database in your flows, the database the template deploys with is for N8N to use internally.
2 months ago
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.
2 months ago
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
2 months ago
Correct.
2 months ago
Historical context would be that DATABASE_URL used to be the public url
2 months ago
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?
2 months ago
I believe both of those but Brody will have a better response
2 months ago
It's fairly stable but I wouldn't recommend putting any production apps on it (yet) because it's technically "subject to change"
2 months ago
Besides having to use path style syntax, and there not being any billing for it yet, there are no known technical issues.
2 months ago
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.
2 months ago
So who is the PFP? 🙂
2 months ago
Knew it looks familiar.
2 months ago
All the best devs have an anime PFP
Status changed to Solved brody • 2 months ago


