{"id":91969,"date":"2020-08-21T07:42:01","date_gmt":"2020-08-21T05:42:01","guid":{"rendered":"https:\/\/prohoster.info\/blog\/administrirovanie\/monitoring-postgresql-s-ispolzovaniem-zabbix"},"modified":"2020-08-21T07:42:01","modified_gmt":"2020-08-21T05:42:01","slug":"monitoring-postgresql-s-ispolzovaniem-zabbix","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sk\/blog\/administrirovanie\/monitoring-postgresql-s-ispolzovaniem-zabbix","title":{"rendered":"Monitorovanie PostgreSQL pomocou Zabbix","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p><img decoding=\"async\" alt=\"Monitorovanie PostgreSQL pomocou Zabbix\" src=\"\/wp-content\/uploads\/2020\/08\/b17310212ae5dc4da0ca7d78312ca8ef.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<em>Spr\u00e1va Dary Vilkovej pre Zabbix Meetup Online <\/em><\/p>\n<p><\/p>\n<p>Chcem v\u00e1s obozn\u00e1mi\u0165 s monitorovac\u00edm n\u00e1strojom PostgreSQL a opera\u010dn\u00e9ho syst\u00e9mu, ktor\u00fd vyv\u00edja na\u0161a spolo\u010dnos\u0165 s vyu\u017eit\u00edm Zabbixu. <\/p>\n<p><\/p>\n<p>Zabbix sme si vybrali ako monitorovac\u00ed n\u00e1stroj u\u017e d\u00e1vno, preto\u017ee ide o platformu s otvoren\u00fdm zdrojov\u00fdm k\u00f3dom, ktor\u00fa podporuje akt\u00edvna komunita a ktor\u00e1 je ve\u013emi popul\u00e1rna v Rusku. <\/p>\n<p><\/p>\n<p>Vytvorili sme akt\u00edvneho agenta \u2014 Mamonsu, ktor\u00fd poskytol flexibilnej\u0161ie monitorovanie, ako v tom \u010dase umo\u017e\u0148ovali \u0161tandardn\u00e9 n\u00e1stroje a zabezpe\u010doval zber metrick\u00fdch \u00fadajov a ich odosielanie na Zabbix Server. V na\u0161ej spolo\u010dnosti sa Mamonsu vyu\u017e\u00edva pri vykon\u00e1van\u00ed auditu.<\/p>\n<p><noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><\/p>\n<h2 id=\"mamonsu\">Mamonsu<\/h2>\n<p><\/p>\n<p>Mamonsu je akt\u00edvny agent (Zabbix Trapper) na monitorovanie PostgreSQL a opera\u010dn\u00e9ho syst\u00e9mu. Mamonsu (nap\u00edsan\u00fd v Pythone) umo\u017e\u0148uje nastavi\u0165 parametre monitorovania PostgreSQL a opera\u010dn\u00e9ho syst\u00e9mu za p\u00e4\u0165 min\u00fat. <\/p>\n<p><\/p>\n<p>Mamonsu m\u00e1 \u010fal\u0161ie n\u00e1stroje:<\/p>\n<p><\/p>\n<ul>\n<li>mamonsu tune \u2014 pr\u00edkaz, ktor\u00fd upravuje nastavenia v konfigura\u010dnom s\u00fabore PostgreSQL pre stroj, na ktor\u00fd je nain\u0161talovan\u00fd agent Mamonsu. <\/li>\n<li>mamonsu report \u2014 pr\u00edkaz, ktor\u00fd vytv\u00e1ra odpovede t\u00fdkaj\u00face sa opera\u010dn\u00e9ho syst\u00e9mu a PostgreSQL.<\/li>\n<\/ul>\n<p><\/p>\n<p>Mamonsu sa in\u0161taluje na server SODB, zbiera inform\u00e1cie, zostavuje ich do JSONu, ktor\u00fd odosiela na vizualiz\u00e1ciu na Zabbix Server, kde by mal existova\u0165 \u0161abl\u00f3na pre jeho metriky.<\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"Monitorovanie PostgreSQL pomocou Zabbix\" src=\"\/wp-content\/uploads\/2020\/08\/9d87556e4b31b27cb7698b32b5f1e2c4.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p><em>Sch\u00e9ma fungovania Mamonsu<\/em> <\/p>\n<p><\/p>\n<h3 id=\"vozmozhnosti-mamonsu\">Mo\u017enosti Mamonsu<\/h3>\n<p><\/p>\n<ul>\n<li><strong>Efekt\u00edvna pr\u00e1ca s PostgreSQL<\/strong>. Neust\u00e1le pripojenie k PostgreSQL \u2014 hlavn\u00e1 v\u00fdhoda Mamonsu. Maxim\u00e1lny po\u010det pripojen\u00ed zodpoved\u00e1 maxim\u00e1lnemu po\u010dtu datab\u00e1z, ku ktor\u00fdm sa prip\u00e1ja.<\/li>\n<li><strong>Roz\u0161\u00edrite\u013enos\u0165<\/strong>. Mamonsu je \u00faplne \u201epluginov\u00fd\u201c agent a v\u010faka fixnej \u0161trukt\u00fare ka\u017ed\u00e9ho pluginu a relat\u00edvnej jednoduchosti Pythona je mo\u017en\u00e9 sa \u013eahko nau\u010di\u0165 p\u00edsa\u0165 nov\u00e9 alebo upravova\u0165 \u0161tandardn\u00e9 pluginy, teda parametre zberu metrik.<\/li>\n<li><strong>\u0160irok\u00fd rozsah metr\u00edk na monitorovanie<\/strong> pre PostgreSQL vr\u00e1tane metr\u00edk \u0161pecifick\u00fdch roz\u0161\u00edren\u00ed. <\/li>\n<li>R\u00fdchle spustenie, <strong>dostupnos\u0165 \u201ez krabice\u201c<\/strong>.<\/li>\n<li><strong>Export \u0161abl\u00f3n a konfigura\u010dn\u00fdch s\u00faborov<\/strong>, ako aj nahr\u00e1vanie na Zabbix Server.<\/li>\n<li><strong>Krosplattformovos\u0165<\/strong>, \u010do je d\u00f4le\u017eit\u00e9 pre na\u0161ich z\u00e1kazn\u00edkov, ktor\u00ed pou\u017e\u00edvaj\u00fa r\u00f4zne distrib\u00facie Linuxu, vr\u00e1tane dom\u00e1cich.<\/li>\n<li><strong>Licencia BSD-clause<\/strong>.<\/li>\n<\/ul>\n<p><\/p>\n<p>V s\u00fa\u010dasnosti pon\u00fakame mno\u017estvo pluginov a v ka\u017edej nasleduj\u00facej verzii sa sna\u017e\u00edme prida\u0165 nie\u010do nov\u00e9.<\/p>\n<p><\/p>\n<ul>\n<li>14 pluginov pre PostgreSQL, <\/li>\n<li>8 pluginov pre OS Linux,<\/li>\n<li>4 pluginy pre OS Windows.<\/li>\n<\/ul>\n<p><\/p>\n<p>Mamonsu zbiera viac ako 110 metrik PostgreSQL a opera\u010dn\u00fdch syst\u00e9mov:<\/p>\n<p><\/p>\n<ul>\n<li>70 metr\u00edk PostgreSQL,<\/li>\n<li>40 metr\u00edk OS Linux,<\/li>\n<li>8 metr\u00edk OS Windows.<\/li>\n<\/ul>\n<p><\/p>\n<p>Hlavn\u00e9 metriky zah\u0155\u0148aj\u00fa dostupnos\u0165 DBMS, po\u010det pripojen\u00ed, ve\u013ekos\u0165 datab\u00e1zy, checkpointy, r\u00fdchlos\u0165 \u010d\u00edtania\/z\u00e1pisu, z\u00e1mky, po\u010det procesov autovakua a r\u00fdchlos\u0165 generovania WAL. Kompletn\u00fd zoznam dostupn\u00fdch metrik a podrobn\u00e9 popisy v\u0161etk\u00fdch n\u00e1strojov s\u00fa dostupn\u00e9 na <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/postgrespro\/mamonsu\">repozit\u00e1ri<\/a><\/noindex> webovej str\u00e1nke GitHub. <\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"Monitorovanie PostgreSQL pomocou Zabbix\" src=\"\/wp-content\/uploads\/2020\/08\/259cc7f1b6ab0cf137cef6b4e9a22c0f.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p><em>Zoznam dostupn\u00fdch metrik na webovej str\u00e1nke GitHub<\/em><\/p>\n<p><\/p>\n<h3 id=\"zapusk-mamonsu-za-5-minut\">Spustenie Mamonsu za 5 min\u00fat<\/h3>\n<p><\/p>\n<p>Pre nastavenie monitorovania PostgreSQL a opera\u010dn\u00e9ho syst\u00e9mu pomocou Mamonsu sta\u010d\u00ed 5 min\u00fat a 5 jednoduch\u00fdch krokov.<\/p>\n<p><\/p>\n<ol>\n<li><strong>In\u0161tal\u00e1cia Mamonsu<\/strong>. Mamonsu je mo\u017en\u00e9 zostavi\u0165 z zdrojov\u00e9ho k\u00f3du alebo vyu\u017ei\u0165 dostupn\u00e9 bal\u00edky.<\/li>\n<\/ol>\n<p><\/p>\n<p><code>$ git clone ... &amp;&amp; cd mamonsu &amp;&amp; python setup.py<\/code><\/p>\n<p><\/p>\n<p><code>build &amp;&amp; python setup.py install<\/code><\/p>\n<p><\/p>\n<ol>\n<li><strong>Nastavenie pripojen\u00ed<\/strong>. Je potrebn\u00e9 zada\u0165 parametre pripojenia k PostgreSQL a Zabbix Serveru v s\u00fabore agent.conf.<\/li>\n<\/ol>\n<p><\/p>\n<p><code>\/etc\/mamonsu\/agent.conf<\/code><\/p>\n<p><\/p>\n<ol>\n<li><strong>Export \u0161abl\u00f3ny do Zabbix Servera<\/strong>.<\/li>\n<\/ol>\n<p><\/p>\n<p><code>$ mamonsu zabbix template export<\/code><\/p>\n<p><\/p>\n<p><code>\/usr\/share\/mamonsu\/example.xml<\/code><\/p>\n<p><\/p>\n<ol>\n<li><strong>Pridanie uzla siete do Zabbix Servera<\/strong>. Exportovan\u00e1 \u0161abl\u00f3na bude automaticky pripojen\u00e1 k nov\u00e9mu uzlu siete na Zabbix Serveri.<\/li>\n<\/ol>\n<p><\/p>\n<p><code>$ mamonsu zabbix host create mamonsu-demo<\/code><\/p>\n<p><\/p>\n<ol>\n<li><strong>Spustenie<\/strong>.<\/li>\n<\/ol>\n<p><\/p>\n<p><code>$ service mamonsu start<\/code><\/p>\n<p><\/p>\n<h3 id=\"napravleniya-razvitiya-mamonsu\">Smerovanie rozvoja Mamonsu<\/h3>\n<p><\/p>\n<p>V r\u00e1mci rozvoja Mamonsu pl\u00e1nujeme vylep\u0161i\u0165 metriky a vytvori\u0165 nov\u00e9 pluginy, napr\u00edklad plugin na monitoring ve\u013ekosti jednotliv\u00fdch tabuliek. Pl\u00e1nujeme tie\u017e zlep\u0161i\u0165 a vytvori\u0165 \u010fal\u0161ie n\u00e1stroje a roz\u0161\u00edri\u0165 mo\u017enosti automatick\u00e9ho nastavenia cez pr\u00edkaz <strong>mamonsu tune<\/strong>. <\/p>\n<p><\/p>\n<h2 id=\"modul-monitoringa-postgresql-v-sostave-zabbix-agent-2\">Modul monitorovania PostgreSQL v r\u00e1mci Zabbix Agent 2<\/h2>\n<p><\/p>\n<p>Na pripojenie k PostgreSQL sa pou\u017e\u00edva r\u00fdchly a ob\u013e\u00faben\u00fd ovl\u00e1da\u010d <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/jackc\/pgx\">pgx<\/a><\/noindex> (PG ovl\u00e1da\u010d a n\u00e1strojov\u00fd bal\u00edk pre Go).<\/p>\n<p><\/p>\n<p>V s\u00fa\u010dasnosti pou\u017e\u00edvame dva rozhrania: Exporter, ktor\u00fd vyvol\u00e1va spracovate\u013e na z\u00e1klade k\u013e\u00fa\u010da, a Configurator Zabbix Agent 2, ktor\u00fd na\u010d\u00edtava a kontroluje parametre pripojenia s serverom zadan\u00e9 v konfigura\u010dnom s\u00fabore.<\/p>\n<p><\/p>\n<p>Sna\u017eili sme sa optimalizova\u0165 pr\u00e1cu DBMS tak, \u017ee sme skupinovali metriky a pou\u017e\u00edvali spracovate\u013e (handler) pre metriky a skupiny metrik, ako aj pou\u017eili skupiny metrik v JSON ako z\u00e1visl\u00e9 premenn\u00e9 (dependency items) a n\u00edzko\u00farov\u0148ov\u00e9 zis\u0165ovanie (discovery rules). <\/p>\n<p><\/p>\n<h3 id=\"osnovnye-vozmozhnosti\">Z\u00e1kladn\u00e9 funkcie<\/h3>\n<p><\/p>\n<ul>\n<li>uchovanie trval\u00e9ho pripojenia k PostgreSQL medzi kontrolami; <\/li>\n<li>podpora flexibiln\u00fdch intervalov prieskumu; <\/li>\n<li>kompatibilita s verziami PostgreSQL od 10 a Zabbix Serverom od verzie 4.4;<\/li>\n<li>mo\u017enos\u0165 pripojenia a monitorovania viacer\u00fdch in\u0161tanci\u00ed PostgreSQL naraz, preto\u017ee Zabbix Agent 2 umo\u017e\u0148uje vytv\u00e1ra\u0165 viacero rel\u00e1ci\u00ed.<\/li>\n<\/ul>\n<p><\/p>\n<h3 id=\"urovni-parametrov-podklyucheniya-k-postgresql\">\u00darovne parametrov pripojenia k PostgreSQL<\/h3>\n<p><\/p>\n<p>K dispoz\u00edcii s\u00fa celkovo tri \u00farovne parametrov pripojenia k PostgreSQL, t. j. \u00faloh a nastaven\u00ed:<\/p>\n<p><\/p>\n<ul>\n<li>Global,<\/li>\n<li>Sessions,<\/li>\n<li>Macros.<\/li>\n<\/ul>\n<p><\/p>\n<ol>\n<li>\n<p>Parametre Global s\u00fa nastaven\u00e9 na \u00farovni agenta, parametre Session a Macros ur\u010duj\u00fa parametre pripojenia k datab\u00e1ze.<\/p>\n<p>\n<\/li>\n<li>\n<p>Parametre pripojenia k PostgreSQL \u2014 Sessions s\u00fa nastaven\u00e9 v s\u00fabore <strong>zabbix_agent2.conf<\/strong>. <\/p>\n<p>\n<\/li>\n<\/ol>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"Monitorovanie PostgreSQL pomocou Zabbix\" src=\"\/wp-content\/uploads\/2020\/08\/d88abf88cb106e81f0e7eb23a1d4a193.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p><em>Parametre pripojenia k PostgreSQL \u2014 Sessions<\/em><\/p>\n<p><\/p>\n<ul>\n<li>Po k\u013e\u00fa\u010dovom slove <strong>Sessions<\/strong> sa uv\u00e1dza jedine\u010dn\u00e9 meno rel\u00e1cie, ktor\u00e9 mus\u00ed by\u0165 uveden\u00e9 v k\u013e\u00fa\u010di (\u0161abl\u00f3ne). <\/li>\n<li>Parametre <strong>URI<\/strong> a <strong>UserName<\/strong> s\u00fa povinn\u00e9 pre ka\u017ed\u00fa rel\u00e1ciu. <\/li>\n<li>Ak nie je zadan\u00e9 meno datab\u00e1zy, pou\u017e\u00edva sa predvolen\u00e9 meno datab\u00e1zy pre v\u0161etky rel\u00e1cie pre PostgreSQL, ktor\u00e9 je tie\u017e nastaven\u00e9 v konfigura\u010dnom s\u00fabore.<\/li>\n<\/ul>\n<p><\/p>\n<ol>\n<li>Parametre pripojenia k PostgreSQL \u2014 Macros s\u00fa nastaven\u00e9 v k\u013e\u00fa\u010di metriky v \u0161abl\u00f3ne (podobne ako v Zabbix Agent 1), t. j. s\u00fa vytvoren\u00e9 v \u0161abl\u00f3ne a n\u00e1sledne uveden\u00e9 ako parametre v k\u013e\u00fa\u010di. Pri tom je sekvencia makier fixn\u00e1, t. j. napr\u00edklad <strong>URI<\/strong> sa v\u017edy uv\u00e1dza na prvom mieste.<\/li>\n<\/ol>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"Monitorovanie PostgreSQL pomocou Zabbix\" src=\"\/wp-content\/uploads\/2020\/08\/3918b9de0118f901e916542f955bd17b.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p><em>Parametre pripojenia k PostgreSQL \u2014 Macros<\/em> <\/p>\n<p><\/p>\n<p>Modul monitorovania PostgreSQL obsahuje u\u017e viac ako 95 metrik, ktor\u00e9 umo\u017e\u0148uj\u00fa pokry\u0165 pomerne \u0161irok\u00fd okruh parametrov PostgreSQL, vr\u00e1tane:<\/p>\n<p><\/p>\n<ul>\n<li>po\u010dtu pripojen\u00ed,<\/li>\n<li>objemu datab\u00e1z, <\/li>\n<li>archiv\u00e1cie wal-s\u00faborov,<\/li>\n<li>kontroln\u00fdch bodov,<\/li>\n<li>po\u010dtu \"naf\u00faknut\u00fdch\" tabuliek,<\/li>\n<li>stavu replik\u00e1cie,<\/li>\n<li>zaost\u00e1vania repliky.<\/li>\n<\/ul>\n<p><\/p>\n<p>Metriky PostgreSQL nie s\u00fa informat\u00edvne bez parametrov opera\u010dn\u00e9ho syst\u00e9mu. Zabbix Agent 2 u\u017e v\u0161ak dok\u00e1\u017ee zbiera\u0165 parametre opera\u010dn\u00e9ho syst\u00e9mu, tak\u017ee na z\u00edskanie celkov\u00e9ho obrazu jednoducho pripoj\u00edme k uzlu siete potrebn\u00e9 \u0161abl\u00f3ny.<\/p>\n<p><\/p>\n<h3 id=\"obrabotchik-handler\">Handler<\/h3>\n<p><\/p>\n<p>Handler \u2014 z\u00e1kladn\u00e1 jednotka modulu, v ktorej sa vykon\u00e1va samotn\u00fd dotaz a ktor\u00e1 umo\u017e\u0148uje z\u00edskava\u0165 metriky.<\/p>\n<p><\/p>\n<p>Aby sme z\u00edskali jednoduch\u00fa metriku:<\/p>\n<p><\/p>\n<ol>\n<li>Vytvor\u00edme s\u00fabor na z\u00edskanie novej metriky:<\/li>\n<\/ol>\n<p><\/p>\n<p><strong>zabbix\/src\/go\/plugins\/postgres\/handler_uptime.go<\/strong><\/p>\n<p><\/p>\n<ol>\n<li>Pripoj\u00edme bal\u00edk a uvedieme jedine\u010dn\u00fd k\u013e\u00fa\u010d (k\u013e\u00fa\u010de) metr\u00edk:<\/li>\n<\/ol>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"Monitorovanie PostgreSQL pomocou Zabbix\" src=\"\/wp-content\/uploads\/2020\/08\/692acc55377c18ee37a9e1d426ebeccb.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<ol>\n<li>Vytvor\u00edme handler s dotazom, t. j. iniciujeme premenn\u00fa, v ktorej bude v\u00fdsledok:<\/li>\n<\/ol>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"Monitorovanie PostgreSQL pomocou Zabbix\" src=\"\/wp-content\/uploads\/2020\/08\/79e10e34edb78942acb6a264896be12d.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<ol>\n<li>vykon\u00e1me dotaz:<\/li>\n<\/ol>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"Monitorovanie PostgreSQL pomocou Zabbix\" src=\"\/wp-content\/uploads\/2020\/08\/b7555bba37978302337ea0093dd1bb5c.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>Je potrebn\u00e9 skontrolova\u0165 dotaz na pr\u00edtomnos\u0165 ch\u00fdb, po \u010dom bude v\u00fdsledok zachyten\u00fd procesom Zabbix Agent 2. <\/p>\n<p><\/p>\n<ol>\n<li>Registrovaniu k\u013e\u00fa\u010da novej metriky:<\/li>\n<\/ol>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"Monitorovanie PostgreSQL pomocou Zabbix\" src=\"\/wp-content\/uploads\/2020\/08\/63256811903feacc5cf88e0a272aebd9.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>Po registr\u00e1cii metriky je mo\u017en\u00e9 prekompilova\u0165 agenta s novou metrikou.<\/p>\n<p><\/p>\n<p>Modul je k dispoz\u00edcii od verzie Zabbix 5.0 na webovej str\u00e1nke <noindex><a rel=\"nofollow\" href=\"https:\/\/www.zabbix.com\/download\">https:\/\/www.zabbix.com\/download<\/a><\/noindex>. V tejto verzii Zabbix sa parametre nastavuj\u00fa samostatne cez host a port. Vo verzii Zabbix 5.0.2, ktor\u00e1 bude \u010doskoro vydan\u00e1, bud\u00fa parametre pripojenia zkomponovan\u00e9 do jedn\u00e9ho URI.<\/p>\n<p><\/p>\n<p>\u010eakujem za pozornos\u0165! <\/p>\n<p><\/p>\n<h2 id=\"poleznye-ssylki\">U\u017eito\u010dn\u00e9 odkazy<\/h2>\n<p><\/p>\n<p><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/postgrespro\/mamonsu\">GitHub Mamonsu<\/a><\/noindex><\/p>\n<p><\/p>\n<p><noindex><a rel=\"nofollow\" href=\"https:\/\/postgrespro.ru\/docs\/postgrespro\/11\/mamonsu\">Dokument\u00e1cia k Mamonsu<\/a><\/noindex><\/p>\n<p><\/p>\n<p><noindex><a rel=\"nofollow\" href=\"https:\/\/git.zabbix.com\/projects\/ZBX\/repos\/zabbix\/browse\/src\/go\/plugins\/postgres\">Zabbix Git<\/a><\/noindex><\/p>\n<p>Zdroj: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/company\/zabbix\/blog\/515816\/\">habr.com<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u0414\u043e\u043a\u043b\u0430\u0434 \u0414\u0430\u0440\u044c\u0438 \u0412\u0438\u043b\u043a\u043e\u0432\u043e\u0439 \u0434\u043b\u044f Zabbix Meetup Online \u042f \u0445\u043e\u0447\u0443 \u043f\u043e\u0437\u043d\u0430\u043a\u043e\u043c\u0438\u0442\u044c \u0432\u0430\u0441 \u0441\u043e \u0441\u0440\u0435\u0434\u0441\u0442\u0432\u043e\u043c \u043c\u043e\u043d\u0438\u0442\u043e\u0440\u0438\u043d\u0433\u0430 PostgreSQL \u0438 \u043e\u043f\u0435\u0440\u0430\u0446\u0438\u043e\u043d\u043d\u043e\u0439 \u0441\u0438\u0441\u0442\u0435\u043c\u044b, \u043a\u043e\u0442\u043e\u0440\u043e\u0435 \u0440\u0430\u0437\u0440\u0430\u0431\u0430\u0442\u044b\u0432\u0430\u0435\u0442\u0441\u044f \u043d\u0430\u0448\u0435\u0439 \u043a\u043e\u043c\u043f\u0430\u043d\u0438\u0435\u0439 \u0441 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0435\u043c Zabbix. \u041c\u044b \u0432\u044b\u0431\u0440\u0430\u043b\u0438 Zabbix \u0432 \u043a\u0430\u0447\u0435\u0441\u0442\u0432\u0435 \u0441\u0440\u0435\u0434\u0441\u0442\u0432\u0430 \u043c\u043e\u043d\u0438\u0442\u043e\u0440\u0438\u043d\u0433\u0430 \u0443\u0436\u0435 \u0434\u0430\u0432\u043d\u043e, \u043f\u043e\u0442\u043e\u043c\u0443 \u0447\u0442\u043e \u044d\u0442\u043e \u043f\u043b\u0430\u0442\u0444\u043e\u0440\u043c\u0430 \u0441 \u043e\u0442\u043a\u0440\u044b\u0442\u044b\u043c \u0438\u0441\u0445\u043e\u0434\u043d\u044b\u043c \u043a\u043e\u0434\u043e\u043c, \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u0438\u0432\u0430\u0435\u043c\u0430\u044f \u0430\u043a\u0442\u0438\u0432\u043d\u044b\u043c \u0441\u043e\u043e\u0431\u0449\u0435\u0441\u0442\u0432\u043e\u043c, \u043a\u043e\u0442\u043e\u0440\u0430\u044f \u043f\u043e\u043b\u044c\u0437\u0443\u0435\u0442\u0441\u044f \u0431\u043e\u043b\u044c\u0448\u043e\u0439 \u043f\u043e\u043f\u0443\u043b\u044f\u0440\u043d\u043e\u0441\u0442\u044c\u044e \u0432 \u0420\u043e\u0441\u0441\u0438\u0438. \u041c\u044b \u0441\u043e\u0437\u0434\u0430\u043b\u0438 \u0430\u043a\u0442\u0438\u0432\u043d\u044b\u0439 \u0430\u0433\u0435\u043d\u0442 [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":91970,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[688],"tags":[],"class_list":["post-91969","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-administrirovanie"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.4 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u0414\u043e\u043a\u043b\u0430\u0434 \u0414\u0430\u0440\u044c\u0438 \u0412\u0438\u043b\u043a\u043e\u0432\u043e\u0439 \u0434\u043b\u044f Zabbix Meetup.\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Yuri Gagarin\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/prohoster.info\/sk\/blog\/administrirovanie\/monitoring-postgresql-s-ispolzovaniem-zabbix\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.4\" \/>\n\t\t<meta property=\"og:locale\" content=\"sk_SK\" \/>\n\t\t<meta property=\"og:site_name\" content=\"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"\ud83e\udd47\u041c\u043e\u043d\u0438\u0442\u043e\u0440\u0438\u043d\u0433 PostgreSQL \u0441 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0435\u043c Zabbix | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u0414\u043e\u043a\u043b\u0430\u0434 \u0414\u0430\u0440\u044c\u0438 \u0412\u0438\u043b\u043a\u043e\u0432\u043e\u0439 \u0434\u043b\u044f Zabbix Meetup.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/sk\/blog\/administrirovanie\/monitoring-postgresql-s-ispolzovaniem-zabbix\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:width\" content=\"350\" \/>\n\t\t<meta property=\"og:image:height\" content=\"350\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2020-08-21T05:42:01+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-08-21T05:42:01+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\ud83e\udd47Monitorovanie PostgreSQL pomocou Zabbix | ProHoster","description":"Predn\u00e1\u0161ka Darii Vilkovej na Zabbix Meetup.","canonical_url":"https:\/\/prohoster.info\/sk\/blog\/administrirovanie\/monitoring-postgresql-s-ispolzovaniem-zabbix","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"sk_SK","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47\u041c\u043e\u043d\u0438\u0442\u043e\u0440\u0438\u043d\u0433 PostgreSQL \u0441 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0435\u043c Zabbix | ProHoster","og:description":"\u0414\u043e\u043a\u043b\u0430\u0434 \u0414\u0430\u0440\u044c\u0438 \u0412\u0438\u043b\u043a\u043e\u0432\u043e\u0439 \u0434\u043b\u044f Zabbix Meetup.","og:url":"https:\/\/prohoster.info\/sk\/blog\/administrirovanie\/monitoring-postgresql-s-ispolzovaniem-zabbix","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2020-08-21T05:42:01+00:00","article:modified_time":"2020-08-21T05:42:01+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"91969","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":null,"breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-02-28 10:20:01","updated":"2022-09-28 12:43:55","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/posts\/91969","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/comments?post=91969"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/posts\/91969\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/media\/91970"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/media?parent=91969"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/categories?post=91969"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/tags?post=91969"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}