search

andrasmaroy / infra

Manage all home infrastructure with automation
MIT License
4 stars 0 forks source link

Backup job for database #99

Open andrasmaroy opened 12 months ago

andrasmaroy commented 12 months ago

Even though the database is clustered and the underlying volumes are replicated by Longhorn, there should be a regular backup job for the stored data.

There is a backup job for the non-ha version of the bitnami postgresql helm chart, that probably can be adapted to be used with the HA chart.

Another potential solution for this: pgbackup

Also Postgres has a feature called continuous archiving

andrasmaroy commented 10 months ago

cloudnative-pg solves this out of the box: https://cloudnative-pg.io/documentation/1.21/backup/#scheduled-backups