We can use https://github.com/cloudnative-pg/charts/tree/cloudnative-pg-v0.21.4/charts/cluster/prometheus_rules as a basis to create alerts based on the prometheus metrics we scrape from each cluster.
Each monitor would alert by cluster name, to avoid having to re-create them every time we create a new PG cluster.
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Open | None | T362788 Migrate Airflow to the dse-k8s cluster | |||
| Resolved | BTullis | T364386 Validate postgres operator and Ceph integration | |||
| Resolved | brouberol | T372284 Create PostgreSQL monitors |
Change #1067338 had a related patch set uploaded (by Brouberol; author: Brouberol):
[operations/alerts@master] cloudnative-pg: add monitors for PG clusters
Change #1067340 had a related patch set uploaded (by Brouberol; author: Brouberol):
[operations/deployment-charts@master] cloudnative-pg: enable ingress traffic to the prometheus port
Change #1067340 merged by Brouberol:
[operations/deployment-charts@master] cloudnative-pg: enable ingress traffic to the prometheus port
Change #1067352 had a related patch set uploaded (by Brouberol; author: Brouberol):
[operations/deployment-charts@master] Upgrade airflow to 2.10.0
Change #1067352 abandoned by Brouberol:
[operations/deployment-charts@master] Upgrade airflow to 2.10.0
Reason:
This change has already gone through apparently
Change #1067338 merged by Brouberol:
[operations/alerts@master] cloudnative-pg: add monitors for PG clusters
Change #1080251 had a related patch set uploaded (by Brouberol; author: Brouberol):
[operations/alerts@master] cloudnative_pg: scope the WAL lag alert on the primary instance
Change #1080251 merged by Brouberol:
[operations/alerts@master] cloudnative_pg: scope the WAL lag alert on the primary instance
Change #1080293 had a related patch set uploaded (by Brouberol; author: Brouberol):
[operations/alerts@master] cloudnative_pg: add a cookbook to investigate wal archive issues
Change #1080293 merged by Brouberol:
[operations/alerts@master] cloudnative_pg: add a cookbook to investigate wal archive issues