search

canonical / postgresql-operator

A Charmed Operator for running PostgreSQL on machines
https://charmhub.io/postgresql
Apache License 2.0
8 stars 19 forks source link

Request: Export Prometheus Metric for backups #356

Open amandahla opened 9 months ago

amandahla commented 9 months ago

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[bot] commented 9 months ago

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

taurus-forever commented 8 months ago

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.