We don't offer data restoration for user-initiated actions like this. Since you're on Pro, you can check your Postgres service's Backups tab for any existing volume snapshots to restore from, and going forward, enabling native volume backups and point-in-time recovery on the service will let it self-restore if this happens again.

i dont have the backup for today , only 1 week earlier, can you please see this ?

Our databases are unmanaged, so automatic snapshots, WAL recovery, and PITR aren't available to restore your data unless you've enabled them on the service. Volume backups and point-in-time recovery are both native Railway features on Pro. We don't recover data lost to user-initiated actions. Going forward, enable volume backups on your stateful services so you can self-restore if this happens again.

where can i activate this

?

Having looked into this, the issue appears to be in your application code or configuration rather than the Railway platform itself, which puts it outside what Railway support can resolve directly.

This is exactly the kind of problem the Railway community is good at, so we'd like to open your thread as a community bounty. Railway pays a bounty to the community member who solves it, and threads like this usually get picked up quickly.

Opening it makes this entire thread public, including everything already posted. Nothing becomes public until you decide. Use the buttons below.

• Open to the community - Before you click, take a moment to edit or remove anything you'd rather not share. The thread becomes publicly visible right away.
• Keep it private and close the thread - Nothing becomes public. The thread closes, since this isn't something Railway support can take further.

now i clicked to restore the backup from 31 JUly , how much time will it take to restore the backup ? its 1.1 GB

This still looks like an application-level problem, so Railway support can't take it further, but the community can. The buttons below are still live: open the thread up as a public bounty after editing out anything sensitive, or keep it private and close it.

how much time soes it take to restore the 1.1GB database ?

This still looks like an application-level problem, so Railway support can't take it further, but the community can. The buttons below are still live: open the thread up as a public bounty after editing out anything sensitive, or keep it private and close it.

After clicking restore, did you click redeploy? Also try reloading the page.

i have 2 sevices , the postgre and the backend service , in both i have the backup , what will the backedn service restore do ? will it restore also the postgre data ?

No. These backups are separate from each other, as they’re different services.

and how can i see the files inside the file folder volume in my backedn service ?

You can access the filebrowser by going into the Console tab of your service.

what are these volumes on the top of the each service ? what do they serve for, and what happens if i mount them ?

Those volumes should be mounted to their respective service. Drag the Postgres volume over Postgres to mount it, and same for your rfg service. Click the redeploy button to save changes.

what will it affect if i do it ?

Does Postgres currently not have a volume mounted?

it looks like this

Nevermind leave it alone then. The unmounted volumes were from before you restored from backups.

if i restore the backend one's , mount the top one, will it bring back the situation that was before restore backup ?

Yes.

i suddenly deleted the date with sql code from my postgre sql , but the manual backup is only for 21 JUly , is there any way to restore my data ? it s very crutial data for me

Not really sure what you mean by that. If the backups available do not contain the item you deleted, then unfortunately, there isn’t a way to recover it.

i have a backup for 31July, no other backup , i am interested if you can help me restore the data for tomorrow , do you have any replicas , copyes etc ?

data of yesterday *

The only options you have are the backups in the backups tab in your service.

From now onwards, I recommend enabling PITR so you can restore to any point in time since enabling the feature. You can do so through the backups tab.