{"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 va Zabbix'i kasutav monitorimine","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p><img decoding=\"async\" alt=\"PostgreSQL va Zabbix&#039;i kasutav monitorimine\" src=\"\/wp-content\/uploads\/2020\/08\/b17310212ae5dc4da0ca7d78312ca8ef.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<em>Darya Vilkova ettekande Zabbix Meetup Online <\/em><\/p>\n<p><\/p>\n<p>Soovin tutvustada teid PostgreSQL ja operatsioonis\u00fcsteemi monitorimise t\u00f6\u00f6riistaga, mida arendab meie ettev\u00f5te Zabbix'i abil. <\/p>\n<p><\/p>\n<p>Meie valik Zabbix'i monitorimise vahendiks langes juba ammu, sest see on avatud l\u00e4htekoodiga platvorm, mida toetab aktiivne kogukond ning see on Venemaal v\u00e4ga populaarne. <\/p>\n<p><\/p>\n<p>Loodud on meie aktiivne agent \u2014 Mamonsu, mis tagas paindlikuma monitorimise v\u00f5rreldes standartsete t\u00f6\u00f6riistadega ning viis l\u00e4bi m\u00f5\u00f5tmete kogumise ja nende edastamise Zabbix Serverile. Meie ettev\u00f5ttes kasutatakse Mamonsut auditi l\u00e4biviimisel.<\/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 monitorimiseks. Mamonsu (kirjutatud Pythonis) v\u00f5imaldab seadistada PostgreSQL ja operatsioonis\u00fcsteemi monitorimise parameetreid viie minutiga. <\/p>\n<p><\/p>\n<p>Mamonsu-l on t\u00e4iendavad t\u00f6\u00f6riistad:<\/p>\n<p><\/p>\n<ul>\n<li>mamonsu tune \u2014 k\u00e4sk, mis redigeerib PostgreSQL konfiguratsioonifaili seadistuse parameetreid masinasse, kuhu Mamonsu agent on paigaldatud. <\/li>\n<li>mamonsu raport \u2014 meeskond, mis loob vastuseid operatsioonis\u00fcsteemi ja PostgreSQL kohta.<\/li>\n<\/ul>\n<p><\/p>\n<p>Mamonsu installitakse andmebaasiserverisse, kogub teavet, koostab selle JSON-formaadis ja saadab visualiseerimiseks Zabbix Serverile, kus peab olema mall tema m\u00f5\u00f5dikute jaoks.<\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"PostgreSQL va Zabbix&#039;i kasutav monitorimine\" src=\"\/wp-content\/uploads\/2020\/08\/9d87556e4b31b27cb7698b32b5f1e2c4.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p><em>Mamonsu t\u00f6\u00f6v\u00f5te<\/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 arvu andmebaasidega, millega ta on \u00fchendatud.<\/li>\n<li><strong>Skaleeritavus<\/strong>. Mamonsu on t\u00e4ielikult \u201epluginne\u201c agent, ja igas plugina fikseeritud struktuuri ning Python'i suhteliselt lihtsuse t\u00f5ttu on lihtne \u00f5ppida kirjutama uusi v\u00f5i redigeerima standardpluginaid, st m\u00f5\u00f5dikute kogumise parameetreid.<\/li>\n<li><strong>Laiaulatuslik m\u00f5\u00f5dikute katvus j\u00e4lgimiseks<\/strong> sealhulgas PostgreSQL spetsiaalsete laiendite m\u00f5\u00f5dikud. <\/li>\n<li>Kiire k\u00e4ivitamine, <strong>valmidus \u201ekarbist v\u00e4lja\u201c<\/strong>.<\/li>\n<li><strong>Mallide ja konfigureerimisfailide eksportimine<\/strong>, samuti laadimine Zabbix Serverisse.<\/li>\n<li><strong>Platvormidevaheline \u00fchilduvus<\/strong>, mis on oluline meie klientidele, kes kasutavad erinevaid Linuxi jaotusi, sealhulgas kohalikke.<\/li>\n<li><strong>BSD-klausli litsents<\/strong>.<\/li>\n<\/ul>\n<p><\/p>\n<p>Hetkel pakume mitmeid pluginaid ja iga j\u00e4rgmise versiooni puhul 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 m\u00f5\u00f5diku:<\/p>\n<p><\/p>\n<ul>\n<li>70 PostgreSQL m\u00f5\u00f5dikut,<\/li>\n<li>40 OS Linuxi m\u00f5\u00f5dikut,<\/li>\n<li>8 OS Windowsi m\u00f5\u00f5dikut.<\/li>\n<\/ul>\n<p><\/p>\n<p>Peamised m\u00f5\u00f5dikud h\u00f5lmavad andmebaasi k\u00e4ttesaadavust, \u00fchenduste arvu, andmebaasi suurust, kontrollpunkte, lugemis-\/kirjutamiskiirust, lukustusi, automaatse vakuumi protsesside arvu ja WAL-i genereerimise kiirus. T\u00e4ielik loetelu saadaval olevatest m\u00f5\u00f5dikutest ja k\u00f5ikide t\u00f6\u00f6riistade \u00fcksikasjalik kirjeldus on saadaval <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/postgrespro\/mamonsu\">repositoriis<\/a><\/noindex> GitHubi lehelt. <\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"PostgreSQL va Zabbix&#039;i kasutav monitorimine\" src=\"\/wp-content\/uploads\/2020\/08\/259cc7f1b6ab0cf137cef6b4e9a22c0f.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p><em>Saadavate m\u00f5\u00f5dikute loetelu GitHubis<\/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 Mamonsu abil on v\u00f5imalik 5 minutiga, j\u00e4rgides 5 lihtsat toimingut.<\/p>\n<p><\/p>\n<ol>\n<li><strong>Mamonsu installimine<\/strong>. Mamonsu saab kokku panna allikatest 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-i 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>. Eksporditud mall \u00fchendatakse automaatselt uue v\u00f5rgu s\u00f5lmega Zabbix Serveris.<\/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\u00e4ivita<\/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 arengusuunad<\/h3>\n<p><\/p>\n<p>Mamonsu arendamise k\u00e4igus plaanime t\u00e4iustada m\u00f5\u00f5dikuid ja luua uusi pluginaid, n\u00e4iteks \u00fcksikute tabelite m\u00f5\u00f5tmise pluginat. Pluss, kavatseme t\u00e4iustada ja luua t\u00e4iendavaid t\u00f6\u00f6riistu ning laiendada autot\u00e4iendamise v\u00f5imalusi k\u00e4suga <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 kaht liidest: Exporter, mis kutsub \u00fcles t\u00f6\u00f6tlejat v\u00f5tme j\u00e4rgi, ja Configurator Zabbix Agent 2, mis loeb ja kontrollib serveriga \u00fchenduse parameetreid, mis on m\u00e4\u00e4ratud konfiguratsioonifailis.<\/p>\n<p><\/p>\n<p>Oleme p\u00fc\u00fcdnud optimeerida andmebaasi t\u00f6\u00f6d, grupeerides m\u00f5\u00f5dikuid ja kasutades m\u00f5\u00f5dikute ja m\u00f5\u00f5dikutega r\u00fchmade jaoks t\u00f6\u00f6tlejat (handler), samuti kasutades JSON-is m\u00f5\u00f5diku gruppe s\u00f5ltumatute muutujatena (dependency items) ja madala taseme avastamist (discovery rules). <\/p>\n<p><\/p>\n<h3 id=\"osnovnye-vozmozhnosti\">Peamised funktsioonid<\/h3>\n<p><\/p>\n<ul>\n<li>p\u00fcsiva \u00fchenduse hoidmine PostgreSQL-iga kontrollide vahel; <\/li>\n<li>paindlike k\u00fcsitlusintervallide tugi; <\/li>\n<li>\u00fchilduvus PostgreSQL versioonidega alates 10 ja Zabbix Server versiooniga alates 4.4;<\/li>\n<li>v\u00f5imalus \u00fchendada ja j\u00e4lgida mitut PostgreSQL instantsi samal ajal, kuna Zabbix Agent 2 v\u00f5imaldab luua mitu sessiooni.<\/li>\n<\/ul>\n<p><\/p>\n<h3 id=\"urovni-parametrov-podklyucheniya-k-postgresql\">PostgreSQL \u00fchendusparameetride tasemed<\/h3>\n<p><\/p>\n<p>Saadaval on kokku kolm \u00fchendusparameetrite taset, st \u00fclesanded ja seaded:<\/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 s\u00e4tted m\u00e4\u00e4ratakse agendi tasemel, seansside ja makrode parameetrid m\u00e4\u00e4ravad andmebaasi \u00fchenduse parameetrid.<\/p>\n<p>\n<\/li>\n<li>\n<p>PostgreSQL \u00fchendusparameetrid \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 va Zabbix&#039;i kasutav monitorimine\" src=\"\/wp-content\/uploads\/2020\/08\/d88abf88cb106e81f0e7eb23a1d4a193.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p><em>PostgreSQL \u00fchendusparameetrid \u2014 seansid<\/em><\/p>\n<p><\/p>\n<ul>\n<li>P\u00e4rast m\u00e4rks\u00f5na <strong>Seansid<\/strong> kirjutatakse unikaalne seansi nimi, mis peab olema m\u00e4\u00e4ratud v\u00f5tmes (\u0161ablonis). <\/li>\n<li>Parameetrid <strong>URI<\/strong> ja <strong>Kasutajanimi<\/strong> on iga seansi jaoks kohustuslikud. <\/li>\n<li>Kui andmebaasi nime ei ole m\u00e4\u00e4ratud, kasutatakse k\u00f5igile seanssidele \u00fchise vaike nime, mis on samuti m\u00e4\u00e4ratud konfiguratsioonifailis.<\/li>\n<\/ul>\n<p><\/p>\n<ol>\n<li>PostgreSQL-i \u00fchenduse parameetrid \u2014 makrod m\u00e4\u00e4ratakse m\u00f5\u00f5te v\u00f5tmes \u0161abloonis (sarnane meetodile, mida kasutati Zabbix Agendiga 1), st need luuakse \u0161abloonis ja seej\u00e4rel m\u00e4rgitakse parameetritena v\u00f5tmes. Sealjuures on makrode j\u00e4rjestus fikseeritud, st n\u00e4iteks, <strong>URI<\/strong> on alati esimesele kohale m\u00e4rgitud.<\/li>\n<\/ol>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"PostgreSQL va Zabbix&#039;i kasutav monitorimine\" src=\"\/wp-content\/uploads\/2020\/08\/3918b9de0118f901e916542f955bd17b.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p><em>PostgreSQL-i \u00fchenduse parameetrid \u2014 makrod<\/em> <\/p>\n<p><\/p>\n<p>PostgreSQL-i j\u00e4lgimismodul sisaldab juba \u00fcle 95 m\u00f5\u00f5tmise, mis katab \u00fcsna laia valikut PostgreSQL-i parameetreid, sealhulgas:<\/p>\n<p><\/p>\n<ul>\n<li>\u00fchenduste arv,<\/li>\n<li>andmebaaside maht, <\/li>\n<li>wal-failide arhiveerimine,<\/li>\n<li>kontrollpunktid,<\/li>\n<li>\u201epaisunud\u201d tabelite arv,<\/li>\n<li>replikatsiooni staatus,<\/li>\n<li>replika viivitus.<\/li>\n<\/ul>\n<p><\/p>\n<p>PostgreSQL-i m\u00f5\u00f5dikud ei ole informatiivsed ilma operatsioonis\u00fcsteemi parameetriteta. Kuid Zabbix Agent 2 oskab juba koguda operatsioonis\u00fcsteemi parameetreid, seega, et saada t\u00e4ielik \u00fclevaade, \u00fchendame lihtsalt v\u00f5rku vajalikud \u0161abloonid.<\/p>\n<p><\/p>\n<h3 id=\"obrabotchik-handler\">K\u00e4itleja (handler)<\/h3>\n<p><\/p>\n<p>K\u00e4itleja (handler) \u2014 moduli p\u00f5hielement, kus toimub p\u00e4ring ning mis v\u00f5imaldab saada m\u00f5\u00f5detavaid andmeid.<\/p>\n<p><\/p>\n<p>Lihtsa m\u00f5\u00f5diku saamiseks:<\/p>\n<p><\/p>\n<ol>\n<li>Loome faili uue m\u00f5\u00f5diku saamiseks:<\/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>\u00dchendame paketi ja m\u00e4\u00e4rame ainulaadse v\u00f5tme (v\u00f5tmed) m\u00f5\u00f5dikutele:<\/li>\n<\/ol>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"PostgreSQL va Zabbix&#039;i kasutav monitorimine\" src=\"\/wp-content\/uploads\/2020\/08\/692acc55377c18ee37a9e1d426ebeccb.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<ol>\n<li>Loome k\u00e4sitleja (handler) koos p\u00e4ringuga, st algatame muutuja, kuhu tulemus salvestatakse:<\/li>\n<\/ol>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"PostgreSQL va Zabbix&#039;i kasutav monitorimine\" src=\"\/wp-content\/uploads\/2020\/08\/79e10e34edb78942acb6a264896be12d.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<ol>\n<li>Teostame p\u00e4ringu:<\/li>\n<\/ol>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"PostgreSQL va Zabbix&#039;i kasutav monitorimine\" src=\"\/wp-content\/uploads\/2020\/08\/b7555bba37978302337ea0093dd1bb5c.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>On oluline kontrollida p\u00e4ringut vigade osas, mille j\u00e4rel t\u00f5ukab tulemuse Zabbix Agent 2 protsess. <\/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 va Zabbix&#039;i kasutav monitorimine\" src=\"\/wp-content\/uploads\/2020\/08\/63256811903feacc5cf88e0a272aebd9.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>P\u00e4rast m\u00f5\u00f5diku registreerimist saab agendi koos uue m\u00f5\u00f5dikuga uuesti kokku panna.<\/p>\n<p><\/p>\n<p>Moodul on saadaval alates Zabbix 5.0-st veebilehel <noindex><a rel=\"nofollow\" href=\"https:\/\/www.zabbix.com\/download\">https:\/\/www.zabbix.com\/download<\/a><\/noindex>. Selles Zabbixi versioonis m\u00e4\u00e4ratakse parameetrid eraldi hosti ja porti kaudu. Zabbix 5.0.2 versioonis, mis peagi ilmub, koondatakse \u00fchendamise 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 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\/et\/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=\"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 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\/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\udd47 PostgreSQL j\u00e4lgimine Zabbixi abil | ProHoster","description":"Darja Vilkova ettekande Zabbix Meetup Online. Soovin tutvustada teile PostgreSQL ja operatsioonis\u00fcsteemi j\u00e4lgimise vahendit, mida meie ettev\u00f5te arendab Zabbixi kasutades. Oleme juba pikka aega valinud Zabbixi j\u00e4lgimiseks, kuna see on avatud l\u00e4htekoodiga platvorm, mida toetab aktiivne kogukond ja mis on Venemaal v\u00e4ga populaarne. Oleme loonud aktiivse agendi.","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 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\/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"},"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}]}}