How to Monitor PostgreSQL with Prometheus & Grafana ?

Рет қаралды 16,133

Avinashkumar - The Learning Destination

Күн бұрын

This tutorial helps you to monitor "POSTGRES" DB with "Prometheus & Grafana".
Follow the below steps:
sudo cp postgres_exporter /usr/local/bin
cd /opt/postgres_exporter
sudo nano postgres_exporter.env
DATA_SOURCE_NAME="postgresql://postgres:postgres@192.168.56.106:5432/?sslmode=disable"
sudo useradd -rs /bin/false postgres
vi /etc/systemd/system/postgres_exporter.service
[Unit]
Description=Prometheus exporter for Postgresql
Wants=network-online.target
After=network-online.target
[Service]
User=postgres
Group=postgres
WorkingDirectory=/opt/postgres_exporter
EnvironmentFile=/opt/postgres_exporter/postgres_exporter.env
ExecStart=/usr/local/bin/postgres_exporter --web.listen-address=192.168.56.106:9100 --web.telemetry-path=/metrics
Restart=always
[Install]
WantedBy=multi-user.target
sudo systemctl daemon-reload
sudo systemctl start postgres_exporter
sudo systemctl enable postgres_exporter
sudo systemctl status postgres_exporter
Steps to perform on Prometheus Server
systemctl stop prometheus
vi /etc/prometheus/prometheus.yml
systemctl start prometheus
systemctl status prometheus

Пікірлер: 30

@GabrielaLopezUrquiaga Жыл бұрын

Great video. The ports/services debugging fragment is very useful. Thanks!

@avinashkumar-thelearningdest Жыл бұрын

Thank you so much for your valuable words. That encouraging me a lot to keep produce good contents. Please help me to share my channel within your friends. Thanks 😊

@jalandharbehera2456 Жыл бұрын

Very much informative video.....easy to understand ❤❤

@avinashkumar-thelearningdest Жыл бұрын

Thank you so much, brother 😊

@MrPrajyod 2 жыл бұрын

how did you create prometheus data source in the Import? you have skipped this step. Can you show how to create Prometheus data source. While creating Prometheus Data Source I am getting error

@RaviShankar-xf4qx Жыл бұрын

Thanks a lot - it's helped me to configure postgres exporter - only problem i am facing was not getting data in grafana dashboard - just getting N/A - not sure what causing the problem.

@kevsermutaf3269 Жыл бұрын

Thank you :)

@avinashkumar-thelearningdest 10 ай бұрын

You're welcome!

@ahmedsecad1164 Жыл бұрын

Hey Avinash. Nice job. Wondering have you tried multiple PG DBs using multi-target exporter?

@janupriyo2096 Жыл бұрын

how i use docker for postgre_exporter?

@rafa2343 10 ай бұрын

Hello, I performed all step, but postgres_exported doesn't colleg statistics from database. At the end of vide when you show grafana we can only basic stat like CPU. There isn't any data connected to postgres stats lige pgwriter, shared_buffer etc. Can you please advice how configure it to enable to collect stats from postgres?

@user-sh2cv2qw5m 2 ай бұрын

I have found solution. grant pg_monitor to postgres; The best if you user other db user instead of postgres.

@subhashudata3416 2 жыл бұрын

Hi Avinash, In the end, in the dashboard, every metric is shown as "N/A". were you be able to resolve that issue?

@avinashkumar-thelearningdest 2 жыл бұрын

Hi Subhash, Thanks for your valuable comments. Actually the data is not getting fetched in Grafana probably you need to create Grafana user in postgresql DB & give appropriate permissions to it so it can fetch the data. That I have already mentioned at 15: 04. Let me know if you need any other help.

@jtf643 Жыл бұрын

@@avinashkumar-thelearningdest same problem here... can you help with the steps?

@akshadbhandula8641 Жыл бұрын

@@avinashkumar-thelearningdest Hi Avinash, please help with the data showing N/A.

@jithur2290 3 ай бұрын

Can you please help with the steps

@philbongborces Жыл бұрын

got 404 error @Avinashkumar . what is the download path?

@user-dl6cc4wi8j 2 жыл бұрын

its works ! but every metric show N/A. you can help me about create Grafana user in postgresql DB & give appropriate permissions to it so it can fetch the data ?

@jtf643 Жыл бұрын

same problem here :/ have solved the problem yet? how did you do it?