Request: Export Prometheus Metric for backups

[amandahla]

Description

We create backups in PostgreSQL via action create-backup as a shell script in crontab.

It would be nice to have a way to monitor via Prometheus if backup failed or not as well as a backup counter.

[github-actions]

https://warthogs.atlassian.net/browse/DPE-3589

[taurus-forever]

Hi @amandahla , thank you for reaching us!

Our current design is to print clear and verbose log messages on default INFO level informing users about Successful and Failed backups (e.g. here on MySQL). Further all logs sent by COS to Loki and Alert rules can be triggered for the failed case clearly. Is this approach OK with you?

BTW @dragomirp , @marceloneppel I do not see the same commits for PostgreSQL (K8s), did we miss them OR they were part of initial implementation? This is something we need to check.