PG的wal归档失败监控

一、背景

预防与检测磁盘空间不足

二、实现方式

1. 修改pg exporter的query文件

vi /etc/prometheus/postgres_exporter_queries.yaml

# 增加如下信息
pg_sub_stat:                                                                                                                                                               
  query: |                                                                                                                                                                 
    select count(*) as sub_stat from pg_stat_subscription where latest_end_time is null                                                                                    
  metrics:                                                                                                                                                                 
    - sub_stat:                                                                                                                                                            
        usage: "GAUGE"                                                                                                                                                     
        description: "subscription stat"   
        

监控

Metrics

三、实现01

四、实现02

五、补充