Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

NextCloud: Automatic backups of Postgres database #18

Open
mattjmcnaughton opened this Issue Jan 1, 2019 · 0 comments

Comments

Projects
1 participant
@mattjmcnaughton
Copy link
Owner

mattjmcnaughton commented Jan 1, 2019

Issue
Currently, I run NextCloud's backing Postgres database on a StatefulSet, with an attached persistent volume. This setup is resilient to pods being terminated. However, I would still like to take database backups at a regular cadence.

Impl
I need to determine the cadence at which I want to take backups, and also the form with which I want to take backups (pgdump, ebs snapshot, etc...), where I want to store them, and how I will monitor that the backups are successful. I think the CronJob resource could be helpful for this.

Definition of Done

  • Implemented some method of regularly taking database backups.
  • Documented the process of restoring a database backup, verified it works, and filed a ticket to repeat the verification at a regular cadence.
  • Implemented some form of monitoring/alerting around whether backups are successful.
  • Blog post.

@mattjmcnaughton mattjmcnaughton added this to To do in roadmap Jan 1, 2019

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.