feat: postgresql backup observability

Adds alertmanager rules for postgresql (based on https://github.com/prometheus-community/postgres_exporter/tree/master/postgres_mixin/alerts)