{"id":16878,"date":"2021-12-03T14:15:00","date_gmt":"2021-12-03T13:15:00","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/open-source-monitoring-solutions-2-zabbix-agents-and-postgresql-monitoring\/"},"modified":"2021-12-03T14:15:00","modified_gmt":"2021-12-03T13:15:00","slug":"open-source-monitoring-solutions-2-zabbix-agents-and-postgresql-monitoring","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/open-source-monitoring-solutions-2-zabbix-agents-and-postgresql-monitoring\/","title":{"rendered":"Open source monitoring solutions (2) &#8211; Zabbix agents and PostgreSQL monitoring"},"content":{"rendered":"<p>By the end of the <a href=\"https:\/\/www.dbi-services.com\/blog\/open-source-monitoring-solutions-1-zabbix-server-setup\/\" target=\"_blank\" rel=\"noopener\">last post<\/a> we finished with a running Zabbix server which uses PostgreSQL as it&#8217;s back-end database. In addition a Zabbix agent is running on the same host, so the monitoring host itself is present in the Zabbix console. In this post will deploy the Zabbix agent on three PostgreSQL Patroni nodes and later on configure Zabbix to monitor the PostgreSQL instances. <\/p>\n<p><!--more--><\/p>\n<p>As the agent deployment works exactly the same, no matter the host, I&#8217;ll show it on one PostgreSQL\/Patroni host only. Just repeat that on the other nodes and you should be fine. The deployment of the agent from source code, is not much different than deploying the Zabbix. First of all get the source code:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">\npostgres@patroni1:\/home\/postgres\/ [pg141] wget https:\/\/cdn.zabbix.com\/zabbix\/sources\/stable\/5.4\/zabbix-5.4.7.tar.gz\npostgres@patroni1:\/home\/postgres\/ [pg141] tar axf zabbix-5.4.7.tar.gz \npostgres@patroni1:\/home\/postgres\/ [pg141] cd zabbix-5.4.7\/\n<\/pre>\n<p>The recent version of the <a href=\"https:\/\/blog.zabbix.com\/magic-of-new-zabbix-agent\/8460\/\" target=\"_blank\" rel=\"noopener\">Zabbix agent (v2)<\/a> is written in Go so this needs to be installed (and the other dependencies), before installing the agent. As Debian 11 comes with Go 1.15 which is too old for the agent, we need to fetch Go directly:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">\npostgres@patroni1:\/home\/postgres\/zabbix-5.4.7\/ [pg141] sudo apt install -y libpcre3-dev\npostgres@patroni1:\/home\/postgres\/zabbix-5.4.7\/ [pg141] wget https:\/\/go.dev\/dl\/go1.17.3.linux-amd64.tar.gz\npostgres@patroni1:\/home\/postgres\/zabbix-5.4.7\/ [pg141] tar axf go1.17.3.linux-amd64.tar.gz \npostgres@patroni1:\/home\/postgres\/zabbix-5.4.7\/ [pg141] sudo mv go \/usr\/local\/\npostgres@patroni1:\/home\/postgres\/zabbix-5.4.7\/ [pg141] export PATH=$PATH:\/usr\/local\/go\/bin\/\npostgres@patroni1:\/home\/postgres\/zabbix-5.4.7\/ [pg141] go version\ngo version go1.17.3 linux\/amd64\npostgres@patroni1:\/home\/postgres\/zabbix-5.4.7\/ [pg141] .\/configure --prefix=\/u01\/app\/postgres\/product\/zabbix_5.4.7 --enable-agent2\nchecking for a BSD-compatible install... \/usr\/bin\/install -c\nchecking whether build environment is sane... yes\nchecking for a thread-safe mkdir -p... \/usr\/bin\/mkdir -p\nchecking for gawk... gawk\nchecking whether make sets $(MAKE)... yes\n...\nconfig.status: creating man\/Makefile\nconfig.status: creating include\/config.h\nconfig.status: executing depfiles commands\n\n\nConfiguration:\n\n  Detected OS:           linux-gnu\n  Install path:          \/u01\/app\/postgres\/product\/zabbix_5.4.7\n  Compilation arch:      linux\n\n  Compiler:              cc\n  Compiler flags:         -g -O2 \n\n  Library-specific flags:\n\n  Enable server:         no\n\n  Enable proxy:          no\n\n  Enable agent:          no\n\n  Enable agent 2:        yes\n\n  Enable web service:    no\n\n  Enable Java gateway:   no\n\n  LDAP support:          no\n  IPv6 support:          no\n\n***********************************************************\n*            Now run 'make install'                       *\n*                                                         *\n*            Thank you for using Zabbix!                  *\n*                                  *\n***********************************************************\n<\/pre>\n<p>Ready to install:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">\npostgres@patroni1:\/home\/postgres\/zabbix-5.4.7\/ [pg141] make install\nMaking install in src\nmake[1]: Entering directory '\/home\/postgres\/zabbix-5.4.7\/src'\nMaking install in libs\nmake[2]: Entering directory '\/home\/postgres\/zabbix-5.4.7\/src\/libs'\nMaking install in zbxcrypto\n...\ngo: downloading github.com\/go-sql-driver\/mysql v1.5.0\ngo: downloading gopkg.in\/mgo.v2 v2.0.0-20190816093944-a6b53ec6cb22\ngo: downloading github.com\/go-ldap\/ldap v3.0.3+incompatible\ngo: downloading github.com\/godbus\/dbus v4.1.0+incompatible\n...\nmake[2]: Nothing to be done for 'install-exec-am'.\nmake[2]: Nothing to be done for 'install-data-am'.\nmake[2]: Leaving directory '\/home\/postgres\/zabbix-5.4.7'\nmake[1]: Leaving directory '\/home\/postgres\/zabbix-5.4.7'\npostgres@patroni1:\/home\/postgres\/zabbix-5.4.7\/ [pg141] \/u01\/app\/postgres\/product\/zabbix_5.4.7\/sbin\/zabbix_agent2 --version\nzabbix_agent2 (Zabbix) 5.4.7\nRevision 84dc2ec5dc 28 October 2021, compilation time: Nov 30 2021 13:37:39\n\nCopyright (C) 2021 Zabbix SIA\nLicense GPLv2+: GNU GPL version 2 or later .\nThis is free software: you are free to change and redistribute it according to\nthe license. There is NO WARRANTY, to the extent permitted by law.\nWe use the library Eclipse Paho (eclipse\/paho.mqtt.golang), which is\ndistributed under the terms of the Eclipse Distribution License 1.0 (The 3-Clause BSD License)\navailable at https:\/\/www.eclipse.org\/org\/documents\/edl-v10.php\n\nWe use the library go-modbus (goburrow\/modbus), which is\ndistributed under the terms of the 3-Clause BSD License\navailable at https:\/\/github.com\/goburrow\/modbus\/blob\/master\/LICENSE\n<\/pre>\n<p>That&#8217;s it. Adjust the configuration and create a systemd service definition:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">\npostgres@patroni1:\/home\/postgres\/zabbix-5.4.7\/ [pg141] ln -s \/u01\/app\/postgres\/product\/zabbix_5.4.7\/ \/u01\/app\/postgres\/product\/zabbix-current\npostgres@patroni1:\/home\/postgres\/zabbix-5.4.7\/ [pg141] egrep -v \"^$|^#\" \/u01\/app\/postgres\/product\/zabbix-current\/etc\/zabbix_agent2.conf\nPidFile=\/u01\/app\/postgres\/local\/dmk\/tmp\/zabbix_agent2.pid\nLogFile=\/u01\/app\/postgres\/local\/dmk\/log\/zabbix_agent2.log\nServer=192.168.100.173\nServerActive=192.168.100.173\nHostname=patroni1.it.dbi-services.com\nControlSocket=\/tmp\/agent.sock\npostgres@patroni1:\/home\/postgres\/zabbix-5.4.7\/ [pg141] cat \/etc\/systemd\/system\/zabbix-agent.service \n[Unit]\nDescription=dbi services zabbix agent service\nAfter=network.target,postgres-zabbix.service\n\n[Service]\nUser=postgres\nType=notify\nExecStart=\/u01\/app\/postgres\/product\/zabbix-current\/sbin\/zabbix_agent2 \nRestart=always\nRestartSec=10s\nLimitNOFILE=40000\n\n[Install]\nWantedBy=multi-user.target\n\npostgres@patroni1:\/home\/postgres\/zabbix-5.4.7\/ [pg141] sudo systemctl enable zabbix-agent.service \npostgres@patroni1:\/home\/postgres\/zabbix-5.4.7\/ [pg141] sudo reboot\npostgres@patroni1:\/home\/postgres\/ [pg141] systemctl status zabbix-agent.service \n\u25cf zabbix-agent.service - dbi services zabbix agent service\n     Loaded: loaded (\/etc\/systemd\/system\/zabbix-agent.service; enabled; vendor preset: enabled)\n     Active: activating (start) since Tue 2021-11-30 14:17:55 CET; 1min 28s ago\n   Main PID: 912 (zabbix_agent2)\n      Tasks: 5 (limit: 1133)\n     Memory: 12.8M\n        CPU: 39ms\n     CGroup: \/system.slice\/zabbix-agent.service\n             \u2514\u2500912 \/u01\/app\/postgres\/product\/zabbix-current\/sbin\/zabbix_agent2\n\nNov 30 14:17:55 patroni1 zabbix_agent2[912]: Starting Zabbix Agent 2 (5.4.7)\nNov 30 14:17:55 patroni1 zabbix_agent2[912]: Zabbix Agent2 hostname: [patroni1.it.dbi-services.com]\nNov 30 14:17:55 patroni1 zabbix_agent2[912]: Press Ctrl+C to exit.\n<\/pre>\n<p>Once this is done and the agent is running you can add the host to the Zabbix configuration:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/zabbix_conf-1.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/zabbix_conf-1.jpg\" alt=\"\" width=\"1200\" height=\"228\" class=\"aligncenter size-full wp-image-52842\" \/><\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/zabbix_conf2.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/zabbix_conf2.jpg\" alt=\"\" width=\"1179\" height=\"497\" class=\"aligncenter size-full wp-image-52843\" \/><\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/zabbix_conf3.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/zabbix_conf3.jpg\" alt=\"\" width=\"922\" height=\"269\" class=\"aligncenter size-full wp-image-52844\" \/><\/a><\/p>\n<p>Repeat all that for the remaining nodes and then you have a setup like this:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/zabbix_conf4.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/zabbix_conf4.jpg\" alt=\"\" width=\"1735\" height=\"605\" class=\"aligncenter size-full wp-image-52846\" \/><\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/zabbix_conf5.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/zabbix_conf5.jpg\" alt=\"\" width=\"1619\" height=\"422\" class=\"aligncenter size-full wp-image-52847\" \/><\/a><\/p>\n<p>Adding PostgreSQL metrics is just a matter of attaching the template to the hosts and a few moments later the metrics are there:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/zabbix_conf6.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/zabbix_conf6.jpg\" alt=\"\" width=\"903\" height=\"319\" class=\"aligncenter size-full wp-image-52849\" \/><\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/zabbix_conf7.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/zabbix_conf7.jpg\" alt=\"\" width=\"1436\" height=\"562\" class=\"aligncenter size-full wp-image-52850\" \/><\/a><\/p>\n<p>Easy and simple to setup.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>By the end of the last post we finished with a running Zabbix server which uses PostgreSQL as it&#8217;s back-end database. In addition a Zabbix agent is running on the same host, so the monitoring host itself is present in the Zabbix console. In this post will deploy the Zabbix agent on three PostgreSQL Patroni [&hellip;]<\/p>\n","protected":false},"author":29,"featured_media":16886,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[143,77,2430],"type_dbi":[],"class_list":["post-16878","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","tag-monitoring","tag-postgresql","tag-zabbix"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.5) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Open source monitoring solutions (2) - Zabbix agents and PostgreSQL monitoring - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/open-source-monitoring-solutions-2-zabbix-agents-and-postgresql-monitoring\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Open source monitoring solutions (2) - Zabbix agents and PostgreSQL monitoring\" \/>\n<meta property=\"og:description\" content=\"By the end of the last post we finished with a running Zabbix server which uses PostgreSQL as it&#8217;s back-end database. In addition a Zabbix agent is running on the same host, so the monitoring host itself is present in the Zabbix console. In this post will deploy the Zabbix agent on three PostgreSQL Patroni [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/open-source-monitoring-solutions-2-zabbix-agents-and-postgresql-monitoring\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2021-12-03T13:15:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/zabbix_conf.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1919\" \/>\n\t<meta property=\"og:image:height\" content=\"365\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Daniel Westermann\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@westermanndanie\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Daniel Westermann\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/open-source-monitoring-solutions-2-zabbix-agents-and-postgresql-monitoring\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/open-source-monitoring-solutions-2-zabbix-agents-and-postgresql-monitoring\\\/\"},\"author\":{\"name\":\"Daniel Westermann\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/8d08e9bd996a89bd75c0286cbabf3c66\"},\"headline\":\"Open source monitoring solutions (2) &#8211; Zabbix agents and PostgreSQL monitoring\",\"datePublished\":\"2021-12-03T13:15:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/open-source-monitoring-solutions-2-zabbix-agents-and-postgresql-monitoring\\\/\"},\"wordCount\":254,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/open-source-monitoring-solutions-2-zabbix-agents-and-postgresql-monitoring\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/zabbix_conf.png\",\"keywords\":[\"Monitoring\",\"PostgreSQL\",\"Zabbix\"],\"articleSection\":[\"Database Administration &amp; Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/open-source-monitoring-solutions-2-zabbix-agents-and-postgresql-monitoring\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/open-source-monitoring-solutions-2-zabbix-agents-and-postgresql-monitoring\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/open-source-monitoring-solutions-2-zabbix-agents-and-postgresql-monitoring\\\/\",\"name\":\"Open source monitoring solutions (2) - Zabbix agents and PostgreSQL monitoring - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/open-source-monitoring-solutions-2-zabbix-agents-and-postgresql-monitoring\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/open-source-monitoring-solutions-2-zabbix-agents-and-postgresql-monitoring\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/zabbix_conf.png\",\"datePublished\":\"2021-12-03T13:15:00+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/8d08e9bd996a89bd75c0286cbabf3c66\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/open-source-monitoring-solutions-2-zabbix-agents-and-postgresql-monitoring\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/open-source-monitoring-solutions-2-zabbix-agents-and-postgresql-monitoring\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/open-source-monitoring-solutions-2-zabbix-agents-and-postgresql-monitoring\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/zabbix_conf.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/zabbix_conf.png\",\"width\":1919,\"height\":365},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/open-source-monitoring-solutions-2-zabbix-agents-and-postgresql-monitoring\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Open source monitoring solutions (2) &#8211; Zabbix agents and PostgreSQL monitoring\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/8d08e9bd996a89bd75c0286cbabf3c66\",\"name\":\"Daniel Westermann\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g\",\"caption\":\"Daniel Westermann\"},\"description\":\"Daniel Westermann is Principal Consultant and Technology Leader Open Infrastructure at dbi services. He has more than 15 years of experience in management, engineering and optimization of databases and infrastructures, especially on Oracle and PostgreSQL. Since the beginning of his career, he has specialized in Oracle Technologies and is Oracle Certified Professional 12c and Oracle Certified Expert RAC\\\/GridInfra. Over time, Daniel has become increasingly interested in open source technologies, becoming \u201cTechnology Leader Open Infrastructure\u201d and PostgreSQL expert. \u00a0Based on community or EnterpriseDB tools, he develops and installs complex high available solutions with PostgreSQL. He is also a certified PostgreSQL Plus 9.0 Professional and a Postgres Advanced Server 9.4 Professional. He is a regular speaker at PostgreSQL conferences in Switzerland and Europe. Today Daniel is also supporting our customers on AWS services such as AWS RDS, database migrations into the cloud, EC2 and automated infrastructure management with AWS SSM (System Manager). He is a certified AWS Solutions Architect Professional. Prior to dbi services, Daniel was Management System Engineer at LC SYSTEMS-Engineering AG in Basel. Before that, he worked as Oracle Developper &amp;\u00a0Project Manager at Delta Energy Solutions AG in Basel (today Powel AG). Daniel holds a diploma in Business Informatics (DHBW, Germany). His branch-related experience mainly covers the pharma industry, the financial sector, energy, lottery and telecommunications.\",\"sameAs\":[\"https:\\\/\\\/x.com\\\/westermanndanie\"],\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/daniel-westermann\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Open source monitoring solutions (2) - Zabbix agents and PostgreSQL monitoring - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/open-source-monitoring-solutions-2-zabbix-agents-and-postgresql-monitoring\/","og_locale":"en_US","og_type":"article","og_title":"Open source monitoring solutions (2) - Zabbix agents and PostgreSQL monitoring","og_description":"By the end of the last post we finished with a running Zabbix server which uses PostgreSQL as it&#8217;s back-end database. In addition a Zabbix agent is running on the same host, so the monitoring host itself is present in the Zabbix console. In this post will deploy the Zabbix agent on three PostgreSQL Patroni [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/open-source-monitoring-solutions-2-zabbix-agents-and-postgresql-monitoring\/","og_site_name":"dbi Blog","article_published_time":"2021-12-03T13:15:00+00:00","og_image":[{"width":1919,"height":365,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/zabbix_conf.png","type":"image\/png"}],"author":"Daniel Westermann","twitter_card":"summary_large_image","twitter_creator":"@westermanndanie","twitter_misc":{"Written by":"Daniel Westermann","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/open-source-monitoring-solutions-2-zabbix-agents-and-postgresql-monitoring\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/open-source-monitoring-solutions-2-zabbix-agents-and-postgresql-monitoring\/"},"author":{"name":"Daniel Westermann","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66"},"headline":"Open source monitoring solutions (2) &#8211; Zabbix agents and PostgreSQL monitoring","datePublished":"2021-12-03T13:15:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/open-source-monitoring-solutions-2-zabbix-agents-and-postgresql-monitoring\/"},"wordCount":254,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/open-source-monitoring-solutions-2-zabbix-agents-and-postgresql-monitoring\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/zabbix_conf.png","keywords":["Monitoring","PostgreSQL","Zabbix"],"articleSection":["Database Administration &amp; Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/open-source-monitoring-solutions-2-zabbix-agents-and-postgresql-monitoring\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/open-source-monitoring-solutions-2-zabbix-agents-and-postgresql-monitoring\/","url":"https:\/\/www.dbi-services.com\/blog\/open-source-monitoring-solutions-2-zabbix-agents-and-postgresql-monitoring\/","name":"Open source monitoring solutions (2) - Zabbix agents and PostgreSQL monitoring - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/open-source-monitoring-solutions-2-zabbix-agents-and-postgresql-monitoring\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/open-source-monitoring-solutions-2-zabbix-agents-and-postgresql-monitoring\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/zabbix_conf.png","datePublished":"2021-12-03T13:15:00+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/open-source-monitoring-solutions-2-zabbix-agents-and-postgresql-monitoring\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/open-source-monitoring-solutions-2-zabbix-agents-and-postgresql-monitoring\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/open-source-monitoring-solutions-2-zabbix-agents-and-postgresql-monitoring\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/zabbix_conf.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/zabbix_conf.png","width":1919,"height":365},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/open-source-monitoring-solutions-2-zabbix-agents-and-postgresql-monitoring\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Open source monitoring solutions (2) &#8211; Zabbix agents and PostgreSQL monitoring"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66","name":"Daniel Westermann","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g","caption":"Daniel Westermann"},"description":"Daniel Westermann is Principal Consultant and Technology Leader Open Infrastructure at dbi services. He has more than 15 years of experience in management, engineering and optimization of databases and infrastructures, especially on Oracle and PostgreSQL. Since the beginning of his career, he has specialized in Oracle Technologies and is Oracle Certified Professional 12c and Oracle Certified Expert RAC\/GridInfra. Over time, Daniel has become increasingly interested in open source technologies, becoming \u201cTechnology Leader Open Infrastructure\u201d and PostgreSQL expert. \u00a0Based on community or EnterpriseDB tools, he develops and installs complex high available solutions with PostgreSQL. He is also a certified PostgreSQL Plus 9.0 Professional and a Postgres Advanced Server 9.4 Professional. He is a regular speaker at PostgreSQL conferences in Switzerland and Europe. Today Daniel is also supporting our customers on AWS services such as AWS RDS, database migrations into the cloud, EC2 and automated infrastructure management with AWS SSM (System Manager). He is a certified AWS Solutions Architect Professional. Prior to dbi services, Daniel was Management System Engineer at LC SYSTEMS-Engineering AG in Basel. Before that, he worked as Oracle Developper &amp;\u00a0Project Manager at Delta Energy Solutions AG in Basel (today Powel AG). Daniel holds a diploma in Business Informatics (DHBW, Germany). His branch-related experience mainly covers the pharma industry, the financial sector, energy, lottery and telecommunications.","sameAs":["https:\/\/x.com\/westermanndanie"],"url":"https:\/\/www.dbi-services.com\/blog\/author\/daniel-westermann\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/16878","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/29"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=16878"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/16878\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/16886"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=16878"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=16878"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=16878"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=16878"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}