{"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\/ro\/blog\/administrirovanie\/monitoring-postgresql-s-ispolzovaniem-zabbix","title":{"rendered":"Monitorizarea PostgreSQL folosind Zabbix","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p><img decoding=\"async\" alt=\"Monitorizarea PostgreSQL folosind Zabbix\" src=\"\/wp-content\/uploads\/2020\/08\/b17310212ae5dc4da0ca7d78312ca8ef.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<em>Prezentarea Dariei Vilkova pentru Zabbix Meetup Online <\/em><\/p>\n<p><\/p>\n<p>Vreau s\u0103 v\u0103 prezint un instrument de monitorizare pentru PostgreSQL \u0219i sistemul de operare, dezvoltat de compania noastr\u0103 folosind Zabbix. <\/p>\n<p><\/p>\n<p>Am ales Zabbix ca instrument de monitorizare cu mult timp \u00een urm\u0103, deoarece este o platform\u0103 open-source, sus\u021binut\u0103 de o comunitate activ\u0103, care este foarte popular\u0103 \u00een Rom\u00e2nia. <\/p>\n<p><\/p>\n<p>Am creat un agent activ \u2014 Mamonsu, care ofer\u0103 o monitorizare mai flexibil\u0103 dec\u00e2t ce permiteau instrumentele standard la momentul respectiv \u0219i asigura colectarea metrilor \u0219i trimiterea acestora c\u0103tre Zabbix Server. \u00cen compania noastr\u0103, Mamonsu este utilizat \u00een cadrul auditului.<\/p>\n<p><noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><\/p>\n<h2 id=\"mamonsu\">Mamonsu<\/h2>\n<p><\/p>\n<p>Mamonsu este un agent activ (Zabbix Trapper) pentru monitorizarea PostgreSQL \u0219i a sistemului de operare. Mamonsu (scris \u00een Python) permite configurarea parametrilor de monitorizare pentru PostgreSQL \u0219i sistemul de operare \u00een doar cinci minute. <\/p>\n<p><\/p>\n<p>Mamonsu dispune de instrumente suplimentare:<\/p>\n<p><\/p>\n<ul>\n<li>mamonsu tune \u2014 o comand\u0103 care editeaz\u0103 parametrii de configurare \u00een fi\u0219ierul de configurare PostgreSQL pentru ma\u0219ina pe care este instalat agentul Mamonsu. <\/li>\n<li>mamonsu report \u2014 o comand\u0103 care genereaz\u0103 r\u0103spunsuri despre sistemul de operare \u0219i PostgreSQL.<\/li>\n<\/ul>\n<p><\/p>\n<p>Mamonsu este instalat pe serverul SGBD, colecteaz\u0103 informa\u021bii, le structureaz\u0103 \u00een JSON, pe care \u00eel trimite pentru vizualizare pe Zabbix Server, unde trebuie s\u0103 existe un \u0219ablon pentru metrigile sale.<\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"Monitorizarea PostgreSQL folosind Zabbix\" src=\"\/wp-content\/uploads\/2020\/08\/9d87556e4b31b27cb7698b32b5f1e2c4.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p><em>Schema de func\u021bionare a Mamonsu<\/em> <\/p>\n<p><\/p>\n<h3 id=\"vozmozhnosti-mamonsu\">Capabilit\u0103\u021bile Mamonsu<\/h3>\n<p><\/p>\n<ul>\n<li><strong>Func\u021bionare eficient\u0103 cu PostgreSQL<\/strong>. Conexiunea continu\u0103 cu PostgreSQL este principalul avantaj al Mamonsu. \u00cen acest sens, num\u0103rul maxim de conexiuni este egal cu num\u0103rul maxim de baze de date la care se conecteaz\u0103.<\/li>\n<li><strong>Scalabilitate<\/strong>. Mamonsu este un agent complet \u201eplugin\u201d, \u0219i datorit\u0103 structurii fixe a fiec\u0103rui plugin \u0219i a relativit\u0103\u021bii u\u0219oarei \u00eenv\u0103\u021b\u0103ri a Python, este simplu s\u0103 \u00eenve\u021bi s\u0103 scrii noi sau s\u0103 editezi pluginuri standard, adic\u0103 parametrii de colectare a metrilor.<\/li>\n<li><strong>Acoperire larg\u0103 a metrilor pentru monitorizare<\/strong> inclusiv metrice specifice extensiilor pentru PotgreSQL. <\/li>\n<li>Lansare rapid\u0103, <strong>disponibilitate \u201edin cutie\u201d<\/strong>.<\/li>\n<li><strong>Expedierea \u0219abloanelor \u0219i a fi\u0219ierelor de configurare<\/strong>, precum \u0219i \u00eenc\u0103rcarea pe Zabbix Server.<\/li>\n<li><strong>Interoperabilitate<\/strong>, ceea ce este important pentru clien\u021bii no\u0219tri care utilizeaz\u0103 diverse distribu\u021bii Linux, inclusiv cele autohtone.<\/li>\n<li><strong>Licen\u021b\u0103 BSD-clause<\/strong>.<\/li>\n<\/ul>\n<p><\/p>\n<p>\u00cen prezent, oferim numeroase pluginuri \u0219i \u00een fiecare versiune urm\u0103toare \u00eencerc\u0103m s\u0103 ad\u0103ug\u0103m ceva nou.<\/p>\n<p><\/p>\n<ul>\n<li>14 pluginuri pentru PostgreSQL, <\/li>\n<li>8 pluginuri pentru OS Linux,<\/li>\n<li>4 pluginuri pentru OS Windows.<\/li>\n<\/ul>\n<p><\/p>\n<p>Mamonsu colecteaz\u0103 peste 110 metrici PostgreSQL \u0219i pentru sistemele de operare:<\/p>\n<p><\/p>\n<ul>\n<li>70 de metrici PostgreSQL,<\/li>\n<li>40 de metrici OS Linux,<\/li>\n<li>8 metrici OS Windows.<\/li>\n<\/ul>\n<p><\/p>\n<p>Metricile principale includ disponibilitatea bazelor de date, num\u0103rul de conexiuni, dimensiunea bazei de date, checkpoint-urile, viteza de citire\/scriere, blocajele, num\u0103rul de procese avacuum \u0219i viteza de generare WAL. Lista complet\u0103 a metricilor disponibile, precum \u0219i descrierea detaliat\u0103 a tuturor instrumentelor se g\u0103se\u0219te \u00een <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/postgrespro\/mamonsu\">repository<\/a><\/noindex> pe site-ul GitHub. <\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"Monitorizarea PostgreSQL folosind Zabbix\" src=\"\/wp-content\/uploads\/2020\/08\/259cc7f1b6ab0cf137cef6b4e9a22c0f.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p><em>Lista metricilor disponibile pe site-ul GitHub<\/em><\/p>\n<p><\/p>\n<h3 id=\"zapusk-mamonsu-za-5-minut\">Pornirea Mamonsu \u00een 5 minute<\/h3>\n<p><\/p>\n<p>Configura\u021bi monitorizarea PostgreSQL \u0219i a sistemului de operare folosind Mamonsu \u00een 5 minute, efectu\u00e2nd 5 pa\u0219i simpli.<\/p>\n<p><\/p>\n<ol>\n<li><strong>Instalarea Mamonsu<\/strong>. Mamonsu poate fi construit din surse sau utiliz\u00e2nd pachete disponibile.<\/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>Configurarea conexiunilor<\/strong>. Este necesar s\u0103 se defineasc\u0103 parametrii de conexiune cu PostgreSQL \u0219i serverul Zabbix \u00een fi\u0219ierul 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>Exportarea \u0219ablonului \u00een serverul Zabbix<\/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>Ad\u0103ugarea unui nod de re\u021bea \u00een serverul Zabbix<\/strong>. \u0218ablonul exportat va fi conectat automat la noul nod de re\u021bea pe serverul Zabbix.<\/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>Pornire<\/strong>.<\/li>\n<\/ol>\n<p><\/p>\n<p><code>$ service mamonsu start<\/code><\/p>\n<p><\/p>\n<h3 id=\"napravleniya-razvitiya-mamonsu\">Direc\u021biile de dezvoltare ale Mamonsu<\/h3>\n<p><\/p>\n<p>\u00cen cadrul dezvolt\u0103rii Mamonsu, pl\u0103nuim s\u0103 \u00eembun\u0103t\u0103\u021bim metricile \u0219i s\u0103 cre\u0103m noi pluginuri, de exemplu un plugin pentru monitorizarea dimensiunii anumitor tabele. De asemenea, inten\u021bion\u0103m s\u0103 \u00eembun\u0103t\u0103\u021bim \u0219i s\u0103 dezvolt\u0103m instrumente suplimentare, precum \u0219i s\u0103 extindem op\u021biunile de auto-configurare prin comanda <strong>mamonsu tune<\/strong>. <\/p>\n<p><\/p>\n<h2 id=\"modul-monitoringa-postgresql-v-sostave-zabbix-agent-2\">Modulul de monitorizare PostgreSQL ca parte a Zabbix Agent 2<\/h2>\n<p><\/p>\n<p>Pentru conexiunea cu PostgreSQL se folose\u0219te un driver rapid \u0219i popular <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/jackc\/pgx\">pgx<\/a><\/noindex> (driver \u0219i toolkit PG pentru Go).<\/p>\n<p><\/p>\n<p>\u00cen prezent folosim dou\u0103 interfe\u021be: Exporter, care apeleaz\u0103 handler-ul dup\u0103 cheie, \u0219i Configurator Zabbix Agent 2, care cite\u0219te \u0219i verific\u0103 parametrii de conexiune cu serverul, defini\u021bi \u00een fi\u0219ierul de configura\u021bie.<\/p>\n<p><\/p>\n<p>Am \u00eencercat s\u0103 optimiz\u0103m func\u021bionarea bazelor de date, grup\u00e2nd metricile \u0219i folosind un handler pentru metrici \u0219i grupuri de metrici, precum \u0219i utiliz\u00e2nd grupuri de metrici \u00een JSON ca elemente variabile dependente, \u0219i descoperire de nivel inferior. <\/p>\n<p><\/p>\n<h3 id=\"osnovnye-vozmozhnosti\">Func\u021bionalit\u0103\u021bi principale<\/h3>\n<p><\/p>\n<ul>\n<li>men\u021binerea unei conexiuni constante cu PostgreSQL \u00eentre verific\u0103ri; <\/li>\n<li>suport pentru intervale flexibile de sondare; <\/li>\n<li>compatibilitate cu versiunile PostgreSQL, \u00eencep\u00e2nd cu 10, \u0219i Zabbix Server, \u00eencep\u00e2nd cu versiunea 4.4;<\/li>\n<li>posibilitatea de a conecta \u0219i monitoriza mai multe instan\u021be PostgreSQL simultan, datorit\u0103 faptului c\u0103 Zabbix Agent 2 permite crearea mai multor sesiuni.<\/li>\n<\/ul>\n<p><\/p>\n<h3 id=\"urovni-parametrov-podklyucheniya-k-postgresql\">Nivelurile parametrilor de conectare la PostgreSQL<\/h3>\n<p><\/p>\n<p>Exist\u0103 \u00een total trei niveluri de parametri de conectare la PostgreSQL, adic\u0103 sarcini \u0219i configur\u0103ri:<\/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>Parametrii Global sunt defini\u021bi la nivelul agentului, iar parametrii Session \u0219i Macros definesc parametrii de conectare la baza de date.<\/p>\n<p>\n<\/li>\n<li>\n<p>Parametrii de conectare la PostgreSQL \u2014 Sessions sunt defini\u021bi \u00een fi\u0219ierul <strong>zabbix_agent2.conf<\/strong>. <\/p>\n<p>\n<\/li>\n<\/ol>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"Monitorizarea PostgreSQL folosind Zabbix\" src=\"\/wp-content\/uploads\/2020\/08\/d88abf88cb106e81f0e7eb23a1d4a193.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p><em>Parametrii de conectare la PostgreSQL \u2014 Sessions<\/em><\/p>\n<p><\/p>\n<ul>\n<li>Dup\u0103 cuv\u00e2ntul cheie <strong>Sessions<\/strong> se specific\u0103 un nume unic de sesiune, care trebuie men\u021bionat \u00een cheia (\u0219ablon). <\/li>\n<li>Set\u0103ri <strong>URI<\/strong> \u0219i <strong>UserName<\/strong> este obligatoriu pentru fiecare sesiune. <\/li>\n<li>Dac\u0103 numele bazei nu este specificat, se folose\u0219te numele general implicit al bazei pentru toate sesiunile PostgreSQL, care este de asemenea definit \u00een fi\u0219ierul de configurare.<\/li>\n<\/ul>\n<p><\/p>\n<ol>\n<li>Parametrii de conectare la PostgreSQL \u2014 Macros sunt defini\u021bi \u00een cheia metricii din \u0219ablon (asem\u0103n\u0103tor metodei utilizate \u00een Zabbix Agent 1), adic\u0103 sunt create \u00een \u0219ablon \u0219i ulterior sunt specificate ca parametri \u00een cheie. \u00cen aceast\u0103 situa\u021bie, secven\u021ba macro-urilor este fix\u0103, adic\u0103, de exemplu, <strong>URI<\/strong> este \u00eentotdeauna specificat\u0103 pe primul loc.<\/li>\n<\/ol>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"Monitorizarea PostgreSQL folosind Zabbix\" src=\"\/wp-content\/uploads\/2020\/08\/3918b9de0118f901e916542f955bd17b.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p><em>Parametrii de conectare la PostgreSQL \u2014 Macros<\/em> <\/p>\n<p><\/p>\n<p>Modulul de monitorizare PostgreSQL include deja peste 95 de metrici, care permit acoperirea unui spectru destul de larg de parametri PostgreSQL, inclusiv:<\/p>\n<p><\/p>\n<ul>\n<li>num\u0103rul de conexiuni,<\/li>\n<li>volumul bazelor de date, <\/li>\n<li>arhivarea fi\u0219ierelor wal,<\/li>\n<li>punctele de control,<\/li>\n<li>num\u0103rul de tabele \u201eumflate\u201d,<\/li>\n<li>starea replic\u0103rii,<\/li>\n<li>\u00eent\u00e2rzierea replicii.<\/li>\n<\/ul>\n<p><\/p>\n<p>Metricile PostgreSQL nu sunt informative f\u0103r\u0103 parametrii sistemului de operare. Dar Zabbix Agent 2 poate deja s\u0103 colecteze parametrii sistemului de operare, a\u0219a c\u0103 pentru a ob\u021bine o imagine complet\u0103, pur \u0219i simplu conect\u0103m la nodul re\u021belei \u0219abloanele necesare.<\/p>\n<p><\/p>\n<h3 id=\"obrabotchik-handler\">Handlerul (handler)<\/h3>\n<p><\/p>\n<p>Handlerul (handler) este unitatea principal\u0103 a modulului, \u00een care se execut\u0103 efectiv solicitarea \u0219i care permite ob\u021binerea metricilor.<\/p>\n<p><\/p>\n<p>Pentru a ob\u021bine o metric\u0103 simpl\u0103:<\/p>\n<p><\/p>\n<ol>\n<li>Cre\u0103m un fi\u0219ier pentru ob\u021binerea unei noi metrici:<\/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>Conect\u0103m pachetul \u0219i specific\u0103m o cheie unic\u0103 (chei) pentru metrici:<\/li>\n<\/ol>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"Monitorizarea PostgreSQL folosind Zabbix\" src=\"\/wp-content\/uploads\/2020\/08\/692acc55377c18ee37a9e1d426ebeccb.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<ol>\n<li>Cre\u0103m un handler (handler) cu solicitarea, adic\u0103 ini\u021biem o variabil\u0103 \u00een care se va afla rezultatul:<\/li>\n<\/ol>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"Monitorizarea PostgreSQL folosind Zabbix\" src=\"\/wp-content\/uploads\/2020\/08\/79e10e34edb78942acb6a264896be12d.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<ol>\n<li>Execut\u0103m solicitarea:<\/li>\n<\/ol>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"Monitorizarea PostgreSQL folosind Zabbix\" src=\"\/wp-content\/uploads\/2020\/08\/b7555bba37978302337ea0093dd1bb5c.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>Este necesar s\u0103 verific\u0103m solicitarea pentru erori, dup\u0103 care rezultatul va fi preluat de procesul Zabbix Agent 2. <\/p>\n<p><\/p>\n<ol>\n<li>\u00cenregistr\u0103m cheia noii metrici:<\/li>\n<\/ol>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"Monitorizarea PostgreSQL folosind Zabbix\" src=\"\/wp-content\/uploads\/2020\/08\/63256811903feacc5cf88e0a272aebd9.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>Dup\u0103 \u00eenregistrarea metrii, pute\u021bi reconstrui agentul cu noua metric\u0103.<\/p>\n<p><\/p>\n<p>Modulul este disponibil \u00eencep\u00e2nd cu Zabbix 5.0 pe site. <noindex><a rel=\"nofollow\" href=\"https:\/\/www.zabbix.com\/download\">https:\/\/www.zabbix.com\/download<\/a><\/noindex>. \u00cen aceast\u0103 versiune Zabbix, parametrii sunt defini\u021bi separat prin host \u0219i port. \u00cen versiunea Zabbix 5.0.2, care va fi lansat\u0103 \u00een cur\u00e2nd, parametrii de conectare vor fi compusa\u021bi \u00eentr-un singur URI.<\/p>\n<p><\/p>\n<p>V\u0103 mul\u021bumesc pentru aten\u021bie! <\/p>\n<p><\/p>\n<h2 id=\"poleznye-ssylki\">Linkuri utile<\/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\">Documenta\u021bia pentru 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>Sursa: <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.2.1 - 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\/ro\/blog\/administrirovanie\/monitoring-postgresql-s-ispolzovaniem-zabbix\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.2.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"ro_RO\" \/>\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\/ro\/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\udd47Monitorizarea PostgreSQL folosind Zabbix | ProHoster","description":"Prezentarea Dariei Vilkova pentru Zabbix Meetup.","canonical_url":"https:\/\/prohoster.info\/ro\/blog\/administrirovanie\/monitoring-postgresql-s-ispolzovaniem-zabbix","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"ro_RO","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\/ro\/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\/ro\/wp-json\/wp\/v2\/posts\/91969","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/comments?post=91969"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/posts\/91969\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/media\/91970"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/media?parent=91969"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/categories?post=91969"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/tags?post=91969"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}