PostgreSQL Monitoring With ZABBIX

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:

👋 SOCIAL MEDIA
📹 TWITTER - @RealDeimons

📫 Sign Up For Newsletter And Don't Miss Out on Anything

[samukarbrj]

whats the diference between the userparameters and agent2?

[juancarlospastillo]

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

[wagnervicente]

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.

[ИгорьЦаранок]

Faced the problem "PostgreSQL: Service is down"

although I receive data from the database
Are there any solutions?

[ommurthypadala]

Hi Dimitry,
Thanks for your videos, Need a solution for AWS-RDS(PostgreSQL) Monitoring With ZABBIX.

[mustaphaaissat]

Thanks. Can I suggest a topic : How to develop a Plugin for Zabbix Agent 2.

[swapnabomanaboina]

How to install zabbix templates for postgresql

[mhrcan]

Hi Dimitry, is there solution for monitoring the postgresql db hosted on Windows server?

[thomasfrings]

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!

[Takigatita]

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?

[denitthomas]

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!

[I-qbwg]

Hi Dimitri! Can you make this video but for WIndows Agent?

[xXxMajin]

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?

[elabeddhahbi]

i think this configuration is not working anymore because the Postgresql by user parameter doesn't exist anymore in the 6.0

[Bontita]

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? :(

[cenubit]

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.