Postgres connection issue and sudden outage
ProjectID: 09bf07b8-3bc8-438d-8d8e-8e3b6d26d05a
Service has been down for the last 2 days, have not seen any changes in usage.
Looks like a database connection issue. And the database is extremely slow/spotty on the dashboard as well.
Receiving the following error:
Have tried restarting the database, rotating db credentials and restarting the service - no luck.
There is a sharp decrease in performance last couple of days from the DB. Since I have not made any changes or seen any increases in load, I'm assuming it's something on the railway end.
Could you please take a look?
20 Replies
Project ID:
09bf07b8-3bc8-438d-8d8e-8e3b6d26d05awould you happen to know when this database was originally created?
I dont remember exact date, but a couple of months ago I believe
is the database slow/spotty when using pgadmin?
(definitely don't rely on the data or query features built into the plugin)
It does load in DBeaver, not super fast. But it does load.
I believe I went live with this database in March, ~22nd
do you have a database backup?
I do not have a backup at the moment
do you think you could dump your database as it stands right now?
I can't create a backup dump for it super fast, but probably would be able to with enough time. I do not want to drop the database if that's what you mean
im suggesting dump your database and restore the data to a neon.tech database
What is a neon.tech database?
a separate service?
I will look into it. But do you know why there are issues?
I am a customer of Railway and am using Railway out of convenience, so I find it surprising to be suggested to use a separate service.
im just a community member, i dont know what has actually happened to your database, sorry.
i don't enjoy suggesting another service for a database. but railway's database infrastructure is quite fragile to say the least, and even if the team did fix this for you there is no guarantee you wont face other database issues down the line
Oh I see, thanks for letting me know.. I was under the impression you were a support engineer or part of the team!
Yepp service is up after migrating off railway for the database, not a very good look :/ quite unfortunate. But thanks for the recommendation @Brody
oh i know its a terrible look, believe me
Do you know how neon pricing looks? is it bad compared to railway?
haven't used neon myself yet so i dont know what the pricing is like, and even if i did i don't know what you do with your database, but ive seen lots of people recommend it
Subscribe I'm having a weird postgres issue too, where I can connect to the database but my app cant. Plus it one environment is fine, but my main one isn't booting because of this.
I also rebooted and rotated credentials.
I'm still experiencing this issue even after migrating off of railway for the database.
I can connect to the new database from outside raillway so unsure why the networking is having issues.