{"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\/hu\/blog\/administrirovanie\/monitoring-postgresql-s-ispolzovaniem-zabbix","title":{"rendered":"PostgreSQL monitoroz\u00e1sa Zabbix haszn\u00e1lat\u00e1val","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p><img decoding=\"async\" alt=\"PostgreSQL monitoroz\u00e1sa Zabbix haszn\u00e1lat\u00e1val\" src=\"\/wp-content\/uploads\/2020\/08\/b17310212ae5dc4da0ca7d78312ca8ef.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<em>Darya Vilkova besz\u00e1mol\u00f3ja a Zabbix Meetup Online-on <\/em><\/p>\n<p><\/p>\n<p>Szeretn\u00e9m bemutatni \u00f6n\u00f6knek a PostgreSQL \u00e9s az oper\u00e1ci\u00f3s rendszer monitoring eszk\u00f6z\u00e9t, amelyet c\u00e9g\u00fcnk a Zabbix felhaszn\u00e1l\u00e1s\u00e1val fejleszt. <\/p>\n<p><\/p>\n<p>M\u00e1r r\u00e9g\u00f3ta a Zabbix-ot v\u00e1lasztottuk monitoring eszk\u00f6z\u00fcl, mert ez egy ny\u00edlt forr\u00e1sk\u00f3d\u00fa platform, amelyet egy akt\u00edv k\u00f6z\u00f6ss\u00e9g t\u00e1mogat, \u00e9s amely Oroszorsz\u00e1gban n\u00e9pszer\u0171. <\/p>\n<p><\/p>\n<p>Kifejlesztett\u00fck az akt\u00edv \u00fcgyn\u00f6k\u00f6t \u2014 Mamonsut, amely rugalmasabb monitoringot biztos\u00edtott ann\u00e1l, amit a standard eszk\u00f6z\u00f6k akkor lehet\u0151v\u00e9 tettek, \u00e9s a metrik\u00e1k gy\u0171jt\u00e9s\u00e9t \u00e9s Zabbix Server-re val\u00f3 elk\u00fcld\u00e9s\u00e9t biztos\u00edtotta. C\u00e9g\u00fcnkn\u00e9l a Mamonsut audit\u00e1l\u00e1s sor\u00e1n haszn\u00e1lj\u00e1k.<\/p>\n<p><noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><\/p>\n<h2 id=\"mamonsu\">Mamonsu<\/h2>\n<p><\/p>\n<p>A Mamonsu egy akt\u00edv \u00fcgyn\u00f6k (Zabbix Trapper) a PostgreSQL \u00e9s az oper\u00e1ci\u00f3s rendszer monitoringj\u00e1ra. A Mamonsu (Python nyelven \u00edr\u00f3dott) lehet\u0151v\u00e9 teszi a PostgreSQL \u00e9s az oper\u00e1ci\u00f3s rendszer monitoring param\u00e9tereinek be\u00e1ll\u00edt\u00e1s\u00e1t \u00f6t perc alatt. <\/p>\n<p><\/p>\n<p>A Mamonsu tov\u00e1bbi eszk\u00f6z\u00f6kkel rendelkezik:<\/p>\n<p><\/p>\n<ul>\n<li>mamonsu tune \u2014 parancs, amely szerkeszti az PostgreSQL konfigur\u00e1ci\u00f3s f\u00e1jlban tal\u00e1lhat\u00f3 be\u00e1ll\u00edt\u00e1sokat a Mamonsu \u00fcgyn\u00f6kkel rendelkez\u0151 g\u00e9phez. <\/li>\n<li>mamonsu report \u2014 parancs, amely v\u00e1laszokat k\u00e9sz\u00edt az oper\u00e1ci\u00f3s rendszerr\u0151l \u00e9s a PostgreSQL-r\u0151l.<\/li>\n<\/ul>\n<p><\/p>\n<p>A Mamonsu a DBMS szerverre telep\u00fcl, inform\u00e1ci\u00f3t gy\u0171jt, JSON form\u00e1tumban \u00f6sszes\u00edti, \u00e9s a Zabbix Server-re k\u00fcldi vizualiz\u00e1l\u00e1s c\u00e9lj\u00e1b\u00f3l, ahol a metrik\u00e1ihoz sablonnak kell lennie.<\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"PostgreSQL monitoroz\u00e1sa Zabbix haszn\u00e1lat\u00e1val\" src=\"\/wp-content\/uploads\/2020\/08\/9d87556e4b31b27cb7698b32b5f1e2c4.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p><em>A Mamonsu m\u0171k\u00f6d\u00e9si s\u00e9m\u00e1ja<\/em> <\/p>\n<p><\/p>\n<h3 id=\"vozmozhnosti-mamonsu\">A Mamonsu lehet\u0151s\u00e9gei<\/h3>\n<p><\/p>\n<ul>\n<li><strong>Hat\u00e9kony munka a PostgreSQL-lel<\/strong>. A PostgreSQL-lel val\u00f3 folyamatos kapcsolat a Mamonsu f\u0151 el\u0151nye. Ebben az esetben a maxim\u00e1lis kapcsolatok sz\u00e1ma megegyezik a maxim\u00e1lis adatb\u00e1zisok sz\u00e1m\u00e1val, amelyekhez csatlakozik.<\/li>\n<li><strong>Sk\u00e1l\u00e1zhat\u00f3s\u00e1g<\/strong>. A Mamonsu teljesen \"plug-in\" \u00fcgyn\u00f6k, \u00e9s a minden plug-in r\u00f6gz\u00edtett strukt\u00far\u00e1j\u00e1nak \u00e9s a Python viszonylag egyszer\u0171s\u00e9g\u00e9nek k\u00f6sz\u00f6nhet\u0151en k\u00f6nnyen megtanulhatja \u00faj plug-inok \u00edr\u00e1s\u00e1t vagy a standard plug-inok szerkeszt\u00e9s\u00e9t, azaz a metrik\u00e1k gy\u0171jt\u00e9si param\u00e9tereit.<\/li>\n<li><strong>Sz\u00e9lesk\u00f6r\u0171 metrik\u00e1k lefedetts\u00e9ge a monitoringhoz<\/strong> a PostgreSQL sz\u00e1m\u00e1ra, bele\u00e9rtve a specifikus kiterjeszt\u00e9sek metrik\u00e1it is. <\/li>\n<li>Gyors ind\u00edt\u00e1s, <strong>az \"out-of-the-box\" el\u00e9rhet\u0151s\u00e9g<\/strong>.<\/li>\n<li><strong>Sablonok \u00e9s konfigur\u00e1ci\u00f3s f\u00e1jlok export\u00e1l\u00e1sa<\/strong>, valamint felt\u00f6lt\u00e9s a Zabbix Server-re.<\/li>\n<li><strong>Keresztplatformoss\u00e1g<\/strong>, ami fontos \u00fcgyfeleink sz\u00e1m\u00e1ra, akik k\u00fcl\u00f6nb\u00f6z\u0151 Linux disztrib\u00faci\u00f3kat haszn\u00e1lnak, bele\u00e9rtve a hazaiakat is.<\/li>\n<li><strong>BSD-kal\u00f3z licenc<\/strong>.<\/li>\n<\/ul>\n<p><\/p>\n<p>Jelenleg sz\u00e1mos plug-int k\u00edn\u00e1lunk, \u00e9s minden k\u00f6vetkez\u0151 verzi\u00f3ban pr\u00f3b\u00e1lunk valami \u00faj dolgot hozz\u00e1adni.<\/p>\n<p><\/p>\n<ul>\n<li>14 plugin a PostgreSQL-hez, <\/li>\n<li>8 plugin a Linux OS-hez,<\/li>\n<li>4 plugin a Windows OS-hez.<\/li>\n<\/ul>\n<p><\/p>\n<p>A Mamonsu t\u00f6bb mint 110 PostgreSQL \u00e9s oper\u00e1ci\u00f3s rendszer metrik\u00e1t gy\u0171jt:<\/p>\n<p><\/p>\n<ul>\n<li>70 PostgreSQL metrik\u00e1t,<\/li>\n<li>40 Linux oper\u00e1ci\u00f3s rendszer metrik\u00e1t,<\/li>\n<li>8 Windows oper\u00e1ci\u00f3s rendszer metrik\u00e1t.<\/li>\n<\/ul>\n<p><\/p>\n<p>A f\u0151 metrik\u00e1k k\u00f6z\u00e9 tartozik az adatb\u00e1zis rendelkez\u00e9sre \u00e1ll\u00e1sa, a kapcsolatok sz\u00e1ma, az adatb\u00e1zis m\u00e9rete, a checkpointok, az olvas\u00e1si\/\u00edr\u00e1si sebess\u00e9g, a z\u00e1rol\u00e1sok, az automatikus takar\u00edt\u00e1si folyamatok sz\u00e1ma \u00e9s a WAL gener\u00e1l\u00e1s sebess\u00e9ge. A rendelkez\u00e9sre \u00e1ll\u00f3 metrik\u00e1k teljes list\u00e1ja, valamint az \u00f6sszes eszk\u00f6z r\u00e9szletes le\u00edr\u00e1sa el\u00e9rhet\u0151 a <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/postgrespro\/mamonsu\">t\u00e1rhelyen<\/a><\/noindex> GitHubon. <\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"PostgreSQL monitoroz\u00e1sa Zabbix haszn\u00e1lat\u00e1val\" src=\"\/wp-content\/uploads\/2020\/08\/259cc7f1b6ab0cf137cef6b4e9a22c0f.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p><em>A GitHubon el\u00e9rhet\u0151 metrik\u00e1k list\u00e1ja<\/em><\/p>\n<p><\/p>\n<h3 id=\"zapusk-mamonsu-za-5-minut\">Mamonsu telep\u00edt\u00e9se 5 perc alatt<\/h3>\n<p><\/p>\n<p>A PostgreSQL \u00e9s az oper\u00e1ci\u00f3s rendszer monitoroz\u00e1sa Mamonsu seg\u00edts\u00e9g\u00e9vel 5 perc alatt elv\u00e9gezhet\u0151, mind\u00f6ssze 5 egyszer\u0171 l\u00e9p\u00e9sben.<\/p>\n<p><\/p>\n<ol>\n<li><strong>Mamonsu telep\u00edt\u00e9se<\/strong>. A Mamonsu ak\u00e1r forr\u00e1sk\u00f3d alapj\u00e1n is \u00f6sszegy\u0171jthet\u0151, vagy el\u00e9rhet\u0151 csomagokat haszn\u00e1lhat.<\/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>Kapcsolatok be\u00e1ll\u00edt\u00e1sa<\/strong>. Meg kell adni a PostgreSQL \u00e9s a Zabbix Server k\u00f6z\u00f6tti kapcsolat param\u00e9tereit az agent.conf f\u00e1jlban.<\/li>\n<\/ol>\n<p><\/p>\n<p><code>\/etc\/mamonsu\/agent.conf<\/code><\/p>\n<p><\/p>\n<ol>\n<li><strong>Sablon export\u00e1l\u00e1sa a Zabbix Serverre<\/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>H\u00e1l\u00f3zati csom\u00f3pont hozz\u00e1ad\u00e1sa a Zabbix Serverhez<\/strong>. Az export\u00e1lt sablon automatikusan csatlakoztatva lesz az \u00faj h\u00e1l\u00f3zati csom\u00f3ponthoz a Zabbix Serveren.<\/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>Ind\u00edt\u00e1s<\/strong>.<\/li>\n<\/ol>\n<p><\/p>\n<p><code>$ service mamonsu start<\/code><\/p>\n<p><\/p>\n<h3 id=\"napravleniya-razvitiya-mamonsu\">A Mamonsu fejleszt\u00e9si ir\u00e1nyai<\/h3>\n<p><\/p>\n<p>A Mamonsu fejleszt\u00e9se sor\u00e1n a metrik\u00e1k tov\u00e1bbi kidolgoz\u00e1s\u00e1t \u00e9s \u00faj pluginek l\u00e9trehoz\u00e1s\u00e1t tervezz\u00fck, p\u00e9ld\u00e1ul egy adott t\u00e1bl\u00e1k m\u00e9ret\u00e9nek monitoroz\u00e1s\u00e1ra szolg\u00e1l\u00f3 plugint. Emellett tervezz\u00fck az eszk\u00f6z\u00f6k jav\u00edt\u00e1s\u00e1t \u00e9s \u00faj kieg\u00e9sz\u00edt\u00e9sek l\u00e9trehoz\u00e1s\u00e1t, valamint az automatikus be\u00e1ll\u00edt\u00e1si lehet\u0151s\u00e9gek kib\u0151v\u00edt\u00e9s\u00e9t a <strong>mamonsu tune<\/strong>. <\/p>\n<p><\/p>\n<h2 id=\"modul-monitoringa-postgresql-v-sostave-zabbix-agent-2\">PostgreSQL monitoring modul a Zabbix Agent 2 keretein bel\u00fcl<\/h2>\n<p><\/p>\n<p>A PostgreSQL el\u00e9r\u00e9s\u00e9hez gyors \u00e9s n\u00e9pszer\u0171 drivert haszn\u00e1lunk <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/jackc\/pgx\">pgx<\/a><\/noindex> (PG driver and toolkit for Go).<\/p>\n<p><\/p>\n<p>Jelenleg k\u00e9t interf\u00e9szt haszn\u00e1lunk: az Exportert, amely a kulcs alapj\u00e1n h\u00edvja meg a kezel\u0151t, \u00e9s a Zabbix Agent 2 Configurator\u00e1t, amely beolvassa \u00e9s ellen\u0151rzi a szerverrel val\u00f3 kapcsolat param\u00e9tereit, amelyek a konfigur\u00e1ci\u00f3s f\u00e1jlban vannak megadva.<\/p>\n<p><\/p>\n<p>Ig\u00e9nyt tartottunk a DB teljes\u00edtm\u00e9ny\u00e9nek optimaliz\u00e1l\u00e1s\u00e1ra az\u00e1ltal, hogy csoportos\u00edtjuk a metrik\u00e1kat \u00e9s kezel\u0151t (handler) haszn\u00e1lunk a metrik\u00e1k \u00e9s metrikacsoportok feldolgoz\u00e1s\u00e1hoz, valamint metrikacsoportokat defini\u00e1lunk JSON form\u00e1tumban, mint f\u00fcgg\u0151 v\u00e1ltoz\u00f3kat (dependency items), \u00e9s alacsony szint\u0171 felfedez\u00e9st (discovery rules) alkalmazunk. <\/p>\n<p><\/p>\n<h3 id=\"osnovnye-vozmozhnosti\">F\u0151bb lehet\u0151s\u00e9gek<\/h3>\n<p><\/p>\n<ul>\n<li>\u00e1lland\u00f3 kapcsolat fenntart\u00e1sa a PostgreSQL-lal az ellen\u0151rz\u00e9sek k\u00f6z\u00f6tt; <\/li>\n<li>rugalmass\u00e1g a k\u00e9rdez\u00e9si intervallumok tekintet\u00e9ben; <\/li>\n<li>kompatibilit\u00e1s a PostgreSQL 10-es verzi\u00f3j\u00e1t\u00f3l kezd\u0151d\u0151en, \u00e9s a Zabbix Server 4.4-es verzi\u00f3j\u00e1t\u00f3l.<\/li>\n<li>a PostgreSQL p\u00e9ld\u00e1nyok egyidej\u0171 csatlakoztat\u00e1s\u00e1nak \u00e9s figyel\u00e9s\u00e9nek lehet\u0151s\u00e9ge, mivel a Zabbix Agent 2 lehet\u0151v\u00e9 teszi t\u00f6bb munkamenet l\u00e9trehoz\u00e1s\u00e1t.<\/li>\n<\/ul>\n<p><\/p>\n<h3 id=\"urovni-parametrov-podklyucheniya-k-postgresql\">Csatlakoz\u00e1si param\u00e9terek szintjei a PostgreSQL-hez<\/h3>\n<p><\/p>\n<p>\u00d6sszesen h\u00e1rom csatlakoz\u00e1si param\u00e9terszint \u00e9rhet\u0151 el a PostgreSQL-hez, azaz feladatok \u00e9s be\u00e1ll\u00edt\u00e1sok:<\/p>\n<p><\/p>\n<ul>\n<li>Glob\u00e1lis,<\/li>\n<li>Munkamenetek,<\/li>\n<li>Makr\u00f3k.<\/li>\n<\/ul>\n<p><\/p>\n<ol>\n<li>\n<p>A Glob\u00e1lis param\u00e9tereket az \u00fcgyn\u00f6k szintj\u00e9n \u00e1ll\u00edtj\u00e1k be, a Munkamenetek \u00e9s a Makr\u00f3k hat\u00e1rozz\u00e1k meg az adatb\u00e1zishoz val\u00f3 csatlakoz\u00e1si param\u00e9tereket.<\/p>\n<p>\n<\/li>\n<li>\n<p>A PostgreSQL-hez val\u00f3 csatlakoz\u00e1si param\u00e9terek \u2014 Munkamenetek a k\u00f6vetkez\u0151 f\u00e1jlban vannak be\u00e1ll\u00edtva: <strong>zabbix_agent2.conf<\/strong>. <\/p>\n<p>\n<\/li>\n<\/ol>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"PostgreSQL monitoroz\u00e1sa Zabbix haszn\u00e1lat\u00e1val\" src=\"\/wp-content\/uploads\/2020\/08\/d88abf88cb106e81f0e7eb23a1d4a193.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p><em>A PostgreSQL-hez val\u00f3 csatlakoz\u00e1si param\u00e9terek \u2014 Munkamenetek<\/em><\/p>\n<p><\/p>\n<ul>\n<li>A kulcssz\u00f3 ut\u00e1n <strong>Munkamenetek<\/strong> egyedi munkamenetnevet kell megadni, amelyet a kulcsban (sablonban) kell megadni. <\/li>\n<li>Be\u00e1ll\u00edt\u00e1sok <strong>URI<\/strong> \u00e9s <strong>UserName<\/strong> minden munkamenethez k\u00f6telez\u0151. <\/li>\n<li>Ha az adatb\u00e1zis neve nincs megadva, akkor a PostgreSQL \u00f6sszes munkamenete sz\u00e1m\u00e1ra haszn\u00e1lt alap\u00e9rtelmezett n\u00e9v ker\u00fcl alkalmaz\u00e1sra, amely szint\u00e9n a konfigur\u00e1ci\u00f3s f\u00e1jlban van megadva.<\/li>\n<\/ul>\n<p><\/p>\n<ol>\n<li>A PostgreSQL-hez val\u00f3 csatlakoz\u00e1si param\u00e9terek \u2014 Makr\u00f3k a metrika kulcs\u00e1ba vannak be\u00e1ll\u00edtva a sablonban (hasonl\u00f3an az Zabbix Agent 1 \u00e1ltal haszn\u00e1lt m\u00f3dszerhez), azaz a sablonban j\u00f6nnek l\u00e9tre, \u00e9s ezut\u00e1n param\u00e9terekk\u00e9nt vannak felt\u00fcntetve a kulcsban. Ek\u00f6zben a makr\u00f3k sorrendje r\u00f6gz\u00edtett, azaz p\u00e9ld\u00e1ul <strong>URI<\/strong> mindig az els\u0151 helyen szerepel.<\/li>\n<\/ol>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"PostgreSQL monitoroz\u00e1sa Zabbix haszn\u00e1lat\u00e1val\" src=\"\/wp-content\/uploads\/2020\/08\/3918b9de0118f901e916542f955bd17b.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p><em>A PostgreSQL-hez val\u00f3 csatlakoz\u00e1si param\u00e9terek \u2014 Makr\u00f3k<\/em> <\/p>\n<p><\/p>\n<p>A PostgreSQL megfigyel\u0151 modulja m\u00e1r t\u00f6bb mint 95 metrik\u00e1t tartalmaz, amelyek lehet\u0151v\u00e9 teszik a PostgreSQL param\u00e9terek sz\u00e9les spektrum\u00e1nak lefed\u00e9s\u00e9t, bele\u00e9rtve:<\/p>\n<p><\/p>\n<ul>\n<li>csatlakoz\u00e1sok sz\u00e1ma,<\/li>\n<li>adatb\u00e1zisok m\u00e9rete, <\/li>\n<li>wal-f\u00e1jlok archiv\u00e1l\u00e1sa,<\/li>\n<li>ellen\u0151rz\u00e9si pontok,<\/li>\n<li>t\u00faln\u0151tt t\u00e1bl\u00e1k sz\u00e1ma,<\/li>\n<li>replik\u00e1ci\u00f3 \u00e1llapota,<\/li>\n<li>replika k\u00e9sleltet\u00e9se.<\/li>\n<\/ul>\n<p><\/p>\n<p>A PostgreSQL metrik\u00e1k nem inform\u00e1lnak az oper\u00e1ci\u00f3s rendszer param\u00e9terei n\u00e9lk\u00fcl. De a Zabbix Agent 2 m\u00e1r tudja gy\u0171jteni az oper\u00e1ci\u00f3s rendszer param\u00e9tereit, \u00edgy a teljes k\u00e9p megszerz\u00e9s\u00e9hez csup\u00e1n csatlakoztatnunk kell a megfelel\u0151 sablonokat a h\u00e1l\u00f3zati csom\u00f3ponthoz.<\/p>\n<p><\/p>\n<h3 id=\"obrabotchik-handler\">Handler (kezel\u0151)<\/h3>\n<p><\/p>\n<p>A handler (kezel\u0151) \u2014 a modul f\u0151 egys\u00e9ge, amelyben a lek\u00e9rdez\u00e9s v\u00e9grehajt\u00f3dik, \u00e9s amely lehet\u0151v\u00e9 teszi a metrik\u00e1k megk\u00fcld\u00e9s\u00e9t.<\/p>\n<p><\/p>\n<p>Egyszer\u0171 metrika kinyer\u00e9s\u00e9hez:<\/p>\n<p><\/p>\n<ol>\n<li>Hozzunk l\u00e9tre egy f\u00e1jlt egy \u00faj metrika kinyer\u00e9s\u00e9hez:<\/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>Kapcsoljuk be a csomagot, \u00e9s adjuk meg az egyedi kulcsot (kulcsokat) a metrik\u00e1khoz:<\/li>\n<\/ol>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"PostgreSQL monitoroz\u00e1sa Zabbix haszn\u00e1lat\u00e1val\" src=\"\/wp-content\/uploads\/2020\/08\/692acc55377c18ee37a9e1d426ebeccb.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<ol>\n<li>Hozzunk l\u00e9tre egy handlert (kezel\u0151t) a lek\u00e9rdez\u00e9ssel, azaz hozzunk l\u00e9tre egy v\u00e1ltoz\u00f3t, amelyben az eredm\u00e9ny t\u00e1rol\u00f3dik:<\/li>\n<\/ol>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"PostgreSQL monitoroz\u00e1sa Zabbix haszn\u00e1lat\u00e1val\" src=\"\/wp-content\/uploads\/2020\/08\/79e10e34edb78942acb6a264896be12d.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<ol>\n<li>V\u00e9gezz\u00fck el a lek\u00e9rdez\u00e9st:<\/li>\n<\/ol>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"PostgreSQL monitoroz\u00e1sa Zabbix haszn\u00e1lat\u00e1val\" src=\"\/wp-content\/uploads\/2020\/08\/b7555bba37978302337ea0093dd1bb5c.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>Ellen\u0151rizn\u00fcnk kell a lek\u00e9rdez\u00e9st hib\u00e1k miatt, majd az eredm\u00e9ny a Zabbix Agent 2 folyamat \u00e1ltali feldolgoz\u00e1sra ker\u00fcl. <\/p>\n<p><\/p>\n<ol>\n<li>Regisztr\u00e1ljuk az \u00faj metrika kulcs\u00e1t:<\/li>\n<\/ol>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"PostgreSQL monitoroz\u00e1sa Zabbix haszn\u00e1lat\u00e1val\" src=\"\/wp-content\/uploads\/2020\/08\/63256811903feacc5cf88e0a272aebd9.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>A metrika regisztr\u00e1ci\u00f3ja ut\u00e1n \u00faj metrik\u00e1val \u00fajra \u00f6ssze lehet szerelni az \u00fcgyn\u00f6k\u00f6t.<\/p>\n<p><\/p>\n<p>A modul el\u00e9rhet\u0151 a Zabbix 5.0-t\u00f3l kezdve a weboldalon. <noindex><a rel=\"nofollow\" href=\"https:\/\/www.zabbix.com\/download\">https:\/\/www.zabbix.com\/download<\/a><\/noindex>. Ebben a Zabbix verzi\u00f3ban a param\u00e9tereket k\u00fcl\u00f6n-k\u00fcl\u00f6n kell megadni a host \u00e9s a port seg\u00edts\u00e9g\u00e9vel. A hamarosan megjelen\u0151 Zabbix 5.0.2-es verzi\u00f3ban a csatlakoz\u00e1si param\u00e9terek egy URI-ba lesznek \u00f6sszevonva.<\/p>\n<p><\/p>\n<p>K\u00f6sz\u00f6n\u00f6m a figyelmet! <\/p>\n<p><\/p>\n<h2 id=\"poleznye-ssylki\">Hasznos linkek<\/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\u00e1ci\u00f3 a Mamonsu-hoz<\/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>Forr\u00e1s: <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.3 - 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\/hu\/blog\/administrirovanie\/monitoring-postgresql-s-ispolzovaniem-zabbix\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.3\" \/>\n\t\t<meta property=\"og:locale\" content=\"hu_HU\" \/>\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\/hu\/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 monitoroz\u00e1s Zabbix seg\u00edts\u00e9g\u00e9vel | ProHoster","description":"Darja Vilkova el\u0151ad\u00e1sa a Zabbix Meetup-r\u00f3l.","canonical_url":"https:\/\/prohoster.info\/hu\/blog\/administrirovanie\/monitoring-postgresql-s-ispolzovaniem-zabbix","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"hu_HU","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\/hu\/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\/hu\/wp-json\/wp\/v2\/posts\/91969","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/comments?post=91969"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/posts\/91969\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/media\/91970"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/media?parent=91969"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/categories?post=91969"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/tags?post=91969"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}