need help to recover a backup postgresql db when doing migrations | Railway | Page 1

runic vault Jan 13, 2024, 8:24 PM

#

i have deleted a backup postgresql db when doing migrations ,,can you help me recover it

torn peakBOT Jan 13, 2024, 8:24 PM

#

Project ID: 1946624d-4838-4412-83ee-ad1108c33fef

coarse oliveBOT Jan 13, 2024, 8:24 PM

#

To help others find answers, you can mark your question as solved via Right click solution message -> Apps -> ✅ Mark Solution

runic vault Jan 13, 2024, 8:25 PM

#

1946624d-4838-4412-83ee-ad1108c33fef

vale mica Jan 13, 2024, 8:26 PM

#

do you have a backup?

runic vault Jan 13, 2024, 8:28 PM

#

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

vale mica Jan 13, 2024, 8:30 PM

#

so the legacy database is fine?

runic vault Jan 13, 2024, 8:32 PM

#

both are deleted

vale mica Jan 13, 2024, 8:33 PM

#

and you have no backups anywhere else?

runic vault Jan 13, 2024, 8:35 PM

#

i have another backup in s3

#

i now want to migrate the master db

vale mica Jan 13, 2024, 8:35 PM

#

then you would need to deploy a new postgres database and restore your backup

runic vault Jan 13, 2024, 8:36 PM

#

when one makes a migration ,,does the legacy and new db stay?

vale mica Jan 13, 2024, 8:36 PM

#

yes, railway will not delete databases, that would have been something you did

runic vault Jan 13, 2024, 8:37 PM

#

what happens when db is deleted by mistakes can it be recovered ?

vale mica Jan 13, 2024, 8:37 PM

#

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

runic vault Jan 13, 2024, 8:38 PM

#

now i have phobia migrating the master db HAHAHA

vale mica Jan 13, 2024, 8:40 PM

#

haha just don't delete stuff

runic vault Jan 13, 2024, 8:43 PM

#

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 ??

vale mica Jan 13, 2024, 8:45 PM

#

yes

#

why are you deleting volumes?

runic vault Jan 13, 2024, 8:47 PM

#

the other dbs where not have volumes so i thought it would work just fine

vale mica Jan 13, 2024, 8:48 PM

#

the other new databases will absolutely have volumes

#

the legacy databases don't have volumes, but all new databases will

runic vault Jan 13, 2024, 8:49 PM

#

i didnt know that

#

Thank you so much

vale mica Jan 13, 2024, 8:49 PM

#

no problem

runic vault Jan 13, 2024, 8:50 PM

#

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?

vale mica Jan 13, 2024, 8:53 PM

#

I don't work for railway lol

#need help to recover a backup postgresql db when doing migrations