need help to recover a backup postgresql db when doing migrations

i have deleted a backup postgresql db when doing migrations ,,can you help me recover it
24 Replies
Percy
Percy10mo ago
Project ID: 1946624d-4838-4412-83ee-ad1108c33fef
willymwaura
willymwaura10mo ago
1946624d-4838-4412-83ee-ad1108c33fef
Brody
Brody10mo ago
do you have a backup?
willymwaura
willymwaura10mo ago
the db i have deleted was the backup now we dont have a backup after migrations i saw two dbs the legacy and the new ,,and deleted the new db by mistake
Brody
Brody10mo ago
so the legacy database is fine?
willymwaura
willymwaura10mo ago
both are deleted
Brody
Brody10mo ago
and you have no backups anywhere else?
willymwaura
willymwaura10mo ago
i have another backup in s3 i now want to migrate the master db
Brody
Brody10mo ago
then you would need to deploy a new postgres database and restore your backup
willymwaura
willymwaura10mo ago
when one makes a migration ,,does the legacy and new db stay?
Brody
Brody10mo ago
yes, railway will not delete databases, that would have been something you did
willymwaura
willymwaura10mo ago
what happens when db is deleted by mistakes can it be recovered ?
Brody
Brody10mo ago
as long as you have a backup you are able to restore it if you didn't have a backup, then there's no way to restore it
willymwaura
willymwaura10mo ago
now i have phobia migrating the master db HAHAHA
Brody
Brody10mo ago
haha just don't delete stuff
willymwaura
willymwaura10mo ago
i think i have noticed what i have done wrong ,,when one deletes the volume of the new db does it delete the whole data db ??
Brody
Brody10mo ago
yes why are you deleting volumes?
willymwaura
willymwaura10mo ago
the other dbs where not have volumes so i thought it would work just fine
Brody
Brody10mo ago
the other new databases will absolutely have volumes the legacy databases don't have volumes, but all new databases will
willymwaura
willymwaura10mo ago
i didnt know that Thank you so much
Brody
Brody10mo ago
no problem
willymwaura
willymwaura10mo ago
bytha how can one work in your company (i use react ,python and go ) but i saw somehow that you use typescript can one work for you when he uses another language or tool?
Brody
Brody10mo ago
I don't work for railway lol
willymwaura
willymwaura10mo ago
HAHAHA
Want results from more Discord servers?
Add your server