PostgreSQL Monitoring With ZABBIX
HTML-код
- Опубликовано: 10 июл 2024
- PostgreSQL database monitoring for free with an open-source monitoring tool called Zabbix. Installation and configuration take only a few minutes. After that, you are ready to receive multiple essential PostgreSQL database engine metrics to keep an eye on.
☕ In case if you want to support this content with coffee:
☕ www.buymeacoffee.com/dmitryla...
👋 SOCIAL MEDIA
📹 TWITTER - @RealDeimons
🔔 INSTAGRAM - / dmitrylambert
📫 Sign Up For Newsletter And Don't Miss Out on Anything
📫 tinyurl.com/4sz2ewfb 
Наука
Hi Dimitry,
thanks for that helpful video!
What do i have to do to monitor multiple Instances with different ports on my postgresql-Database-Server? When i clone the template the usermacros seem not to be clearly identified with the instance. Or do need a discover rule for instances?
Thanks in advance!
whats the diference between the userparameters and agent2?
Hi Dimitry, is there solution for monitoring the postgresql db hosted on Windows server?
Hi Dimitry,
Thanks for your videos, Need a solution for AWS-RDS(PostgreSQL) Monitoring With ZABBIX.
Hi mr. Dimitry.
How can I do the same PostgreSQL database monitoring with Zabbix Agents for AWS RDS environment which doesn't have a Zabbix Agents installed.
Amigo una consulta estoy intentando monitorear una pase postgres pero no le reconoce a la partición pgsql por qué tiene un permiso 700 cómo puedo que el zabbix pueda reconocer la partición .. sin cambiar el permiso en la bdd
Zabbix 4.2
I love you Dimitry.
Thanks. Can I suggest a topic : How to develop a Plugin for Zabbix Agent 2.
Well.. you need to be able to write on GO :)
That's not something I am able to do, so can't teach you anything there
Hi Dmitry, a question not related to PostgreSQL but to graphs...I have a web scenario which calls an api which can return either of these response codes - 200, 404, 500, 503). Now, I want to have a graph which would show the aggregation of these response codes individually, i.e., the graph should show the count of the number of 200s, number of 404s, etc for any time period. How can I achieve this? Thanks in advance!
you can try to count that response time with curl
@@dwieztro6748 Thats not going to tell him much about the distribution of response codes.
Faced the problem "PostgreSQL: Service is down"
although I receive data from the database
Are there any solutions?
Hi Dimitri! Can you make this video but for WIndows Agent?
How to configure on remote host
First of all, thank you for all your videos they helped me a lot, is there any chance that you show us how to install Zabbix with NGINX instead of httpd? :(
Just follow Downloads section in zabbix.com, it offers installation steps with nginx
How to install zabbix templates for postgresql
Greetings, for some reason I'm facing a problem with the items.
Preprocessing failed for: psql: error: FATAL: password authentication failed for user "zbx_monitor"
1. Failed: cannot extract value from json by path "$.buffers_alloc": cannot parse as a valid JSON object: invalid object format, expected opening character '{' or '[' at: 'psql: error: FATAL: password authentication failed for user "zbx_monitor"'
Zabbix version 5.0, PostgreSQL version 13. I checked the .pgpass file and both the permissions and password in the file are fine. Any suggestions?
Could you find a solution?
i think this configuration is not working anymore because the Postgresql by user parameter doesn't exist anymore in the 6.0
why video is fuzzy?
Kāds varētu beidzot pateikt, kā monitorēt timescaledb darbību vai ar to viss ir kārtībā. Nekādi nevaru atrast šo momentu.
Can I add my own metrics?
Sure, this is just about built-in template. But you can extend it
Problem: PostgreSQL: Service is down
it works but this generates a file called odbc.log which quickly fills up my drive rendering my zabbix unusable. How can I avoid it?