R
Railway

✋|help

Automated Postgres backup onto a volume ?

Ssambhavgore8/27/2023
Since now the project I was developing for a while is almost ready for production, we need to make sure that we take automatic DB backups everyday.

I found this article on blog which shows how to do it with an S3 bucket - https://blog.railway.app/p/automated-postgresql-backups

My question is though, Since my client does not already have an AWS account, and since now there are volumes support available from Railway, will the following solution work ?

Create a new service and mount a volume to it. Run that new service on a CRON. Within that service, take database dumps and store it onto the volume ?

Some things I haven't thought about - How to actually restore from backups? how to download the backup (if needed) to local machine. Keep only last N backups and delete the older ones
(All of the above are possible with S3 already).
Ssambhavgore8/27/2023
20f1c8cb-7c67-4474-a8e7-7f50a349d80f
Bbrody1928/27/2023
there's a few templates that do automatic database backups, I think at least one of them backups to the volume, to access the dump you'd need to use something like this https://railway.app/template/guiCBv which was specifically designed for this type of scenario.

but the template from the blog you linked should be able to work with an S3 compatible service like cloudflare r2, I can totally understand not wanting to have an aws account, but you might already have a cloudflare account! so give that a try

Looking for more? Join the community!

Recommended Posts
how can i deploy my vue projecti get this errorHosting Django backend and React frontend from the same DomainI have two services, one for my backend and one for my frontend. They currently have two separate doResponse Pending with OpenAIHi I have SAAS website running on Railway using OpenAI with Next js , the problem is the endpoint noDjango backend fails to respondWhen I click on the url for my django backend (I am using react frontend in a separate service) I geReflexHi, someone deploy reflex.dev in railway? do you have a guide?The new log explorer is great, Is it possible to show the service name in there ?Currently in the log explorer the service name is an ID and I was wondering if you plan to show the What is a good / recommended resource use for a web app? Plus question about scaling.I am deploying a few applications for a client of mine. It is a multi-tenant app made in sveltekit. How to put site on maintenance mode in railway?hello everyone how do i put a site on maintenance mode in railway or 'page can not be reached' mode Service not updating to Hobby specshey! I don't know if I'm doing something wrong but I paid for the hobby plan but my service still haerror on index fileI have an index file in a folder that exports all the components in that folder for easier importinOdoo Community EditionI would like to know if we can setup Odoo in railway? The odoo image is built with docker using thiWebsocket disconnectingHey, I have an app that uses a websocket (hosted on railway) but for some reason every once in a whi