Monitoring Postgresql with Grafana & Prometheus in Docker

Monitoring Host with Grafana & Prometheus in Docker
위 진행에 이어서 작성됨

Postgresql-Exporter 실행

docker run --net host -d -e DATA_SOURCE_NAME="postgresql://user:password@@192.168.0.245:5433/so?sslmode=disable" quay.io/prometheuscommunity/postgres-exporter:v0.11.0

prometheus.yaml에 postgresql-exporter 추가 후 Prometheus container 재시작

• prometheus.yml 파일 수정

 vi /home/monitor/prometheus.yml
 
 #추가
   - job_name: "postgresql-db-status"

    # metrics_path defaults to '/metrics'
    # scheme defaults to 'http'.

    static_configs:
      - targets: ["192.168.0.245:9187"]

• Prometheus 재시작

docker restart [container id] 

• Prometheus target 확인
  

• Importing Postgresql dashboard
  

• 완료
  

참고