HELP: missing data in production postgres volume | Railway | Page 1

lusty quarry Mar 22, 2024, 7:31 PM

#

hi

I was just looking through my database and found table is empty? I found 2 empty tables on my database.

Any idea why this might be happening?

runic folioBOT Mar 22, 2024, 7:31 PM

#

Project ID: 31943e18-7b03-4292-9ae0-1b4eafd436ba

lusty quarry Mar 22, 2024, 7:31 PM

#

31943e18-7b03-4292-9ae0-1b4eafd436ba

winter bison Mar 22, 2024, 7:33 PM

#

can I see a screenshot of your postgres service as it shows up on your project canvas?

lusty quarry Mar 22, 2024, 7:33 PM

#

#

#

for some reason, Account and Session table are now empty? but other ones still have data thankfully

#

winter bison Mar 22, 2024, 7:34 PM

#

you may have ran some force seed command of some sort

#

unfortunately unless you have a backup there's not much railway can do here for you, as they are only responsible for data loss when they are at fault.

lusty quarry Mar 22, 2024, 7:36 PM

#

ok

#

any suggestions to do backups in future?

winter bison Mar 22, 2024, 7:38 PM

#

use this https://railway.app/template/I4zGrH to backup your database to cloudflare r2

#HELP: missing data in production postgres volume