{"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\/et\/blog\/administrirovanie\/monitoring-postgresql-s-ispolzovaniem-zabbix","title":{"rendered":"PostgreSQL-i j\u00e4lgimine Zabbixiga","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p><img decoding=\"async\" alt=\"PostgreSQL-i j\u00e4lgimine Zabbixiga\" src=\"\/wp-content\/uploads\/2020\/08\/b17310212ae5dc4da0ca7d78312ca8ef.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<em>Darja Vilkova ettekande Zabbix Meetup Online <\/em><\/p>\n<p><\/p>\n<p>Soovin tutvustada teid meie ettev\u00f5tte poolt Zabbixi abil arendatava PostgreSQL ja operatsioonis\u00fcsteemi j\u00e4lgimisvahendiga. <\/p>\n<p><\/p>\n<p>Oleme juba ammu valinud Zabbixi j\u00e4lgimisvahendiks, kuna see on avatud l\u00e4htekoodiga platvorm, mida toetab aktiivne kogukond ja mis on Venemaal v\u00e4ga populaarne. <\/p>\n<p><\/p>\n<p>Loomasime aktiivse agendi \u2014 Mamonsu, mis pakkus paindlikumat j\u00e4lgimist, kui toona standardt\u00f6\u00f6riistad v\u00f5imaldasid, ja kogus m\u00f5\u00f5dikud ja saatis need Zabbix Serverile. Meie ettev\u00f5ttes kasutatakse Mamonsut auditeerimise k\u00e4igus.<\/p>\n<p><noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><\/p>\n<h2 id=\"mamonsu\">Mamonsu<\/h2>\n<p><\/p>\n<p>Mamonsu on aktiivne agent (Zabbix Trapper) PostgreSQL ja operatsioonis\u00fcsteemi j\u00e4lgimiseks. Mamonsu (kirjutatud Pythonis) v\u00f5imaldab seadistada PostgreSQL ja operatsioonis\u00fcsteemi j\u00e4lgimise parameetreid viie minutiga. <\/p>\n<p><\/p>\n<p>Mamonsul on t\u00e4iendavad t\u00f6\u00f6riistad:<\/p>\n<p><\/p>\n<ul>\n<li>mamonsu tune \u2014 k\u00e4sk, mis redigeerib PostgreSQL-i konfigureerimisfaili seadistusparameetreid masina jaoks, kuhu Mamonsu agent on paigaldatud. <\/li>\n<li>mamonsu report \u2014 k\u00e4sk, mis genereerib vastuseid operatsioonis\u00fcsteemi ja PostgreSQL kohta.<\/li>\n<\/ul>\n<p><\/p>\n<p>Mamonsu paigaldatakse andmebaasiserverisse, kogub teavet, koostab selle JSON-formaadis ja saadab visualiseerimiseks Zabbix Serverile, kus peab olema olemas \u0161abloon selle m\u00f5\u00f5dikute jaoks.<\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"PostgreSQL-i j\u00e4lgimine Zabbixiga\" src=\"\/wp-content\/uploads\/2020\/08\/9d87556e4b31b27cb7698b32b5f1e2c4.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p><em>Mamonsu t\u00f6\u00f6ts\u00fckkel<\/em> <\/p>\n<p><\/p>\n<h3 id=\"vozmozhnosti-mamonsu\">Mamonsu v\u00f5imalused<\/h3>\n<p><\/p>\n<ul>\n<li><strong>T\u00f5hus t\u00f6\u00f6 PostgreSQL-iga<\/strong>. P\u00fcsiv \u00fchendus PostgreSQL-iga on Mamonsu peamine eelis. Samuti on maksimaalne \u00fchenduste arv v\u00f5rdne maksimaalse andmebaaside arvuga, millega see on \u00fchendatud.<\/li>\n<li><strong>Laaditavus<\/strong>. Mamonsu on t\u00e4ielikult \u201epluginne\u201c agent ja iga plugina fikseeritud struktuuri ning Python\u2019i suhteliselt lihtsa \u00f5ppimise t\u00f5ttu on lihtne luua uusi v\u00f5i redigeerida olemasolevaid pluginaid, st m\u00f5\u00f5dikute kogumise parameetreid.<\/li>\n<li><strong>Lai m\u00f5\u00f5dikute katvus j\u00e4lgimiseks<\/strong> sealhulgas PotgreSQL spetsiifiliste laienduste m\u00f5\u00f5dikud. <\/li>\n<li>Kiire k\u00e4ivitus, <strong>ootetavus \u201ekarbis\u201c<\/strong>.<\/li>\n<li><strong>\u0160abloonide ja konfigureerimisfailide eksportimine<\/strong>, samuti laadimine Zabbix Serverisse.<\/li>\n<li><strong>Ristplatvormilisus<\/strong>, mis on oluline meie klientidele, kes kasutavad erinevaid Linuxi distributsioone, sealhulgas kodumaiseid.<\/li>\n<li><strong>BSD-litsents<\/strong>.<\/li>\n<\/ul>\n<p><\/p>\n<p>Praegu pakume mitmeid pluginaid ja iga j\u00e4rgmise versiooniga p\u00fc\u00fcame lisada midagi uut.<\/p>\n<p><\/p>\n<ul>\n<li>14 pluginaid PostgreSQL jaoks, <\/li>\n<li>8 pluginaid OS Linuxile,<\/li>\n<li>4 pluginaid OS Windowsile.<\/li>\n<\/ul>\n<p><\/p>\n<p>Mamonsu kogub \u00fcle 110 PostgreSQL ja operatsioonis\u00fcsteemide meetri:<\/p>\n<p><\/p>\n<ul>\n<li>70 PostgreSQL meetrit,<\/li>\n<li>40 meetrit OS Linuxile,<\/li>\n<li>8 meetrit OS Windowsile.<\/li>\n<\/ul>\n<p><\/p>\n<p>P\u00f5hilised meetrid h\u00f5lmavad andmebaasi k\u00e4ttesaadavust, \u00fchenduste arvu, andmebaasi suurust, kontrolle, lugemis-\/kirjutamiskiirus, lukustusi, automaatse t\u00fchjendamise protsesside arvu ja WAL-i genereerimise kiirus. T\u00e4ielik loetelu saadaval olevatest meetritest ja k\u00f5igi t\u00f6\u00f6riistade \u00fcksikasjalik kirjeldus on saadaval <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/postgrespro\/mamonsu\">hoidlad<\/a><\/noindex> GitHubi lehelt. <\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"PostgreSQL-i j\u00e4lgimine Zabbixiga\" src=\"\/wp-content\/uploads\/2020\/08\/259cc7f1b6ab0cf137cef6b4e9a22c0f.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p><em>Saadaval olevate meetrite loetelu GitHubi lehelt<\/em><\/p>\n<p><\/p>\n<h3 id=\"zapusk-mamonsu-za-5-minut\">Mamonsu k\u00e4ivitamine 5 minutiga<\/h3>\n<p><\/p>\n<p>PostgreSQL ja operatsioonis\u00fcsteemi j\u00e4lgimise seadistamine Mamonsuga v\u00f5tab vaid 5 minutit, j\u00e4rgides 5 lihtsat sammu.<\/p>\n<p><\/p>\n<ol>\n<li><strong>Mamonsu paigaldamine<\/strong>. Mamonsu on v\u00f5imalik ehitada allikakoodist v\u00f5i kasutada saadaval olevaid pakette.<\/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>\u00dchenduste seadistamine<\/strong>. On vajalik m\u00e4\u00e4rata PostgreSQL ja Zabbix Serveri \u00fchenduse parameetrid failis 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>Mallide eksportimine Zabbix Serverisse<\/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>V\u00f5rgu s\u00f5lme lisamine Zabbix Serverisse<\/strong>. Eksportitud mall \u00fchendatakse automaatselt uue v\u00f5rgu s\u00f5lmekohta Zabbix Serverisse.<\/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>K\u00e4ivitamine<\/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 arengu suunad<\/h3>\n<p><\/p>\n<p>Mamonsu arendamise raames plaanime t\u00e4iustada m\u00f5\u00f5dikuid ja luua uusi pluginaid, n\u00e4iteks eraldi tabelite suuruse j\u00e4lgimise plugina. Samuti plaanime t\u00e4iustada ja luua t\u00e4iendavaid t\u00f6\u00f6riistu ning laiendada automaatse seadistamise v\u00f5imalusi k\u00e4su <strong>mamonsu tune<\/strong>. <\/p>\n<p><\/p>\n<h2 id=\"modul-monitoringa-postgresql-v-sostave-zabbix-agent-2\">PostgreSQL j\u00e4lgimise moodul Zabbix Agent 2 koosseisus<\/h2>\n<p><\/p>\n<p>PostgreSQL-iga \u00fchenduse loomiseks kasutatakse kiiret ja populaarset draiverit <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/jackc\/pgx\">pgx<\/a><\/noindex> (PG draiver ja t\u00f6\u00f6riistakomplekt Go jaoks).<\/p>\n<p><\/p>\n<p>Praegu kasutame kahte liidest: Exporter, mis kutsub k\u00e4itlejat v\u00f5tme kaudu, ja Zabbix Agent 2 Configurator, mis loeb ja kontrollib konfiguratsioonifailis m\u00e4\u00e4ratud \u00fchenduse parameetreid serveriga.<\/p>\n<p><\/p>\n<p>Oleme p\u00fc\u00fcdnud optimeerida andmebaasi t\u00f6\u00f6d, grupeerides meetrid ja kasutades k\u00e4itlejat (handler) meetrite ja meetrigrupikohta, samuti kasutades JSON sarnaseid madala taseme avastamise ja s\u00f5ltuvate elementidena (dependency items). <\/p>\n<p><\/p>\n<h3 id=\"osnovnye-vozmozhnosti\">P\u00f5hiomadused<\/h3>\n<p><\/p>\n<ul>\n<li>p\u00fcsiva \u00fchenduse loomine PostgreSQL-iga kontrollide vahel; <\/li>\n<li>paindlike k\u00fcsitluste intervallide toetamine; <\/li>\n<li>\u00fchilduvus PostgreSQL versioonidega alates 10 ja Zabbix Serveriga alates versioonist 4.4;<\/li>\n<li>v\u00f5imalus \u00fchendada ja monitorida mitut PostgreSQL instantsi korraga, kuna Zabbix Agent 2 v\u00f5imaldab luua mitu seanssi.<\/li>\n<\/ul>\n<p><\/p>\n<h3 id=\"urovni-parametrov-podklyucheniya-k-postgresql\">PostgreSQL \u00fchenduse parameetrite tasemed<\/h3>\n<p><\/p>\n<p>Kokku on saadaval kolm PostgreSQL \u00fchenduse parameetrite taset, st \u00fclesandeid ja seadistusi:<\/p>\n<p><\/p>\n<ul>\n<li>Globaalne,<\/li>\n<li>Seansid,<\/li>\n<li>Makrod.<\/li>\n<\/ul>\n<p><\/p>\n<ol>\n<li>\n<p>Globaalsete parameetrite m\u00e4\u00e4ramine toimub agendi tasemel, seansi ja makrode parameetrid m\u00e4\u00e4ravad \u00fchenduse parameetrid andmebaasi.<\/p>\n<p>\n<\/li>\n<li>\n<p>PostgreSQL \u00fchenduse parameetrid \u2014 Seansid m\u00e4\u00e4ratakse failis <strong>zabbix_agent2.conf<\/strong>. <\/p>\n<p>\n<\/li>\n<\/ol>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"PostgreSQL-i j\u00e4lgimine Zabbixiga\" src=\"\/wp-content\/uploads\/2020\/08\/d88abf88cb106e81f0e7eb23a1d4a193.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p><em>PostgreSQL \u00fchenduse parameetrid \u2014 Seansid<\/em><\/p>\n<p><\/p>\n<ul>\n<li>P\u00e4rast v\u00f5tit <strong>Seansid<\/strong> m\u00e4\u00e4ra unikaalne seansi nimi, mis peab olema m\u00e4\u00e4ratud v\u00f5tmes (mallis). <\/li>\n<li>Parameetrid <strong>URI<\/strong> ja <strong>Kasutajanimi<\/strong> on iga seansi jaoks kohustuslikud. <\/li>\n<li>Kui andmebaasi nimetus ei ole m\u00e4\u00e4ratud, kasutatakse PostgreSQL k\u00f5ikide seansside jaoks \u00fcldist vaike nime, mis on samuti m\u00e4\u00e4ratud konfiguratsioonifailis.<\/li>\n<\/ul>\n<p><\/p>\n<ol>\n<li>PostgreSQL \u00fchenduse parameetrid \u2014 Makrod m\u00e4\u00e4ratakse m\u00f5\u00f5diku v\u00f5tmes mallis (sarnaselt Zabbix Agent 1 kasutatud meetodile), st need luuakse mallis ja seej\u00e4rel m\u00e4\u00e4ratakse v\u00f5tme parameetriteks. Samal ajal on makrode j\u00e4rjestus fikseeritud, st n\u00e4iteks <strong>URI<\/strong> m\u00e4\u00e4ratakse alati esimesena.<\/li>\n<\/ol>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"PostgreSQL-i j\u00e4lgimine Zabbixiga\" src=\"\/wp-content\/uploads\/2020\/08\/3918b9de0118f901e916542f955bd17b.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p><em>PostgreSQL \u00fchenduse parameetrid \u2014 Makrod<\/em> <\/p>\n<p><\/p>\n<p>PostgreSQL j\u00e4lgimismoodul sisaldab juba \u00fcle 95 m\u00f5\u00f5diku, mis v\u00f5imaldavad katta \u00fcsna laia PostgreSQL parameetrite valikut, sealhulgas:<\/p>\n<p><\/p>\n<ul>\n<li>\u00fchenduste arv,<\/li>\n<li>andmebaaside maht, <\/li>\n<li>wal-failide arhiivimine,<\/li>\n<li>kontrollpunktid,<\/li>\n<li>p\u00e4rli paisunud tabelite arv,<\/li>\n<li>replitseerimise staatus,<\/li>\n<li>repliikkaotuse viivitus.<\/li>\n<\/ul>\n<p><\/p>\n<p>PostgreSQL m\u00f5\u00f5dikud ei ole informatiivsed ilma operatsioonis\u00fcsteemi parameetriteta. Kuid Zabbix Agent 2 oskab juba koguda operatsioonis\u00fcsteemi parameetreid, seega saame lihtsalt vajalikud mallid v\u00f5rgu s\u00f5lmele \u00fchendada, et saada t\u00e4ielik \u00fclevaade.<\/p>\n<p><\/p>\n<h3 id=\"obrabotchik-handler\">K\u00e4sitseja (handler)<\/h3>\n<p><\/p>\n<p>K\u00e4sitseja (handler) \u2014 mooduli peamine element, kus toimub p\u00e4ring ja mis v\u00f5imaldab m\u00f5\u00f5dikute saamist.<\/p>\n<p><\/p>\n<p>Et saada lihtne m\u00f5\u00f5dik:<\/p>\n<p><\/p>\n<ol>\n<li>Loo fail uue m\u00f5\u00f5diku jaoks:<\/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>\u00dchenda pakk ja m\u00e4\u00e4ra unikaalne m\u00f5\u00f5diku v\u00f5ti (v\u00f5tmed):<\/li>\n<\/ol>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"PostgreSQL-i j\u00e4lgimine Zabbixiga\" src=\"\/wp-content\/uploads\/2020\/08\/692acc55377c18ee37a9e1d426ebeccb.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<ol>\n<li>Loo k\u00e4sitseja (handler) p\u00e4ringuga, st koosta muutuja, kuhu tulemus l\u00e4heb:<\/li>\n<\/ol>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"PostgreSQL-i j\u00e4lgimine Zabbixiga\" src=\"\/wp-content\/uploads\/2020\/08\/79e10e34edb78942acb6a264896be12d.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<ol>\n<li>Tee p\u00e4ring:<\/li>\n<\/ol>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"PostgreSQL-i j\u00e4lgimine Zabbixiga\" src=\"\/wp-content\/uploads\/2020\/08\/b7555bba37978302337ea0093dd1bb5c.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>On vajalik kontrollida p\u00e4ringut vigade osas, p\u00e4rast mida tulemus v\u00f5etakse \u00fcle Zabbix Agent 2 protsessi poolt. <\/p>\n<p><\/p>\n<ol>\n<li>Registreerime uue m\u00f5\u00f5diku v\u00f5tme:<\/li>\n<\/ol>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"PostgreSQL-i j\u00e4lgimine Zabbixiga\" src=\"\/wp-content\/uploads\/2020\/08\/63256811903feacc5cf88e0a272aebd9.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>M\u00f5\u00f5diku registreerimise j\u00e4rel on v\u00f5imalik agent uuesti kompileerida koos uue m\u00f5\u00f5diku.<\/p>\n<p><\/p>\n<p>Moodul on saadaval alates Zabbix 5.0 veebilehel <noindex><a rel=\"nofollow\" href=\"https:\/\/www.zabbix.com\/download\">https:\/\/www.zabbix.com\/download<\/a><\/noindex>. Selles versioonis seadistatakse Zabbixi parameetrid eraldi hosti ja pordi kaudu. Versioonis Zabbix 5.0.2, mis tuleb peagi v\u00e4lja, komponeeritakse \u00fchenduse parameetrid \u00fchte URI-sse.<\/p>\n<p><\/p>\n<p>Ait\u00e4h t\u00e4helepanu eest! <\/p>\n<p><\/p>\n<h2 id=\"poleznye-ssylki\">Kasulikud lingid<\/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\">Mamonsu dokumentatsioon<\/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>Allikas: <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.1.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\/et\/blog\/administrirovanie\/monitoring-postgresql-s-ispolzovaniem-zabbix\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.1.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"et_EE\" \/>\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\/et\/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 j\u00e4lgimine Zabbixiga | ProHoster","description":"Darya Vilkova ettekand Zabbix Meetupil.","canonical_url":"https:\/\/prohoster.info\/et\/blog\/administrirovanie\/monitoring-postgresql-s-ispolzovaniem-zabbix","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"et_EE","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\/et\/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\/et\/wp-json\/wp\/v2\/posts\/91969","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/comments?post=91969"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts\/91969\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/media\/91970"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/media?parent=91969"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/categories?post=91969"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/tags?post=91969"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}