PostgreSQL Database Monitoring in Zabbix

Поділитися
Вставка
  • Опубліковано 2 лис 2024

КОМЕНТАРІ • 17

  • @kirtikhohal5025
    @kirtikhohal5025 Рік тому +1

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

  • @jeromemoss1267
    @jeromemoss1267 Рік тому +2

    Great Tutorial. Thank you for this.

  • @kirtikhohal5025
    @kirtikhohal5025 Рік тому +1

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

  • @beretest-wv1je
    @beretest-wv1je 11 місяців тому

    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
      @sbcode  11 місяців тому

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

  • @sakenabdikarimov5588
    @sakenabdikarimov5588 9 місяців тому

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

  • @Rishu-e6f6v
    @Rishu-e6f6v Рік тому +1

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

  • @vinay07sengar
    @vinay07sengar 10 місяців тому

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

    • @sbcode
      @sbcode  10 місяців тому

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

  • @ulkonja
    @ulkonja 4 місяці тому +1

    excellent

  • @ariosinggihpermana
    @ariosinggihpermana Рік тому

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

    • @sbcode
      @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.

  • @aichaelyebadri4362
    @aichaelyebadri4362 Рік тому +1

    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
      @sbcode  Рік тому +1

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

  • @Takigatita9739
    @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
      @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
    @vishutanuku311 Рік тому +1

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