R
Railway•8mo ago
fspoon

Volume backups vs. explicit db backups

The most relevant thread I've found so far for state-of-the-art db backups in railway is https://discord.com/channels/713503345364697088/1126783082859614260, which suggests that older db backup methods like those suggested here https://blog.railway.app/p/postgre-backup will incur an egress tax, and that the best bet is volume-based backups which were in the works as of 2023-07-08. I can't find any hooks or mention of volume backups since then, is that still in the works. If so, does the current state-of-the-art of the railway db backups still incur an egress tax?
Discord
Discord - A New Way to Chat with Friends & Communities
Discord is the easiest way to communicate over voice, video, and text. Chat, hang out, and stay close with your friends and communities.
Railway Blog
How to Backup and Restore Your Postgres Database
In this post, we will go over the process of backing up and restoring your Postgres database hosted on Railway.
10 Replies
Percy
Percy•8mo ago
Project ID: 4e904f1c-19d6-414c-8531-67cd01ac36a6
fspoon
fspoon•8mo ago
4e904f1c-19d6-414c-8531-67cd01ac36a6
Brody
Brody•8mo ago
sending your backups to an external storage provider will incur egress fees. volume snapshotting is planned, but there is currently no eta. instead, send your backups to a minio service within your project across the private network, that way theres no egress fees, only the cost of the storage used. though depending on the size of your database, you would need to weight the costs of egress vs. disk.
fspoon
fspoon•8mo ago
is there a crossover at some point, where it's cheaper to network i/o a MB than store it? or you're saying for storing multiple backups on the same volume?
Brody
Brody•8mo ago
im sure there would be, you would have to do the math with the size of database you plan to backup
fspoon
fspoon•8mo ago
ok, so ingress and egress are per project, not per service, yeah? sorry i'm sure that's in the docs somewhere and i haven't looked it up, but it seems implied by what you're saying. a MB leaving one service and travelling to another via private network is effectively not counted?
Brody
Brody•8mo ago
railway doesnt charge for public ingress, only public egress.
a MB leaving one service and travelling to another via private network is effectively not counted?
correct, only data leaving the private network is charged
fspoon
fspoon•8mo ago
awesome, thank you. i'll looking into service-based backups
Brody
Brody•8mo ago
there are currently no good templates im aware of that backup to a volume, what i would do for that is pair the official backup template https://railway.app/template/I4zGrH with the minio template https://railway.app/template/SMKOEA
fspoon
fspoon•8mo ago
👀
Want results from more Discord servers?
Add your server