{"id":52686,"date":"2019-11-14T00:00:00","date_gmt":"2019-11-13T21:00:00","guid":{"rendered":"https:\/\/prohoster.info\/blog\/blog_prohoster\/nastraivaem-ofitsialnyj-shablon-postgresql-na-zabbix-4-4"},"modified":"2020-02-18T14:00:28","modified_gmt":"2020-02-18T11:00:28","slug":"nastraivaem-ofitsialnyj-shablon-postgresql-na-zabbix-4-4","status":"publish","type":"post","link":"https:\/\/prohoster.info\/hu\/blog\/administrirovanie\/nastraivaem-ofitsialnyj-shablon-postgresql-na-zabbix-4-4","title":{"rendered":"Be\u00e1ll\u00edtjuk a hivatalos PostgreSQL sablont a Zabbix 4.4-hez.","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

Hell\u00f3 mindenkinek.<\/p>\n

A Zabbix-ban megjelent a hivatalos Template DB PostgreSQL<\/b>. Ebben a cikkben be\u00e1ll\u00edtjuk a Zabbix 4.4-ben.<\/p>\n

\"Be\u00e1ll\u00edtjuk<\/p>\n

MEGJEGYZ\u00c9S<\/b><\/p>\n

Ha j\u00f3l besz\u00e9lsz angolul, javaslom, hogy haszn\u00e1ld a sablont a hivatalos \u00fatmutat\u00f3 szerint<\/p>\n

github.com\/zabbix\/zabbix\/tree\/master\/templates\/db\/postgresql<\/a><\/noindex><\/p>\n

Ennek ellen\u00e9re a cikkemben figyelembe vettem azokat a r\u00e9szleteket, amelyek itt nincsenek.\n<\/p><\/blockquote>\n

<\/a><\/noindex><\/p>\n

Sablon el\u0151k\u00e9sz\u00edt\u00e9se<\/h2>\n

\n1. L\u00e9pj\u00fcnk a home k\u00f6nyvt\u00e1rba.<\/p>\n

cd ~<\/code><\/pre>\n
\n2. Telep\u00edts\u00fck a git eszk\u00f6zt, majd kl\u00f3nozzuk a Zabbix hivatalos t\u00e1rol\u00f3j\u00e1t, amely a GitHub-on tal\u00e1lhat\u00f3.<\/p>\n
yum -y install git\ngit clone https:\/\/github.com\/zabbix\/zabbix.git<\/code><\/pre>\n
\n3. L\u00e9pj\u00fcnk a PostgreSQL sablon k\u00f6nyvt\u00e1r\u00e1ba.<\/p>\n
cd zabbix\/templates\/db\/postgresql\/<\/code><\/pre>\n
<\/p>\n
A sablon be\u00e1ll\u00edt\u00e1sa a Zabbix \u00fcgyn\u00f6k sz\u00e1m\u00e1ra<\/h2>\n
\n1. Csatlakozunk a PostgreSQL-hez.<\/p>\n
psql -U postgres<\/code><\/pre>\n
\n2. Hozzunk l\u00e9tre egy zbx_monitor nev\u0171 felhaszn\u00e1l\u00f3t, aki csak olvas\u00e1si jogokkal rendelkezik, \u00e9s hozz\u00e1f\u00e9r a PostgreSQL szerverhez.<\/p>\n
PostgreSQL 10-es \u00e9s \u00fajabb verzi\u00f3khoz:<\/p>\n
CREATE USER zbx_monitor WITH PASSWORD '<AZ_\u00d6N_JELSZAVA>' INHERIT; GRANT pg_monitor TO zbx_monitor;<\/code><\/pre>\n
\nPostgreSQL 9.6-os \u00e9s r\u00e9gebbi verzi\u00f3khoz:<\/p>\n
CREATE USER zbx_monitor WITH PASSWORD '<AZ_\u00d6N_JELSZAVA>';\nGRANT SELECT ON pg_stat_database TO zbx_monitor;\n\n--A WAL metrik\u00e1k gy\u0171jt\u00e9s\u00e9hez a felhaszn\u00e1l\u00f3nak superuser jogokkal kell rendelkeznie.\nALTER USER zbx_monitor WITH SUPERUSER;<\/code><\/pre>\n
\n3. M\u00e1soljuk \u00e1t a postgresql\/ k\u00f6nyvt\u00e1rat a \/var\/lib\/zabbix\/ k\u00f6nyvt\u00e1rba. Ha a \/var\/lib\/ k\u00f6nyvt\u00e1rban nincs zabbix\/ k\u00f6nyvt\u00e1r, hozza l\u00e9tre azt. A postgresql\/ k\u00f6nyvt\u00e1r olyan f\u00e1jlokat tartalmaz, amelyek sz\u00fcks\u00e9gesek a PostgreSQL-b\u0151l t\u00f6rt\u00e9n\u0151 metrikagy\u0171jt\u00e9shez.<\/p>\n
cp -r postgresql\/ \/var\/lib\/zabbix\/<\/code><\/pre>\n
\n4. Ezut\u00e1n m\u00e1soljuk \u00e1t a template_db_postgresql.conf f\u00e1jlt a Zabbix \u00fcgyn\u00f6k konfigur\u00e1ci\u00f3s k\u00f6nyvt\u00e1r\u00e1ba \/etc\/zabbix\/zabbix_agentd.d\/ \u00e9s ind\u00edtsuk \u00fajra a Zabbix \u00fcgyn\u00f6k\u00f6t.<\/p>\n
cp template_db_postgresql.conf \/etc\/zabbix\/zabbix_agentd.d\/<\/code><\/pre>\n
\n5. Most szerkessz\u00fck meg a pg_hba.conf f\u00e1jlt, hogy enged\u00e9lyezz\u00fck a Zabbix-hez val\u00f3 csatlakoz\u00e1st. Tov\u00e1bbi inform\u00e1ci\u00f3 a pg_hba.conf f\u00e1jlr\u00f3l: https:\/\/www.postgresql.org\/docs\/current\/auth-pg-hba-conf.html<\/a><\/noindex>.<\/p>\n
Nyissuk meg a f\u00e1jlt:<\/p>\n
vi \/var\/lib\/pgsql\/12\/data\/pg_hba.conf<\/code><\/pre>\n
\nAdjon hozz\u00e1 egy sort (Ha nem \u00e9rted, mi\u00e9rt sz\u00fcks\u00e9ges ez, akkor csak az els\u0151 sort add hozz\u00e1):<\/p>\n
host all zbx_monitor 127.0.0.1\/32 trust\nhost all zbx_monitor 0.0.0.0\/0 md5\nhost all zbx_monitor ::0\/0 md5<\/code><\/pre>\n
MEGJEGYZ\u00c9S<\/b><\/p>\n
Ha a PostgreSQL a PGDG t\u00e1rol\u00f3b\u00f3l lett telep\u00edtve, adja hozz\u00e1 a pg_isready \u00fatvonal\u00e1t a zabbix felhaszn\u00e1l\u00f3 PATH k\u00f6rnyezeti v\u00e1ltoz\u00f3j\u00e1hoz.<\/p>\n
P\u00e9ld\u00e1ul:<\/b><\/p>\n
ln -s \/usr\/pgsql-12\/bin\/pg_isready \/usr\/bin\/pg_isready<\/code><\/pre>\n
\n* \u2014 mivel nekem pgsql 12 verzi\u00f3m van, \u00edgy \u00f6nnek a pgsql-12 helyett m\u00e1s \u00fatvonal lesz.<\/i><\/p>\n
Ha ezt nem tetted meg, akkor a St\u00e1tusz: Ping mindig Down \u00e1llapotban lesz.\n<\/p><\/blockquote>\n
<\/p>\n
Sablon hozz\u00e1ad\u00e1sa a Zabbix frontendj\u00e9n<\/h2>\n
\n\u00dagy gondolom, hogy azok, akik szeretn\u00e9k begy\u0171jteni a PostgreSQL metrik\u00e1kat, m\u00e1r tudj\u00e1k, hogyan kell sablonokat hozz\u00e1adni. Ez\u00e9rt csak r\u00f6viden ismertetem a folyamatot.<\/p>\n
    \n
  1. L\u00e9pj\u00fcnk be a Zabbix oldal\u00e1ra;<\/li>\n
  2. L\u00e9pj\u00fcnk tov\u00e1bb a \u201eKonfigur\u00e1ci\u00f3<\/b>\u201e => \u201eHost<\/b>\u201e;<\/li>\n
  3. Nyomjuk meg a \u201eCreate host<\/b>\u201e vagy v\u00e1lasszunk egy megl\u00e9v\u0151 hosztot;<\/li>\n
  4. A hoszt l\u00e9trehoz\u00e1sa\/szerkeszt\u00e9se oldalon v\u00e1lasszuk a \u201eTemplates<\/b>\u201e f\u00fclet, majd kattintsunk a \u201eEzut\u00e1n adja meg az Amazon S3-hoz val\u00f3 hozz\u00e1f\u00e9r\u00e9shez sz\u00fcks\u00e9ges fi\u00f3kot \u2014 v\u00e1lassza ki a megl\u00e9v\u0151t a list\u00e1b\u00f3l, vagy kattintson<\/b>\u201e;<\/li>\n
  5. A \u201eGroup\u201d list\u00e1b\u00f3l v\u00e1lasszuk a \u201eTemplates\/Databases\u201d lehet\u0151s\u00e9get, majd v\u00e1lasszuk a \u201eTemplate DB PostgreSQL<\/b>\u201e sablont, nyomjuk meg a \u201eSelect<\/b>\u201e gombot, majd kattintsunk a \u201eFriss\u00edt\u00e9s<\/b>\u201e;<\/li>\n<\/ol>\n
    \nV\u00e1rjunk egy ideig, majd v\u00e9g\u00fcl l\u00e9pj\u00fcnk a \u201eMonitoring<\/b>\u201e => \u201eLegfrissebb adatok<\/b>\u201e => \u201eGazd\u00e1k<\/b>\u201e v\u00e1lasszunk egy PostgreSQL szervert => nyomjuk meg a \u201eApply<\/b>A «ALTER TABLE» \u00e9s «RENAME TABLE» m\u0171veletekben t\u00e1mogat\u00e1sra ker\u00fclt a «IF EXISTS» felt\u00e9tel, amely lehet\u0151v\u00e9 teszi az oper\u00e1ci\u00f3 v\u00e9grehajt\u00e1s\u00e1t a t\u00e1bla l\u00e9tez\u00e9se eset\u00e9n. <\/p>\n
    \"Be\u00e1ll\u00edtjuk
    \nJ\u00f3 sz\u00f3rakoz\u00e1st!
    \n
    Forr\u00e1s:     habr.com<\/a><\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"
    \u0412\u0441\u0435\u043c \u043f\u0440\u0438\u0432\u0435\u0442. \u0412 Zabbix \u043f\u043e\u044f\u0432\u0438\u043b\u0441\u044f \u043e\u0444\u0438\u0446\u0438\u0430\u043b\u044c\u043d\u044b\u0439 Template DB PostgreSQL. \u0412 \u044d\u0442\u043e\u0439 \u0441\u0442\u0430\u0442\u044c\u0435 \u043d\u0430\u0441\u0442\u0440\u043e\u0438\u043c \u0435\u0433\u043e \u0432 Zabbix 4.4. \u041f\u0420\u0418\u041c\u0415\u0427\u0410\u041d\u0418\u0415 \u0415\u0441\u043b\u0438 \u0443 \u0432\u0430\u0441 \u0432\u0441\u0435 \u0445\u043e\u0440\u043e\u0448\u043e \u0441 \u0430\u043d\u0433\u043b\u0438\u0439\u0441\u043a\u0438\u043c, \u0442\u043e \u0440\u0435\u043a\u043e\u043c\u0435\u043d\u0434\u0443\u044e \u0443\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u0442\u044c \u0448\u0430\u0431\u043b\u043e\u043d \u043f\u043e \u043e\u0444\u0438\u0446\u0438\u0430\u043b\u044c\u043d\u043e\u043c\u0443 \u043c\u0430\u043d\u0443\u0430\u043b\u0443 github.com\/zabbix\/zabbix\/tree\/master\/templates\/db\/postgresql \u0422\u0435\u043c \u043d\u0435 \u043c\u0435\u043d\u0435\u0435 \u0432 \u043c\u043e\u0435\u0439 \u0441\u0442\u0430\u0442\u044c\u0435 \u0443\u0447\u0442\u0435\u043d\u044b \u043d\u044e\u0430\u043d\u0441\u044b, \u043a\u043e\u0442\u043e\u0440\u044b\u0445 \u043d\u0435\u0442 \u043f\u043e \u044d\u0442\u043e\u0439 \u0441\u0441\u044b\u043b\u043a\u0435. \u041f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u043a\u0430 \u0448\u0430\u0431\u043b\u043e\u043d\u0430 1. \u041f\u0435\u0440\u0435\u0445\u043e\u0434\u0438\u043c \u0432 \u0434\u043e\u043c\u0430\u0448\u043d\u0438\u0439 \u043a\u0430\u0442\u0430\u043b\u043e\u0433. cd ~ […]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[688],"tags":[],"class_list":["post-52686","post","type-post","status-publish","format-standard","hentry","category-administrirovanie"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\n","aioseo_head_json":{"title":"\ud83e\udd47Be\u00e1ll\u00edtjuk a hivatalos PostgreSQL sablont a Zabbix 4.4-en | ProHoster","description":"\u00dcdv\u00f6zlet mindenkinek. A Zabbixban megjelent az hivatalos Template DB PostgreSQL.","canonical_url":"https:\/\/prohoster.info\/hu\/blog\/administrirovanie\/nastraivaem-ofitsialnyj-shablon-postgresql-na-zabbix-4-4","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\u041d\u0430\u0441\u0442\u0440\u0430\u0438\u0432\u0430\u0435\u043c \u043e\u0444\u0438\u0446\u0438\u0430\u043b\u044c\u043d\u044b\u0439 \u0448\u0430\u0431\u043b\u043e\u043d PostgreSQL \u043d\u0430 Zabbix 4.4 | ProHoster","og:description":"\u0412\u0441\u0435\u043c \u043f\u0440\u0438\u0432\u0435\u0442. \u0412 Zabbix \u043f\u043e\u044f\u0432\u0438\u043b\u0441\u044f \u043e\u0444\u0438\u0446\u0438\u0430\u043b\u044c\u043d\u044b\u0439 Template DB PostgreSQL.","og:url":"https:\/\/prohoster.info\/hu\/blog\/administrirovanie\/nastraivaem-ofitsialnyj-shablon-postgresql-na-zabbix-4-4","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":"2019-11-13T21:00:00+00:00","article:modified_time":"2020-02-18T11:00:28+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"52686","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":"2026-01-24 04:27:20","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-02-28 20:39:25","updated":"2026-01-24 04:27:20","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\/52686","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=52686"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/posts\/52686\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/media?parent=52686"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/categories?post=52686"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/tags?post=52686"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}