Database backup
ignisda
HOBBYOP

2 years ago

I see an article https://blog.railway.app/p/automated-postgresql-backups which is ~2 yrs old. Is there a method now ?

25 Replies

ignisda
HOBBYOP

2 years ago

N/A


2 years ago

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


ignisda
HOBBYOP

2 years ago

Is there a method now ?

I meant is there a newer method now? I saw some cron settings in the service itself.


2 years ago

yes, you can use that template with railways cron scheduler to save yourself idle resources, read the templates overview for how to configure it


2 years ago

tl;dr SINGLE_SHOT_MODE=true and then set your schedule in the service settings


ignisda
HOBBYOP

2 years ago

is there a link for this? Cant find it in the template


2 years ago


2 years ago

^


ignisda
HOBBYOP

2 years ago

is there any docs about the single shot thing?


ignisda
HOBBYOP

2 years ago

first time seeing it


2 years ago

really isn't much to talk about, read the description for the variable


2 years ago

well yeah haha, it was an arbitrary name I chose because I thought it described its own purpose well enough


ignisda
HOBBYOP

2 years ago

I see that the template does not have any provision for deleting old files


2 years ago

that's something you would want to setup on the bucket


2 years ago

for example I know cloudflare R2 has some kind of object lifetime you can setup


ignisda
HOBBYOP

2 years ago

ah yes, i see it on Minio too.


ignisda
HOBBYOP

2 years ago

thanks!


2 years ago

oh do you plan to use minio?


2 years ago

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


ignisda
HOBBYOP

2 years ago

No issues. Any timeline on when it will be merged?


2 years ago

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


ignisda
HOBBYOP

2 years ago

cool. ill check it out in the weekend then. thanks for your promptness!


2 years ago

no problem!


2 years ago

@IgnisDa merged


ignisda
HOBBYOP

2 years ago

Cool thanks


Loading...