PostgreSQL Database Monitoring in Zabbix
HTML-код
- Опубликовано: 30 июл 2024
- Channel Membership : / @sbcode
Documentation : sbcode.net/zabbix/postgresql-...
I show how to set up monitoring for a PostgreSQL database server in Zabbix.
Zabbix Course : sbcode.net/zabbix/
Course Coupons : sbcode.net/coupons
#zabbix
#postgres
00:00 PostgreSQL Database Monitoring in Zabbix
00:45 Install PostgreSQL
01:28 Install and Configure Zabbix Agent
03:45 Add PostgreSQL Read-Only User
04:58 Set Up Zabbix PostgreSQL Template Dependencies
07:45 Configure PostgreSQL pg_hba.conf File
08:47 Configure Host and Template in Zabbix
Thank you so much Boss, this was more than amazing.
Great Tutorial. Thank you for this.
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??
excellent
Thank you! how to set up postgresql monitoring using active agent
Hi.... How to monitor tables in postgresql... We have 176 tables right.. Please help
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
Sorry, i never use Zabbix Agent 2. I never had a need for it since i was able to do everything with traditional agent
Hello Sir, how do check logs in PostgreSQL using 6.4 Zabbix please help me thank you
That's a days work. I charge £500 a day
Hi, do u know how to monitor DO,'s managed postgres with zabbix ?
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.
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
sounds like you didn't upgrade the database.
Anyway, I never upgrade, I always build a brand new Zabbix. So I can't help.
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?
you didn't get odbc.log from the information in this video. You need to consult whatever documentation you used related to ODBC
Hi.... How to monitor tables in postgresql... We have 176 tables right.. Please help