Best way to setup back up system for my postgres?
Looking to do a backup every X number of hours
25 Replies
Project ID:
N/Ause railways backup template for postgres
just set this up to upload to my cloudflare r2
will check back tomorrow to see if it works
have it set to @hourly and to keep backups for 7 days
what cron expression did you use?
@hourly
is what the template said i could do ποΈ π ποΈ
will actually just remove schedule to let it test run
and then set it to hourly
good i did that
the URL isn't right
oh, you aren't using the template made by railway
i couldn't find it
i thought this was it
https://railway.app/template/XV2dlg
oh definitely not
why does it even come with a database lol
it does?
haha yes, click the link you sent
this is the official template - <PostgreSQL S3 backups>
deploy it into your project and provide it the private database url
got it, 2nd one here
ok looks like i got the proper one setup
although it goes once a day at 5am
so i'll guess i'll wait till then to see
yeah, you can change that though
https://crontab.guru/every-1-hour
just deployed it to test every 5 minutes π
just so i can see it work
then I'll switch it to hourly
i wish there was a way I could do like
hourly backups for the past 3 days, but then only need once a day backup
i guess i could setup two different crons?
yeah that could work with multiple backup services
nice
we're cooking
awsome
this officially saved my skin - i accidentally deleted my database and then restored it from this backup
ty for the help setting it up
no problem!