PostgreSQL Database Monitoring in Zabbix

[@kirtikhohal5025]

Thank you so much Boss, this was more than amazing.

[@jeromemoss1267]

Great Tutorial. Thank you for this.

[@sakenabdikarimov5588]

Thank you! how to set up postgresql monitoring using active agent

[@beretest-wv1je]

Great video! Any idea how to set this up for Zabbix agent 2? I'm following the instructions in the Zabbix docs but I can't seem to get it to work

[@sbcode]

Sorry, i never use Zabbix Agent 2. I never had a need for it since i was able to do everything with traditional agent

[@kirtikhohal5025]

I want to know through which items in the template "postgresql by zabbix agent", i can check the number of open connections and the VM size used by PGsql??

[@ulkonja]

excellent

[@Rishu-e6f6v]

Hi.... How to monitor tables in postgresql... We have 176 tables right.. Please help

[@vinay07sengar]

Hello Sir, how do check logs in PostgreSQL using 6.4 Zabbix please help me thank you

[@sbcode]

That's a days work. I charge £500 a day

[@aichaelyebadri4362]

Hallo, I upgraded Zabbix to 6.4 last time. But when I try to access via web browser I got this error message. How could I solve this? Error message: Zabbix database version does not match current requirements. Version of your database: 6000000. Required version: 6040000

[@sbcode]

sounds like you didn't upgrade the database. Anyway, I never upgrade, I always build a brand new Zabbix. So I can't help.

[@ariosinggihpermana]

Hi, do u know how to monitor DO,'s managed postgres with zabbix ?

[@sbcode]

since it is a DO managed service, you would need to use DO monitoring first, and then enable some API in the DO system that you could then read from it using Zabbix. Possibly something like "JSON API Monitoring with the HTTP Agent Item" sbcode.net/zabbix/item-http-agent/ Caveat. I don't know if DO exposes it's monitoring data through any API or you could write a stored procedure that runs every minute or so and logs system statistics to a table, and then read it into Zabbix using a system.run which calls a SQL query. I could do this but I am expensive, and it will take me a week to build something nice.

[@Takigatita9739]

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?

[@sbcode]

you didn't get odbc.log from the information in this video. You need to consult whatever documentation you used related to ODBC

[@vishutanuku311]

Hi.... How to monitor tables in postgresql... We have 176 tables right.. Please help