R
Railway•14mo ago
Ryan!

Postgres connection issue in production environment, can connect manually

django.db.utils.OperationalError: connection to server at "containers-****.railway.app" (IP), port 6815 failed: Connection timed out
Is the server running on that host and accepting TCP/IP connections?
django.db.utils.OperationalError: connection to server at "containers-****.railway.app" (IP), port 6815 failed: Connection timed out
Is the server running on that host and accepting TCP/IP connections?
My staging app is running just fine, but my production enviroment can't connect to its postgres. I am able to log into the postres with railway shell; python manage.py dbshell. I've rebooted the DB a couple times and reset the credentials and redployed. I'm not sure how to proceed besides tearing down the whole DB, which seems like a painful last resort.
6 Replies
Percy
Percy•14mo ago
Project ID: 2398d6c4-d1ce-4101-8ffd-3f45216b211c
Ryan!
Ryan!•14mo ago
project 2398d6c4-d1ce-4101-8ffd-3f45216b211c
Brody
Brody•14mo ago
team will be looking into this
Ryan!
Ryan!•14mo ago
Thanks @Brody Checking back in on this
Ray
Ray•14mo ago
Are you still having this issue? Your db looks alive and I'm able to ping it oh sorry, I was looking at the wrong env 🤦‍♂️ This was caused by https://railway.instatus.com/clik6k1hk294312awn8v8rox7a1. It should be fixed now, try again?
Ryan!
Ryan!•14mo ago
Aha, it was network related. That was my hunch since it worked locally, in staging and I could connect to the db manually. It's back after restarting the app. I guess the N retries exhausted quickly and it needed a manual restart. It's back now. Thanks for the help. I appreciate you looking into it.
Want results from more Discord servers?
Add your server
More Posts
(React with Vite) -> ReactRouter 404 Routing Error on Page reloadHi everybody! I hosted a react app on this platform and I'm getting 404 errors on page reloads. Goihow can I change the environment variable for my Railway project?I want to change environment variable for nocodb but can't figure out where I need to change that vaDeployment crashes with confusing TypeErrorSo, I have a piece of code that works flawlessly in my project. But the same piece of code in my newIs it possible to use Fonts?Hello, I have a Node.js server where I use the Sharp library to turn SVG's into other image formats.Datatype TIMEHello, I have a database postgresql in local and I have datatype time on columns. It works well. butNode graceful shutdownsI have a node task manager process deployed to Railway that I'm trying to get to gracefully shutdownAlpine.js button from standard Laravel Breeze package not working in prodThe weird thing is that it works perfectly locally. But in production https://manul-shop-productionIf a DJANGO process is failing because of the workersI do some maths in my django app on railway. It's complicated, and CPU bound. I have the current DevMy estimated bill is tripling every two days and falling back to 0 again.Hi, i need help, i'm not getting answers either from mail or from the message sent from the platformAccessing backend endpoints but unable to access frontend code after successful deploymentI deployed a Nestjs and Angular app in Railway.app via dockerfile. My problem is after deploying the