have you tried redeploy your postgres service?

yes. Its stuck on deploying. I tried restoring to my backup made 3 hours ago. It just randomly lost connection. I checked server logs to see what was occuring before this. There was no activity leading up to losing connection

are you using the private database url or the public one?

public

I am having the same issue, i redeployed and its been stuck on deployment now for 30 minutes

okay so it sounds like a global issue then

try redeploy source image, go to your postgres service > open the command palette (Ctrl+K on PC) > select "Redeploy source image"

Am i able to cancel the restore since its stuck?

not sure but only one of my 60 odd services is having this issue so i dont think so

Seems like it is server issue that is hosting our postgres dbs

Redeploy source image didn't work?

no it kept redploying without ever finishing. Got a message from railway that it is a hardware issue with the server the postgres is running on

getting the same issue tried restarting no improvement -global issue?

I think so

issue persists any solutions??

One day I had a problem like that where Prisma (Database ORM) was misconfigured and hogged too many database connections. It made it impossible for Railway's web interface to load because Railway had no connection available; I ended up believing the database was broken even while my app was totally fine. Turned out that by deploying a fix to limit the connections usable in Prisma, it fixed the problem. I learned the hard way you should always set the application_name flag in your connection URL ahaha.

I don't know if it's the same problem, but you might want to investigate with that in mind!

thanks it may be but i cant push a change so eiterh support sort the infra there side or i rebuild the database which i dont reall ywant to do