elephant-shed icon indicating copy to clipboard operation
elephant-shed copied to clipboard

Show backup status in cluster overview

Open hermesalvesbr opened this issue 1 year ago • 1 comments

I have 8 databases of my clients to back up and check if the copy is not corrupted. Would Elephant Shed help me with this?

If not, could you point me to a panel that would facilitate the management of database backups?

hermesalvesbr avatar Sep 07 '22 19:09 hermesalvesbr

Hi,

Elephant Shed is mostly based on systemd units, including service and timer units that run pgbackrest full and incremental backups. As such, it will work for running backups of 8 clusters on a machine. (If you mean 8 databases in one cluster, then it's only one backup from pgbackrest's view.)

There is some monitoring in the form that you can see the logs of the backup runs, but we don't have red/green lights in the cluster overview to show the backup status. Nor is there any automated restore or verification mechanism.

If you are running nagios/icinga/etc, there's check_pgbackrest, but Elephant Shed doesn't include a nagios interface, so you have to hook that up yourself.

I'm not aware of a web frontend/panel for pgbackrest.

We should work on exposing the backup status in the cluster overview page in ES - I'll keep your issue open as a reminder to do that.

Christoph

df7cb avatar Sep 09 '22 13:09 df7cb