a year 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?
52 Replies
a year ago
Can you confirm that the service named postgres is up and running?
a year 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 year ago
Have you modified the template's variables? I'll have to look at what the potential variables are
a year ago
what does the red box say below the "Database Connection" ?
a year ago
oh okay
a year 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 year ago
Ooop please don't share your postgres password :P
a year ago
That password is now permanently public.
a year ago
I'm deploying the template myself to see if I can find the issue
a year ago
You're seeing these logs in the worker container? Or in the interface?
a year 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 year 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 year ago
Who's in your PFP
but how does this help resolve our current issue. <:AE_confused:864885656638980117>
a year ago
I see your issue now. 1 sec.
a year ago
I was curious 🙁
a year 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 year 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 year 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 year 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 year ago
Correct.
a year ago
Historical context would be that DATABASE_URL used to be the public url
a year 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 year ago
I believe both of those but Brody will have a better response
a year 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 year ago
Besides having to use path style syntax, and there not being any billing for it yet, there are no known technical issues.
a year 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 year ago
So who is the PFP? 🙂
a year ago
Knew it looks familiar.
a year ago
All the best devs have an anime PFP
Status changed to Solved brody • 11 months ago