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
a month ago
Can you confirm that the service named postgres is up and running?
a month 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
a month ago
Have you modified the template's variables? I'll have to look at what the potential variables are
a month ago
what does the red box say below the "Database Connection" ?
a month ago
oh okay
a month 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"a month ago
Ooop please don't share your postgres password :P
a month ago
That password is now permanently public.
a month ago
I'm deploying the template myself to see if I can find the issue
a month ago
You're seeing these logs in the worker container? Or in the interface?
a month 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.

a month 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
a month ago
Who's in your PFP
but how does this help resolve our current issue. <:AE_confused:864885656638980117>
a month ago
I see your issue now. 1 sec.
a month ago
I was curious 🙁
a month 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?
a month ago
Please don't use N8N's own database in your flows, the database the template deploys with is for N8N to use internally.
a month 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.
a month 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
a month ago
Correct.
a month ago
Historical context would be that DATABASE_URL used to be the public url
a month 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?
a month ago
I believe both of those but Brody will have a better response
a month ago
It's fairly stable but I wouldn't recommend putting any production apps on it (yet) because it's technically "subject to change"
a month ago
Besides having to use path style syntax, and there not being any billing for it yet, there are no known technical issues.
a month 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.
a month ago
So who is the PFP? 🙂
a month ago
Knew it looks familiar.
a month ago
All the best devs have an anime PFP
Status changed to Solved brody • about 2 months ago


