{"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\/sq\/blog\/administrirovanie\/monitoring-postgresql-s-ispolzovaniem-zabbix","title":{"rendered":"Monitorimi i PostgreSQL me Zabbix","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p><img decoding=\"async\" alt=\"Monitorimi i PostgreSQL me Zabbix\" src=\"\/wp-content\/uploads\/2020\/08\/b17310212ae5dc4da0ca7d78312ca8ef.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<em>Raporti i Darya Vilkovaya p\u00ebr Zabbix Meetup Online <\/em><\/p>\n<p><\/p>\n<p>Dua t'ju prezantoj me nj\u00eb mjet monitorimi p\u00ebr PostgreSQL dhe sistemin operativ, i cili po zhvillohet nga kompania jon\u00eb duke p\u00ebrdorur Zabbix. <\/p>\n<p><\/p>\n<p>E kemi zgjedhur Zabbix si mjet monitorimi prej koh\u00ebsh, sepse \u00ebsht\u00eb nj\u00eb platform\u00eb me burim t\u00eb hapur, e mb\u00ebshtetur nga nj\u00eb komunitet aktiv, e cila g\u00ebzon nj\u00eb popullaritet t\u00eb madh n\u00eb Rusi. <\/p>\n<p><\/p>\n<p>Krijuam nj\u00eb agjent aktiv \u2014 Mamonsu, i cili siguron monitorim m\u00eb fleksib\u00ebl se sa lejonin mjetet standarde at\u00ebher\u00eb dhe siguron grumbullimin e metrikeve dhe d\u00ebrgimin e tyre n\u00eb Zabbix Server. N\u00eb kompanin\u00eb ton\u00eb, Mamonsu p\u00ebrdoret gjat\u00eb auditit.<\/p>\n<p><noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><\/p>\n<h2 id=\"mamonsu\">Mamonsu<\/h2>\n<p><\/p>\n<p>Mamonsu \u00ebsht\u00eb nj\u00eb agjent aktiv (Zabbix Trapper) p\u00ebr monitorimin e PostgreSQL dhe sistemit operativ. Mamonsu (i shkruar n\u00eb Python) ju lejon t\u00eb konfiguroni parametrat e monitorimit t\u00eb PostgreSQL dhe sistemit operativ brenda pes\u00eb minutash. <\/p>\n<p><\/p>\n<p>Mamonsu ka mjete shtes\u00eb:<\/p>\n<p><\/p>\n<ul>\n<li>mamonsu tune \u2014 komand\u00eb q\u00eb redakton parametrat e konfigurimit n\u00eb skedarin e konfigurimit t\u00eb PostgreSQL p\u00ebr makin\u00ebn ku \u00ebsht\u00eb instaluar agjenti Mamonsu. <\/li>\n<li>raporti mamonsu \u2014 nj\u00eb ekip q\u00eb krijon p\u00ebrgjigje p\u00ebr sistemin operativ dhe PostgreSQL.<\/li>\n<\/ul>\n<p><\/p>\n<p>Mamonsu instalohet n\u00eb serverin e DBMS, mbledh informacionin, e kompozon at\u00eb n\u00eb JSON, i cili d\u00ebrgohet p\u00ebr vizualizim n\u00eb Zabbix Server, ku duhet t\u00eb ekzistoj\u00eb nj\u00eb shabllon p\u00ebr metrikat e tij.<\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"Monitorimi i PostgreSQL me Zabbix\" src=\"\/wp-content\/uploads\/2020\/08\/9d87556e4b31b27cb7698b32b5f1e2c4.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p><em>Skema e funksionimit t\u00eb Mamonsu<\/em> <\/p>\n<p><\/p>\n<h3 id=\"vozmozhnosti-mamonsu\">Mund\u00ebsit\u00eb e Mamonsu<\/h3>\n<p><\/p>\n<ul>\n<li><strong>Puna efektive me PostgreSQL<\/strong>. Lidhja e vazhdueshme me PostgreSQL \u00ebsht\u00eb avantazhi kryesor i Mamonsu. Nd\u00ebrkoh\u00eb, numri maksimal i lidhjeve \u00ebsht\u00eb i barabart\u00eb me numrin maksimal t\u00eb bazave t\u00eb t\u00eb dh\u00ebnave, t\u00eb cilave i \u00ebsht\u00eb lidhur.<\/li>\n<li><strong>Zgjerueshm\u00ebria<\/strong>. Mamonsu \u00ebsht\u00eb nj\u00eb agjent plot\u00ebsisht \"plugin\", dhe fal\u00eb struktur\u00ebs fikse t\u00eb \u00e7do plugin-i dhe thjesht\u00ebsis\u00eb relative t\u00eb Python, \u00ebsht\u00eb e leht\u00eb t\u00eb m\u00ebsohesh t\u00eb shkruash t\u00eb reja ose t\u00eb redaktosh standardet e plugini, dmth parametrat e mbledhjes s\u00eb metrikave.<\/li>\n<li><strong>Gjer\u00ebsia e mbulimit t\u00eb metrikave p\u00ebr monitorim<\/strong> p\u00ebr PostgreSQL p\u00ebrfshir\u00eb metrika specifike t\u00eb zgjerimeve. <\/li>\n<li>Fillim i shpejt\u00eb, <strong>disponueshm\u00ebria \"nga kutia\"<\/strong>.<\/li>\n<li><strong>Shkarkimi i shablloneve dhe skedar\u00ebve t\u00eb konfigurimeve<\/strong>, si dhe ngarkimi n\u00eb Zabbix Server.<\/li>\n<li><strong>Kros-platform\u00ebs<\/strong>, q\u00eb \u00ebsht\u00eb e r\u00ebnd\u00ebsishme p\u00ebr klient\u00ebt tan\u00eb q\u00eb p\u00ebrdorin distribucione t\u00eb ndryshme Linux, p\u00ebrfshir\u00eb ato vendore.<\/li>\n<li><strong>licenca BSD-clause<\/strong>.<\/li>\n<\/ul>\n<p><\/p>\n<p>Aktualisht ofrojm\u00eb nj\u00eb shum\u00ebllojshm\u00ebri plugin-\u00ebsh, dhe n\u00eb \u00e7do version t\u00eb ri p\u00ebrpiqemi t\u00eb sjellim di\u00e7ka t\u00eb re.<\/p>\n<p><\/p>\n<ul>\n<li>14 plugin-a p\u00ebr PostgreSQL, <\/li>\n<li>8 plugin-a p\u00ebr OS Linux,<\/li>\n<li>4 plugin-a p\u00ebr OS Windows.<\/li>\n<\/ul>\n<p><\/p>\n<p>Mamonsu mbledh m\u00eb shum\u00eb se 110 metrika PostgreSQL dhe operative:<\/p>\n<p><\/p>\n<ul>\n<li>70 metrika PostgreSQL,<\/li>\n<li>40 metrika OS Linux,<\/li>\n<li>8 metrika OS Windows.<\/li>\n<\/ul>\n<p><\/p>\n<p>Metrikat kryesore p\u00ebrfshijn\u00eb disponueshm\u00ebrin\u00eb e DBMS, numrin e lidhjeve, madh\u00ebsin\u00eb e baz\u00ebs s\u00eb t\u00eb dh\u00ebnave, piketat, shpejt\u00ebsin\u00eb e leximit\/shkruarjes, bllokimet, numrin e proceseve t\u00eb avtokohes dhe shpejt\u00ebsin\u00eb e gjenerimit t\u00eb WAL. Lista e plot\u00eb e metrikave n\u00eb dispozicion dhe p\u00ebrshkrimi i detajuar i t\u00eb gjitha mjeteve jan\u00eb t\u00eb disponueshme n\u00eb <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/postgrespro\/mamonsu\">repozitorit<\/a><\/noindex> faqen GitHub. <\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"Monitorimi i PostgreSQL me Zabbix\" src=\"\/wp-content\/uploads\/2020\/08\/259cc7f1b6ab0cf137cef6b4e9a22c0f.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p><em>Lista e metrikave n\u00eb faqen GitHub<\/em><\/p>\n<p><\/p>\n<h3 id=\"zapusk-mamonsu-za-5-minut\">Kryeni Mamonsu brenda 5 minutash<\/h3>\n<p><\/p>\n<p>P\u00ebr t\u00eb konfiguruar monitorimin e PostgreSQL dhe sistemit operative me Mamonsu, mund ta b\u00ebni brenda 5 minutash duke e ndjekur 5 hapa t\u00eb thjesht\u00eb.<\/p>\n<p><\/p>\n<ol>\n<li><strong>Instalimi i Mamonsu<\/strong>. Mamonsu mund t\u00eb nd\u00ebrtohet nga kodet burimore ose t\u00eb p\u00ebrdorni paketat e disponueshme.<\/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>Konfigurimi i lidhjeve<\/strong>. Duhet t\u00eb shkruani parametrat e lidhjes me PostgreSQL dhe Zabbix Server n\u00eb skedarin 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>Eksportimi i shabllonit n\u00eb 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>Shtimi i nodit t\u00eb rrjetit n\u00eb Zabbix Server<\/strong>. Shablloni i eksportuar do t\u00eb lidhet automatikisht me nyj\u00ebn e re t\u00eb rrjetit n\u00eb 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>Fillimi<\/strong>.<\/li>\n<\/ol>\n<p><\/p>\n<p><code>$ service mamonsu start<\/code><\/p>\n<p><\/p>\n<h3 id=\"napravleniya-razvitiya-mamonsu\">Direktivat e zhvillimit t\u00eb Mamonsu<\/h3>\n<p><\/p>\n<p>N\u00eb kuad\u00ebr t\u00eb zhvillimit t\u00eb Mamonsu, ne planifikojm\u00eb t\u00eb p\u00ebrmir\u00ebsojm\u00eb metrikat dhe t\u00eb krijojm\u00eb plugins t\u00eb rinj, p\u00ebr shembull, nj\u00eb plugin p\u00ebr monitorimin e madh\u00ebsis\u00eb s\u00eb tabelave individuale. Ne gjithashtu planifikojm\u00eb t\u00eb p\u00ebrmir\u00ebsojm\u00eb dhe t\u00eb krijojm\u00eb mjete t\u00eb tjera, si dhe t\u00eb zgjerim mund\u00ebsit\u00eb e vet\u00ebkonfigurimit p\u00ebrmes komand\u00ebs <strong>mamonsu tune<\/strong>. <\/p>\n<p><\/p>\n<h2 id=\"modul-monitoringa-postgresql-v-sostave-zabbix-agent-2\">Moduli i monitorimit PostgreSQL n\u00eb p\u00ebrb\u00ebrje t\u00eb Zabbix Agent 2<\/h2>\n<p><\/p>\n<p>P\u00ebr lidhjen me PostgreSQL p\u00ebrdoret nj\u00eb drejtuese e shpejt\u00eb dhe t\u00eb njohur <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/jackc\/pgx\">pgx<\/a><\/noindex> (PG driver dhe toolkit p\u00ebr Go).<\/p>\n<p><\/p>\n<p>Aktualisht ne p\u00ebrdorim dy nd\u00ebrfaqe: Exporter, i cili th\u00ebrret nj\u00eb procesor sipas \u00e7el\u00ebsit, dhe Configurator Zabbix Agent 2, i cili lexon dhe kontrollon parametrat e lidhjes me serverin, t\u00eb cilat jan\u00eb t\u00eb dh\u00ebna n\u00eb skedarin e konfigurimit.<\/p>\n<p><\/p>\n<p>Ne u p\u00ebrpoq\u00ebm t\u00eb optimizojm\u00eb pun\u00ebn e DBMS duke grupuar metrikat dhe duke p\u00ebrdorur nj\u00eb procesor (handler) p\u00ebr metrikat dhe grupet e metrikave, si dhe duke p\u00ebrdorur grupe metrikash n\u00eb JSON si variabla t\u00eb varura (dependency items), dhe zbuluar me nivel t\u00eb ul\u00ebt (discovery rules). <\/p>\n<p><\/p>\n<h3 id=\"osnovnye-vozmozhnosti\">P\u00ebrgjegj\u00ebsi kryesore<\/h3>\n<p><\/p>\n<ul>\n<li>mbajtja e nj\u00eb lidhjeje t\u00eb q\u00ebndrueshme me PostgreSQL mes kontrolleve; <\/li>\n<li>mb\u00ebshtetje p\u00ebr intervale fleksib\u00ebl t\u00eb pyetjeve; <\/li>\n<li>kompatibilitet me versionet PostgreSQL, duke filluar nga 10, dhe Zabbix Server, duke filluar nga versioni 4.4;<\/li>\n<li>mund\u00ebsia p\u00ebr t\u00eb lidhur dhe monitoruar disa instanca PostgreSQL nj\u00ebkoh\u00ebsisht, fal\u00eb faktit se Zabbix Agent 2 lejon krijimin e disa seancave.<\/li>\n<\/ul>\n<p><\/p>\n<h3 id=\"urovni-parametrov-podklyucheniya-k-postgresql\">Nivelet e parametrit t\u00eb lidhjes me PostgreSQL<\/h3>\n<p><\/p>\n<p>Disponohen gjithsej tre nivele t\u00eb parametrave t\u00eb lidhjes me PostgreSQL, dometh\u00ebn\u00eb detyrat dhe configurimet:<\/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>Parametrat Global p\u00ebrcaktohen n\u00eb nivelin e agentit, nd\u00ebrsa parametrat Session dhe Macros p\u00ebrcaktojn\u00eb parametrat e lidhjes me databaz\u00ebn.<\/p>\n<p>\n<\/li>\n<li>\n<p>Parametrat e lidhjes me PostgreSQL \u2014 Sessions p\u00ebrcaktohen n\u00eb skedarin <strong>zabbix_agent2.conf<\/strong>. <\/p>\n<p>\n<\/li>\n<\/ol>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"Monitorimi i PostgreSQL me Zabbix\" src=\"\/wp-content\/uploads\/2020\/08\/d88abf88cb106e81f0e7eb23a1d4a193.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p><em>Parametrat e lidhjes me PostgreSQL \u2014 Sessions<\/em><\/p>\n<p><\/p>\n<ul>\n<li>Pas fjal\u00ebs ky\u00e7e <strong>Sessions<\/strong> shkruhet nj\u00eb em\u00ebr unik seance, e cila duhet t\u00eb jet\u00eb e specifikuar n\u00eb \u00e7el\u00ebs (shablon). <\/li>\n<li>Parametrat <strong>URI<\/strong> dhe <strong>UserName<\/strong> jan\u00eb t\u00eb detyrueshme p\u00ebr \u00e7do seanc\u00eb. <\/li>\n<li>N\u00ebse emri i baz\u00ebs nuk \u00ebsht\u00eb p\u00ebrcaktuar, p\u00ebrdoret emri i p\u00ebrgjithsh\u00ebm si parazgjedhje p\u00ebr t\u00eb gjitha seancat p\u00ebr PostgreSQL, i cili p\u00ebrcaktohet gjithashtu n\u00eb skedarin e konfigurimit.<\/li>\n<\/ul>\n<p><\/p>\n<ol>\n<li>Parametrat e lidhjes me PostgreSQL - Makroset p\u00ebrcaktohen n\u00eb \u00e7el\u00ebsin e metrik\u00ebs n\u00eb model (n\u00eb m\u00ebnyr\u00eb analogjike me metod\u00ebn e p\u00ebrdorur n\u00eb Zabbix Agent 1), dmth. krijohen n\u00eb model dhe m\u00eb pas sh\u00ebnohen si parametra n\u00eb \u00e7el\u00ebs. N\u00eb k\u00ebt\u00eb rast, rendi i makrove \u00ebsht\u00eb i fiksuar, dmth. p\u00ebr shembull, <strong>URI<\/strong> gjithmon\u00eb sh\u00ebnohet n\u00eb vendin e par\u00eb.<\/li>\n<\/ol>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"Monitorimi i PostgreSQL me Zabbix\" src=\"\/wp-content\/uploads\/2020\/08\/3918b9de0118f901e916542f955bd17b.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p><em>Parametrat e lidhjes me PostgreSQL - Makroset<\/em> <\/p>\n<p><\/p>\n<p>Moduli i monitorimit PostgreSQL p\u00ebrfshin m\u00eb shum\u00eb se 95 metrika, t\u00eb cilat lejojn\u00eb mbulimin e nj\u00eb numri t\u00eb gjer\u00eb parametrash t\u00eb PostgreSQL, duke p\u00ebrfshir\u00eb:<\/p>\n<p><\/p>\n<ul>\n<li>numrin e lidhjeve,<\/li>\n<li>volumin e bazave t\u00eb t\u00eb dh\u00ebnave, <\/li>\n<li>arkivimin e dosjeve wal,<\/li>\n<li>pik\u00eb kontrolli,<\/li>\n<li>numrin e \u2018shkall\u00ebzuar\u2019 t\u00eb tabelave,<\/li>\n<li>statusin e replikimit,<\/li>\n<li>t\u00eb vones\u00ebs s\u00eb replik\u00ebs.<\/li>\n<\/ul>\n<p><\/p>\n<p>Metrikat e PostgreSQL nuk jan\u00eb informative pa parametrat e sistemit operativ. Por Zabbix Agent 2 tashm\u00eb di t\u00eb mbledh\u00eb parametrat e sistemit operativ, prandaj p\u00ebr t\u00eb marr\u00eb nj\u00eb pamje t\u00eb plot\u00eb thjesht lidhim modelet e nevojshme n\u00eb nyj\u00ebn e rrjetit.<\/p>\n<p><\/p>\n<h3 id=\"obrabotchik-handler\">Menaxhuesi (handler)<\/h3>\n<p><\/p>\n<p>Menaxhuesi (handler) - nj\u00ebsi kryesore e modulit, n\u00eb t\u00eb cil\u00ebn ekzekutohet k\u00ebrkesa vet\u00eb dhe q\u00eb lejon marrjen e metrikave.<\/p>\n<p><\/p>\n<p>P\u00ebr t\u00eb marr\u00eb nj\u00eb metrik\u00eb t\u00eb thjesht\u00eb:<\/p>\n<p><\/p>\n<ol>\n<li>Krijojm\u00eb nj\u00eb file p\u00ebr t\u00eb marr\u00eb nj\u00eb metrik\u00eb t\u00eb re:<\/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>Lidhim paket\u00ebn dhe tregojm\u00eb \u00e7el\u00ebsin unik (\u00e7el\u00ebsat) t\u00eb metrikave:<\/li>\n<\/ol>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"Monitorimi i PostgreSQL me Zabbix\" src=\"\/wp-content\/uploads\/2020\/08\/692acc55377c18ee37a9e1d426ebeccb.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<ol>\n<li>Krijojm\u00eb nj\u00eb trajtues (handler) me k\u00ebrkes\u00ebn, dmth. iniciativ\u00eb nj\u00eb variab\u00ebl n\u00eb t\u00eb cil\u00ebn do t\u00eb jet\u00eb rezultati:<\/li>\n<\/ol>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"Monitorimi i PostgreSQL me Zabbix\" src=\"\/wp-content\/uploads\/2020\/08\/79e10e34edb78942acb6a264896be12d.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<ol>\n<li>Kryejm\u00eb k\u00ebrkes\u00ebn:<\/li>\n<\/ol>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"Monitorimi i PostgreSQL me Zabbix\" src=\"\/wp-content\/uploads\/2020\/08\/b7555bba37978302337ea0093dd1bb5c.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>Duhet t\u00eb kontrollojm\u00eb k\u00ebrkes\u00ebn p\u00ebr gabime, pas s\u00eb cil\u00ebs rezultati do t\u00eb kapet nga procesi Zabbix Agent 2. <\/p>\n<p><\/p>\n<ol>\n<li>Regjistrojm\u00eb \u00e7el\u00ebsin e metrik\u00ebs s\u00eb re:<\/li>\n<\/ol>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"Monitorimi i PostgreSQL me Zabbix\" src=\"\/wp-content\/uploads\/2020\/08\/63256811903feacc5cf88e0a272aebd9.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>Pas regjistrimit t\u00eb metrik\u00ebs, mund t\u00eb rind\u00ebrtojm\u00eb agjentin me metrik\u00ebn e re.<\/p>\n<p><\/p>\n<p>Moduli \u00ebsht\u00eb i disponuesh\u00ebm, duke filluar nga Zabbix 5.0 n\u00eb faqen <noindex><a rel=\"nofollow\" href=\"https:\/\/www.zabbix.com\/download\">https:\/\/www.zabbix.com\/download<\/a><\/noindex>. N\u00eb k\u00ebt\u00eb version, Zabbix parametrat caktohen ve\u00e7mas p\u00ebrmes host dhe port. N\u00eb versionin Zabbix 5.0.2, e cila do t\u00eb publikohet s\u00eb shpejti, parametrat e lidhjes do t\u00eb kompozohen n\u00eb nj\u00eb URI t\u00eb vet\u00ebm.<\/p>\n<p><\/p>\n<p>Faleminderit p\u00ebr v\u00ebmendjen! <\/p>\n<p><\/p>\n<h2 id=\"poleznye-ssylki\">Linqe t\u00eb dobishme<\/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\">Dokumentacioni p\u00ebr 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>Burimi: <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 4.9.10 - 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 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\" \/>\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\/sq\/blog\/administrirovanie\/monitoring-postgresql-s-ispolzovaniem-zabbix\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.10\" \/>\n\t\t<meta property=\"og:locale\" content=\"sq_AL\" \/>\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 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\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/sq\/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\udd47Monitorimi i PostgreSQL me p\u00ebrdorimin e Zabbix | ProHoster","description":"Raporti i Darya Vilkova p\u00ebr Zabbix Meetup Online. Dua t'ju prezantoj me mjetin p\u00ebr monitorimin e PostgreSQL dhe t\u00eb sistemit operativ, i cili zhvillohet nga kompania jon\u00eb duke p\u00ebrdorur Zabbix. E kemi zgjedhur Zabbix si mjete monitorimi p\u00ebr nj\u00eb koh\u00eb t\u00eb gjat\u00eb, sepse \u00ebsht\u00eb nj\u00eb platform\u00eb me kod burimor t\u00eb hapur, e mb\u00ebshtetur nga nj\u00eb komunitet aktiv, q\u00eb g\u00ebzon popullaritet t\u00eb madh n\u00eb Rusi. Kemi krijuar nj\u00eb agjent aktiv.","canonical_url":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/monitoring-postgresql-s-ispolzovaniem-zabbix","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"sq_AL","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 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","og:url":"https:\/\/prohoster.info\/sq\/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"},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/91969","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/comments?post=91969"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/91969\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media\/91970"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media?parent=91969"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/categories?post=91969"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/tags?post=91969"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}