canonical/postgresql-operator

Provide flexible backup strategy. Charmed PostgreSQL 14 provides only manual AWS S3 and Ceph Rados GW backups.

valexby opened this issue · 4 comments

Hi!

It is not a bug, but a feature request. The charm allows only backups to AWS S3 (or any other S3 compatible) or to Ceph Rados GW. It seems rather narrow and would be great to allow some of the:

The current list of integrations for backups doesn't seem compatible with most On-Premises deployments. Even Azure doesn't have native support for S3 protocol. It limits the flexibility of charmed PostgreSQL 14 compared to previous charmed versions.

Even after the backup medium is configured, it is not clear how to configure Juju-managed scheduled backups as the charm doesn't provide any schedule, only a juju-action that should be triggered manually.

Thank you for the enhancement request! This is up to PM team to prioritize and schedule.
CC: @delgod , @7annaba3l

Local backups and backup scheduling are features we have on our roadmap but they will not be delivered , as of today, before the beginning of 2025.

Resolving the issue as the answer provided! Fingers-crossed to provide such a nice feature one day!
Meanwhile it will be tracked on PM side for the next roadmap plannings.

P.S PRs are welcome! Resolved, feel free to reopen if you have more questions/ideas here!