{"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\/lv\/blog\/administrirovanie\/monitoring-postgresql-s-ispolzovaniem-zabbix","title":{"rendered":"PostgreSQL uzraudz\u012bba, izmantojot Zabbix","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p><img decoding=\"async\" alt=\"PostgreSQL uzraudz\u012bba, izmantojot Zabbix\" src=\"\/wp-content\/uploads\/2020\/08\/b17310212ae5dc4da0ca7d78312ca8ef.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<em>Daria Vilkova zi\u0146ojums Zabbix Meetup Online <\/em><\/p>\n<p><\/p>\n<p>Es v\u0113los iepaz\u012bstin\u0101t j\u016bs ar PostgreSQL un oper\u0113t\u0101jsist\u0113mas uzraudz\u012bbas r\u012bku, ko izstr\u0101d\u0101 m\u016bsu uz\u0146\u0113mums, izmantojot Zabbix. <\/p>\n<p><\/p>\n<p>M\u0113s jau sen esam izv\u0113l\u0113ju\u0161ies Zabbix par uzraudz\u012bbas r\u012bku, jo tas ir atv\u0113rt\u0101 koda platforma, ko atbalsta akt\u012bva kopiena un kas ir \u013coti popul\u0101ra Krievij\u0101. <\/p>\n<p><\/p>\n<p>M\u0113s izveidoj\u0101m akt\u012bvo a\u0123entu \u2014 Mamonsu, kas nodro\u0161in\u0101ja elast\u012bg\u0101ku uzraudz\u012bbu, nek\u0101 tolaik nodro\u0161in\u0101ja standarta r\u012bki, un nodro\u0161in\u0101ja metrikas v\u0101k\u0161anu un nos\u016bt\u012b\u0161anu uz Zabbix Serveri. M\u016bsu uz\u0146\u0113mum\u0101 Mamonsu tiek izmantots audita veik\u0161anai.<\/p>\n<p><noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><\/p>\n<h2 id=\"mamonsu\">Mamonsu<\/h2>\n<p><\/p>\n<p>Mamonsu ir akt\u012bvs a\u0123ents (Zabbix Trapper) PostgreSQL un oper\u0113t\u0101jsist\u0113mas uzraudz\u012bbai. Mamonsu (uzrakst\u012bts Python) \u013cauj iestat\u012bt PostgreSQL un oper\u0113t\u0101jsist\u0113mas uzraudz\u012bbas parametrus piec\u0101s min\u016bt\u0113s. <\/p>\n<p><\/p>\n<p>Mamonsu ir papildus r\u012bki:<\/p>\n<p><\/p>\n<ul>\n<li>mamonsu tune \u2014 komanda, kas redi\u0123\u0113 uzst\u0101d\u012bjumu parametrus PostgreSQL konfigur\u0101cijas fail\u0101 uz ma\u0161\u012bnas, kur\u0101 ir instal\u0113ts Mamonsu a\u0123ents. <\/li>\n<li>mamonsu report \u2014 komanda, kas izveido atskaites par oper\u0113t\u0101jsist\u0113mu un PostgreSQL.<\/li>\n<\/ul>\n<p><\/p>\n<p>Mamonsu tiek instal\u0113ts uz DBMS servera, v\u0101c inform\u0101ciju, apkopojot to JSON form\u0101t\u0101, ko nos\u016bta vizualiz\u0101cijai uz Zabbix Serveri, kuram j\u0101b\u016bt \u0161ablonam t\u0101s metrik\u0101m.<\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"PostgreSQL uzraudz\u012bba, izmantojot Zabbix\" src=\"\/wp-content\/uploads\/2020\/08\/9d87556e4b31b27cb7698b32b5f1e2c4.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p><em>Mamonsu darb\u012bbas sh\u0113ma<\/em> <\/p>\n<p><\/p>\n<h3 id=\"vozmozhnosti-mamonsu\">Mamonsu iesp\u0113jas<\/h3>\n<p><\/p>\n<ul>\n<li><strong>Efekt\u012bva sadarb\u012bba ar PostgreSQL<\/strong>. Past\u0101v\u012bga savienojuma izveide ar PostgreSQL ir galven\u0101 Mamonsu priek\u0161roc\u012bba. Taj\u0101 pa\u0161\u0101 laik\u0101 maksim\u0101lais savienojumu skaits ir vien\u0101ds ar maksim\u0101lo datu b\u0101zu skaitu, ar kur\u0101m tas savienojas.<\/li>\n<li><strong>Papla\u0161in\u0101m\u012bba<\/strong>. Mamonsu ir piln\u012bgi \u00abpiegul\u0113jams\u00bb a\u0123ents, un, pateicoties katra papla\u0161in\u0101juma fiks\u0113tajai strukt\u016brai un attiec\u012bgai Python vienk\u0101r\u0161\u012bbai, ir viegli iem\u0101c\u012bties rakst\u012bt jaunus vai redi\u0123\u0113t standarta papla\u0161in\u0101jumus, t.i., metrikas v\u0101k\u0161anas parametrus.<\/li>\n<li><strong>Pla\u0161a metrikas p\u0101rkl\u0101jums uzraudz\u012bbai<\/strong> t.sk. metrikas specifisk\u0101m papla\u0161in\u0101jum\u0101m PostgreSQL. <\/li>\n<li>\u0100tra palai\u0161ana, <strong>pieejam\u012bba 'kastei'<\/strong>.<\/li>\n<li><strong>Veid\u0146u un konfigur\u0101cijas failu izvade<\/strong>, k\u0101 ar\u012b iel\u0101de uz Zabbix Serveri.<\/li>\n<li><strong>Krosplatformit\u0101te<\/strong>, kas ir svar\u012bgi m\u016bsu klientiem, kuri izmanto da\u017e\u0101dus Linux izplat\u012bjumus, tostarp viet\u0113jos.<\/li>\n<li><strong>BSD-clause licence<\/strong>.<\/li>\n<\/ul>\n<p><\/p>\n<p>\u0160obr\u012bd m\u0113s pied\u0101v\u0101jam daudzus papla\u0161in\u0101jumus un katr\u0101 n\u0101kamaj\u0101 versij\u0101 cen\u0161amies pievienot kaut ko jaunu.<\/p>\n<p><\/p>\n<ul>\n<li>14 papla\u0161in\u0101jumi PostgreSQL, <\/li>\n<li>8 papla\u0161in\u0101jumi OS Linux,<\/li>\n<li>4 papla\u0161in\u0101jumi OS Windows.<\/li>\n<\/ul>\n<p><\/p>\n<p>Mamonsu apkopo vair\u0101k nek\u0101 110 PostgreSQL un oper\u0113t\u0101jsist\u0113mu metriku:<\/p>\n<p><\/p>\n<ul>\n<li>70 PostgreSQL metriku,<\/li>\n<li>40 OS Linux metriku,<\/li>\n<li>8 OS Windows metriku.<\/li>\n<\/ul>\n<p><\/p>\n<p>Galven\u0101s metriku iek\u013cauj datu b\u0101zes pieejam\u012bbu, piesl\u0113gumu skaitu, datu b\u0101zes izm\u0113ru, p\u0101rbaudes punktus, las\u012b\u0161anas\/ierakst\u012b\u0161anas \u0101trumu, blo\u0137\u0113\u0161anu, autom\u0101tisk\u0101s vakuuma procesu skaitu un WAL \u0123ener\u0113\u0161anas \u0101trumu. Pilns pieejamo metriku saraksts un detaliz\u0113ts visiem r\u012bkiem sniegt\u0101 apraksta ir pieejams <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/postgrespro\/mamonsu\">repozitorij\u0101<\/a><\/noindex> GitHub vietn\u0113. <\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"PostgreSQL uzraudz\u012bba, izmantojot Zabbix\" src=\"\/wp-content\/uploads\/2020\/08\/259cc7f1b6ab0cf137cef6b4e9a22c0f.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p><em>Pieejamo metriku saraksts GitHub vietn\u0113<\/em><\/p>\n<p><\/p>\n<h3 id=\"zapusk-mamonsu-za-5-minut\">Mamonsu palai\u0161ana 5 min\u016bt\u0113s<\/h3>\n<p><\/p>\n<p>Lai konfigur\u0113tu PostgreSQL un oper\u0113t\u0101jsist\u0113mas uzraudz\u012bbu, izmantojot Mamonsu, varat to izdar\u012bt 5 min\u016bt\u0113s, izpildot 5 vienk\u0101r\u0161as darb\u012bbas.<\/p>\n<p><\/p>\n<ol>\n<li><strong>Mamonsu instal\u0101cija<\/strong>. Mamonsu var izveidot no avotiem vai izmantot pieejamos pakotnes.<\/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>Savienojumu konfigur\u0101cija<\/strong>. Nepiecie\u0161ams nor\u0101d\u012bt savienojuma parametrus ar PostgreSQL un Zabbix Server agent.conf fail\u0101.<\/li>\n<\/ol>\n<p><\/p>\n<p><code>\/etc\/mamonsu\/agent.conf<\/code><\/p>\n<p><\/p>\n<ol>\n<li><strong>Veidnes eksport\u0113\u0161ana Zabbix Server<\/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>T\u012bkla mezgla pievieno\u0161ana Zabbix Server<\/strong>. Eksport\u0113t\u0101 veidne autom\u0101tiski tiks pievienota jaunajam t\u012bkla mezglam Zabbix Server.<\/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>S\u0101kt<\/strong>.<\/li>\n<\/ol>\n<p><\/p>\n<p><code>$ service mamonsu start<\/code><\/p>\n<p><\/p>\n<h3 id=\"napravleniya-razvitiya-mamonsu\">Mamonsu att\u012bst\u012bbas virzieni<\/h3>\n<p><\/p>\n<p>Att\u012bstot Mamonsu, pl\u0101nojam uzlabot metriku un izveidot jaunus spraud\u0146us, piem\u0113ram, spraudni atsevi\u0161\u0137u tabulu izm\u0113ra uzraudz\u012bbai. M\u0113s ar\u012b pl\u0101nojam uzlabot un izveidot papildu r\u012bkus, k\u0101 ar\u012b papla\u0161in\u0101t autom\u0101tisk\u0101s konfigur\u0101cijas iesp\u0113jas, izmantojot komandu <strong>mamonsu tune<\/strong>. <\/p>\n<p><\/p>\n<h2 id=\"modul-monitoringa-postgresql-v-sostave-zabbix-agent-2\">Zabbix Agent 2 ietvaros PostgreSQL uzraudz\u012bbas modulis<\/h2>\n<p><\/p>\n<p>Savienojumam ar PostgreSQL tiek izmantota \u0101tra un popul\u0101ra draiveris <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/jackc\/pgx\">pgx<\/a><\/noindex> (PG draiveris un r\u012bku komplekts Go valodai).<\/p>\n<p><\/p>\n<p>Pa\u0161laik m\u0113s izmantojam divus interfeisus: Eksporteris, kas izsauc apstr\u0101d\u0101t\u0101ju p\u0113c atsl\u0113gas, un Zabbix Agent 2 konfigur\u0113t\u0101js, kas lasa un p\u0101rbauda savienojuma parametrus ar serveri, kas nor\u0101d\u012bti konfigur\u0101cijas fail\u0101.<\/p>\n<p><\/p>\n<p>M\u0113s cent\u0101mies optimiz\u0113t datu b\u0101zes darbu, grup\u0113jot metriku un izmantojot apstr\u0101d\u0101t\u0101ju (handler) metriku un grupu metriku, k\u0101 ar\u012b izmantojot metriku grupas JSON k\u0101 atkar\u012bg\u0101s main\u012bg\u0101s (dependency items) un zemo l\u012bme\u0146u atkl\u0101\u0161anu (discovery rules). <\/p>\n<p><\/p>\n<h3 id=\"osnovnye-vozmozhnosti\">Galven\u0101s iesp\u0113jas<\/h3>\n<p><\/p>\n<ul>\n<li>past\u0101v\u012bga savienojuma saglab\u0101\u0161ana ar PostgreSQL starp p\u0101rbaud\u0113m; <\/li>\n<li>elast\u012bgu aptauju interv\u0101lu atbalsts; <\/li>\n<li>sader\u012bba ar PostgreSQL versij\u0101m no 10. un Zabbix Server, s\u0101kot no 4.4 versijas;<\/li>\n<li>Iesp\u0113ja vienlaikus savienot un uzraudz\u012bt vair\u0101kus PostgreSQL instancus, jo Zabbix Agent 2 \u013cauj veidot vair\u0101kas sesijas.<\/li>\n<\/ul>\n<p><\/p>\n<h3 id=\"urovni-parametrov-podklyucheniya-k-postgresql\">Savienojuma parametru l\u012bme\u0146i uz PostgreSQL<\/h3>\n<p><\/p>\n<p>Pieejami kopum\u0101 tr\u012bs savienojuma parametru l\u012bme\u0146i uz PostgreSQL, t.i., uzdevumiem un iestat\u012bjumiem:<\/p>\n<p><\/p>\n<ul>\n<li>Glob\u0101l\u0101,<\/li>\n<li>Sesijas,<\/li>\n<li>Makro.<\/li>\n<\/ul>\n<p><\/p>\n<ol>\n<li>\n<p>Glob\u0101lie parametri tiek noteikti a\u0123enta l\u012bmen\u012b, bet sesiju un makro parametri nosaka savienojuma iestat\u012bjumus.<\/p>\n<p>\n<\/li>\n<li>\n<p>Savienojuma parametri uz PostgreSQL - Sesijas tiek nor\u0101d\u012bti fail\u0101 <strong>zabbix_agent2.conf<\/strong>. <\/p>\n<p>\n<\/li>\n<\/ol>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"PostgreSQL uzraudz\u012bba, izmantojot Zabbix\" src=\"\/wp-content\/uploads\/2020\/08\/d88abf88cb106e81f0e7eb23a1d4a193.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p><em>Savienojuma parametri uz PostgreSQL - Sesijas<\/em><\/p>\n<p><\/p>\n<ul>\n<li>P\u0113c atsl\u0113gv\u0101rda <strong>Sesijas<\/strong> tiek nor\u0101d\u012bts unik\u0101ls sesijas nosaukums, kas j\u0101nor\u0101da atsl\u0113g\u0101 (\u0161ablon\u0101). <\/li>\n<li>Iestat\u012bjumi <strong>URI<\/strong> un <strong>Lietot\u0101jv\u0101rds<\/strong> ir oblig\u0101ti katrai sesijai. <\/li>\n<li>Ja datu b\u0101zes nosaukums nav nor\u0101d\u012bts, tiek izmantots k\u0101 visp\u0101r\u012bgs noklus\u0113juma datu b\u0101zes nosaukums vis\u0101m sesij\u0101m uz PostgreSQL, kas ar\u012b ir nor\u0101d\u012bts konfigur\u0101cijas fail\u0101.<\/li>\n<\/ul>\n<p><\/p>\n<ol>\n<li>Savienojuma parametri uz PostgreSQL - Makro tiek nor\u0101d\u012bti metrikas atsl\u0113g\u0101 \u0161ablon\u0101 (l\u012bdz\u012bgi veidam, k\u0101 tas tika izmantots Zabbix Agent 1), t.i., tie tiek izveidoti \u0161ablon\u0101 un turpm\u0101k tiek nor\u0101d\u012bti k\u0101 parametri atsl\u0113g\u0101. \u0160aj\u0101 gad\u012bjum\u0101 makro sec\u012bba ir fiks\u0113ta, t.i., piem\u0113ram, <strong>URI<\/strong> vienm\u0113r nor\u0101d\u012bts vispirms.<\/li>\n<\/ol>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"PostgreSQL uzraudz\u012bba, izmantojot Zabbix\" src=\"\/wp-content\/uploads\/2020\/08\/3918b9de0118f901e916542f955bd17b.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p><em>Savienojuma parametri uz PostgreSQL - Makro<\/em> <\/p>\n<p><\/p>\n<p>PostgreSQL uzraudz\u012bbas modulis ietver jau vair\u0101k nek\u0101 95 metriku, kas \u013cauj aptvert diezgan pla\u0161u PostgreSQL parametru kl\u0101stu, tostarp:<\/p>\n<p><\/p>\n<ul>\n<li>savienojumu skaits,<\/li>\n<li>datu b\u0101zu apjoms, <\/li>\n<li>wal-failu arhiv\u0113\u0161ana,<\/li>\n<li>kontroles punkti,<\/li>\n<li>\u00abuzp\u016bsto\u00bb tabulu skaits,<\/li>\n<li>replik\u0101cijas statuss,<\/li>\n<li>replik\u0101cijas kav\u0113jums.<\/li>\n<\/ul>\n<p><\/p>\n<p>PostgreSQL metriku nav informat\u012bvas bez oper\u0113t\u0101jsist\u0113mas parametriem. Bet Zabbix Agent 2 jau sp\u0113j v\u0101kt oper\u0113t\u0101jsist\u0113mas parametrus, t\u0101d\u0113\u013c pilnai ainai m\u0113s vienk\u0101r\u0161i pievienojam nepiecie\u0161amos \u0161ablonus t\u012bkla mezglam.<\/p>\n<p><\/p>\n<h3 id=\"obrabotchik-handler\">Apstr\u0101d\u0101t\u0101js (handler)<\/h3>\n<p><\/p>\n<p>Apstr\u0101d\u0101t\u0101js (handler) \u2014 galven\u0101 modula vien\u012bba, kur\u0101 tiek izpild\u012bts pats piepras\u012bjums un kas \u013cauj ieg\u016bt metriku.<\/p>\n<p><\/p>\n<p>Lai ieg\u016btu vienk\u0101r\u0161u metriku:<\/p>\n<p><\/p>\n<ol>\n<li>Izveidojam failu jaun\u0101s metrikas ieg\u016b\u0161anai:<\/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>Pievienojam paketi un nor\u0101d\u0101m unik\u0101lo atsl\u0113gu (atsl\u0113gas) metrik\u0101m:<\/li>\n<\/ol>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"PostgreSQL uzraudz\u012bba, izmantojot Zabbix\" src=\"\/wp-content\/uploads\/2020\/08\/692acc55377c18ee37a9e1d426ebeccb.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<ol>\n<li>Izveidojam apstr\u0101d\u0101t\u0101ju (handler) ar piepras\u012bjumu, t.i., inici\u0113j\u0101m main\u012bgo, kur\u0101 b\u016bs rezult\u0101ts:<\/li>\n<\/ol>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"PostgreSQL uzraudz\u012bba, izmantojot Zabbix\" src=\"\/wp-content\/uploads\/2020\/08\/79e10e34edb78942acb6a264896be12d.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<ol>\n<li>Izpild\u0101m piepras\u012bjumu:<\/li>\n<\/ol>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"PostgreSQL uzraudz\u012bba, izmantojot Zabbix\" src=\"\/wp-content\/uploads\/2020\/08\/b7555bba37978302337ea0093dd1bb5c.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>J\u0101 p\u0101rbauda piepras\u012bjums par k\u013c\u016bd\u0101m, p\u0113c tam rezult\u0101ts tiks pa\u0146emts ar Zabbix Agent 2 procesu. <\/p>\n<p><\/p>\n<ol>\n<li>Re\u0123istr\u0113jam jaun\u0101s metrikas atsl\u0113gu:<\/li>\n<\/ol>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"PostgreSQL uzraudz\u012bba, izmantojot Zabbix\" src=\"\/wp-content\/uploads\/2020\/08\/63256811903feacc5cf88e0a272aebd9.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>P\u0113c metrikas re\u0123istr\u0101cijas a\u0123entu var p\u0101rb\u016bv\u0113t ar jauno metriku.<\/p>\n<p><\/p>\n<p>Modulis pieejams, s\u0101kot no Zabbix 5.0 m\u0101jaslap\u0101 <noindex><a rel=\"nofollow\" href=\"https:\/\/www.zabbix.com\/download\">https:\/\/www.zabbix.com\/download<\/a><\/noindex>. \u0160aj\u0101 versij\u0101 Zabbix parametri tiek noteikti atsevi\u0161\u0137i caur host un port. Versij\u0101 Zabbix 5.0.2, kas dr\u012bz tiks izdota, savienojuma parametri tiks apkopoti vien\u0101 URI.<\/p>\n<p><\/p>\n<p>Paldies par uzman\u012bbu! <\/p>\n<p><\/p>\n<h2 id=\"poleznye-ssylki\">Noder\u012bgas saites<\/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\u0101cija par 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>Avots: <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.5 - 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\/lv\/blog\/administrirovanie\/monitoring-postgresql-s-ispolzovaniem-zabbix\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.5\" \/>\n\t\t<meta property=\"og:locale\" content=\"lv_LV\" \/>\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\/lv\/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\udd47PostgreSQL uzraudz\u012bba, izmantojot Zabbix | ProHoster","description":"D\u0101rijas Vilkova zi\u0146ojums Zabbix Meetup.","canonical_url":"https:\/\/prohoster.info\/lv\/blog\/administrirovanie\/monitoring-postgresql-s-ispolzovaniem-zabbix","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"lv_LV","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\/lv\/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\/lv\/wp-json\/wp\/v2\/posts\/91969","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/comments?post=91969"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/posts\/91969\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/media\/91970"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/media?parent=91969"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/categories?post=91969"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/tags?post=91969"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}