Database backup
I see an article https://blog.railway.app/p/automated-postgresql-backups which is ~2 yrs old. Is there a method now ?
Railway Blog
Automated PostgreSQL Backups
A step-by-step guide on automatic PostgreSQL backups on Railway using a one-click template.
18 Replies
Project ID:
N/A
N/A
the blog itself may be old, but the template it recommends is kept up to date and is still the recommended way to take postgres backups
Is there a method now ?I meant is there a newer method now? I saw some cron settings in the service itself.
yes, you can use that template with railways cron scheduler to save yourself idle resources, read the templates overview for how to configure it
tl;dr
SINGLE_SHOT_MODE=true
and then set your schedule in the service settingsis there a link for this? Cant find it in the template
is there any docs about the single shot thing?
first time seeing it
really isn't much to talk about, read the description for the variable
well yeah haha, it was an arbitrary name I chose because I thought it described its own purpose well enough
I see that the template does not have any provision for deleting old files
that's something you would want to setup on the bucket
for example I know cloudflare R2 has some kind of object lifetime you can setup
ah yes, i see it on Minio too.
thanks!
oh do you plan to use minio?
the template isn't currently working with MinIO, but there is an open PR I have that adds support, if you plan to use minio you would need to deploy the branch from my pr
No issues. Any timeline on when it will be merged?
technically I could merge it right now myself, and even though another user confirmed it worked with minio, I'd still want to get someone from the team to review anyway, I will ask the team tomorrow