---
- name: Add PostgreSQL exporter to Prometheus
  hosts: 192.168.0.105
  become: yes

  tasks:
    - name: Add postgres_exporter scrape config
      blockinfile:
        path: /etc/prometheus/prometheus.yml
        insertafter: '  # Nginx metrics via nginx-prometheus-exporter'
        block: |2
          # PostgreSQL metrics via postgres_exporter
          - job_name: 'postgres-app2'
            scrape_interval: 15s
            scrape_timeout: 10s
            static_configs:
              - targets: ['192.168.0.111:9187']
                labels:
                  instance: 'app2'
                  service: 'postgresql'
                  job: 'postgres'
            metric_relabel_configs:
              - source_labels: [__address__]
                target_label: instance
              - source_labels: [__address__]
                regex: '([^:]+):\\d+'
                replacement: '${1}'
                target_label: host
        marker: "# {mark} ANSIBLE MANAGED BLOCK - postgres_exporter"
        backup: yes

    - name: Reload Prometheus
      systemd:
        name: prometheus
        state: reloaded