{"id":105573,"date":"2022-11-15T15:36:43","date_gmt":"2022-11-15T13:36:43","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/vypusk-temboard-8-0-interfejsa-dlya-udalyonnogo-upravleniya-subd-postgresql"},"modified":"2022-11-15T15:36:43","modified_gmt":"2022-11-15T13:36:43","slug":"vypusk-temboard-8-0-interfejsa-dlya-udalyonnogo-upravleniya-subd-postgresql","status":"publish","type":"post","link":"https:\/\/prohoster.info\/et\/blog\/news\/vypusk-temboard-8-0-interfejsa-dlya-udalyonnogo-upravleniya-subd-postgresql","title":{"rendered":"temBoard 8.0 v\u00e4ljaanne, PostgreSQL andmebaasi eemalt haldamise liidese jaoks","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>temBoard 8.0 projekti v\u00e4ljaanne, mis arendab veebiliidest PostgreSQL andmebaasi eemalt haldamiseks, monitooringuks, seadistamiseks ja optimeerimiseks, on n\u00e4htavale t\u00f5usnud. Toode sisaldab kerget agenti, mis paigaldatakse igale PostgreSQL serverile, ja serverikomponenti, mis haldab agente keskelt ja kogub statistikat monitooringuks. Kood on kirjutatud Python'is ja levitatakse PostgreSQL litsentsi all.    <\/p>\n<p>temBoardi p\u00f5hifunktsioonid:  <\/p>\n<ul>\n<li class=\"l\"> V\u00f5imalus hallata sadu PostgreSQL andmebaasi eksemplare \u00fchest keskset veebiliidest.\n<li class=\"l\"> Infokraanide olemasolu, et hinnata nii k\u00f5igi andmebaaside \u00fcldist seisundit kui ka \u00fcksikute eksemplaride \u00fcksikasjalikku hindamist.  <center><img decoding=\"async\" alt=\"temBoard 8.0 v\u00e4ljaanne, PostgreSQL andmebaasi eemalt haldamise liidese jaoks\" src=\"\/wp-content\/uploads\/2022\/11\/1202a1d022bb8d2644f60fefef812594.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/center>\n<li class=\"l\"> Andmebaasi monitooring erinevate m\u00f5\u00f5dikute abil.\n<li class=\"l\"> Toetab aktiivsete seansside juhtimist andmebaasis.\n<li class=\"l\"> Tabelite ja indeksite puhastamise (VACUUM) toimingute j\u00e4lgimine.\n<li class=\"l\"> Aeglaste p\u00e4ringute j\u00e4lgimine andmebaasi.\n<li class=\"l\"> Liides PostgreSQL seadete optimeerimiseks.  <\/ul>\n<p>Uues versioonis:  <\/p>\n<ul>\n<li class=\"l\"> Autentimine ja sidekanali korraldus halduri liidese ja agentide vahel on \u00fcle vaadatud. Muudatused on l\u00e4inud agentide kasutuselev\u00f5tu lihtsustamise ja sidekanali turvalisuse suurendamise suunas. K\u00f5ik p\u00e4ringud agentidele on n\u00fc\u00fcd t\u00e4iendavalt digitaalselt allkirjastatud as\u00fcmmeetrilise kr\u00fcpteerimise abil avalike v\u00f5tmete kaudu, samas kui liides toimib identifitseerimise pakkujana agentide jaoks. Parooliga autentimine, mis m\u00e4\u00e4ratakse \u00fchiselt agendi ja liidese poolel, enam ei kehti. Paroolide kaudu korraldatakse n\u00fc\u00fcd ainult kasutajate \u00fchendamine liidesega.\n<li class=\"l\"> Uus k\u00e4suviibaliides on soovitatud. Eraldi utiliidid temboard-migratedb ja temboard-agent-register on asendatud sisse ehitatud k\u00e4skudega, mida kutsutakse esile temboard ja temboard-agent k\u00e4ivitatavate failide kaudu. Lisatud on sisse ehitatud k\u00e4sud t\u00fc\u00fcpiliste haldus- ja monitooringu toimingute t\u00e4itmiseks k\u00e4suviibast.\n<li class=\"l\"> Toetatakse PostgreSQL 15, RHEL 9 ja Debian 12. Toetamine PostgreSQL 9.4 ja 9.5 ning Python 2.7 ja 3.5 on l\u00f5petatud.\n<li class=\"l\"> Temboardi on lisatud k\u00e4sk \u201eregister-instance\u201d, mis erineb k\u00e4sust \u201etemboard-agent register\u201d, kuna seda t\u00f6\u00f6deldakse serveris. <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/et\/server\/dts-los-angeles\/\"   title=\"serverilt\" data-wpil-keyword-link=\"linked\"  data-wpil-monitor-id=\"3873\">serverilt<\/a> ja ei vaja agenti v\u00f5rgu\u00fchendust, s.t. saab kasutada uute eksemplaride lisamiseks offline-re\u017eiimis.\n<li class=\"l\"> Agenendi s\u00fcsteemikoormus on v\u00e4henenud \u2014 tehingute arvu on k\u00e4rbitud 25%, lisatud on t\u00fc\u00fcpv v\u00e4\u00e4rtuste vahem\u00e4lu ning \u00fclesannete multiplikatsioon.\n<li class=\"l\"> Vaikeperioodiks on j\u00e4lgimisandmete s\u00e4ilitamise aeg l\u00fchendatud kahe aastani.\n<li class=\"l\"> On lisatud v\u00f5imalus inventeerimisandmete \u00fcleslaadimiseks CSV-formaadis.\n<li class=\"l\"> Tagatud on taustprotsesside automaatne taask\u00e4ivitamine liidese ja agendi juures p\u00e4rast ootamatut l\u00f5petamist.  <\/ul>\n<p>T\u00e4iendavalt tasub m\u00e4rkida, et v\u00e4lja on antud t\u00f6\u00f6riistade komplekt Pyrseas 0.10.0, mis on m\u00f5eldud PostgreSQL andmebaaside haldamiseks ja andmestruktuuri uuendamise automatiseerimiseks. Pyrseas konverteerib standardse andmebaasistruktuuri skeemi ja sellega seotud metaandmed YAML- v\u00f5i JSON-formaadiks, mis on paremini kasutatav versioonihalduss\u00fcsteemides. Kasutades YAML-v\u00e4lja, genereerib Pyrseas SQL-i, et viia \u00fche andmebaasi struktuur vastavusse teisega (st struktuuri muudatuste tegemine ja nende levitamine teistele andmebaasidele on lihtne). Projekti kood on kirjutatud Pythonis ja seda levitatakse BSD litsentsi alusel.   <\/p>\n<p>Uue Pyrseas v\u00e4ljaanne on t\u00e4helepanuv\u00e4\u00e4rne \u00fcleminekuga Psycopg 3-le, t\u00e4ielikult \u00fcmber t\u00f6\u00f6tatud PostgreSQL-i mooduli harule Python-programmides, mis toetab as\u00fcnkroonset suhtlemist andmebaasiga ja pakub DBAPI ja asyncio p\u00f5hjal interface. Uues versioonis on l\u00f5petatud ka Python 2.x toe pakkumine ning s\u00f5ltuvusest on eemaldatud pgdbconn. Toetatakse PostgreSQL-i versioone 10 kuni 15.<br \/>\n<br \/>Allikas: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=58115\">opennet.ru<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u0423\u0432\u0438\u0434\u0435\u043b \u0441\u0432\u0435\u0442 \u0432\u044b\u043f\u0443\u0441\u043a \u043f\u0440\u043e\u0435\u043a\u0442\u0430 temBoard 8.0, \u0440\u0430\u0437\u0432\u0438\u0432\u0430\u044e\u0449\u0435\u0433\u043e web-\u0438\u043d\u0442\u0435\u0440\u0444\u0435\u0439\u0441 \u0434\u043b\u044f \u0443\u0434\u0430\u043b\u0451\u043d\u043d\u043e\u0433\u043e \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f, \u043c\u043e\u043d\u0438\u0442\u043e\u0440\u0438\u043d\u0433\u0430, \u043d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0438 \u0438 \u043e\u043f\u0442\u0438\u043c\u0438\u0437\u0430\u0446\u0438\u0438 \u0421\u0423\u0411\u0414 PostgreSQL. \u041f\u0440\u043e\u0434\u0443\u043a\u0442 \u0432\u043a\u043b\u044e\u0447\u0430\u0435\u0442 \u0432 \u0441\u0435\u0431\u044f \u043b\u0435\u0433\u043a\u043e\u0432\u0435\u0441\u043d\u044b\u0439 \u0430\u0433\u0435\u043d\u0442, \u0443\u0441\u0442\u0430\u043d\u0430\u0432\u043b\u0438\u0432\u0430\u0435\u043c\u044b\u0439 \u043d\u0430 \u043a\u0430\u0436\u0434\u044b\u0439 \u0441\u0435\u0440\u0432\u0435\u0440 \u0441 PostgreSQL, \u0438 \u0441\u0435\u0440\u0432\u0435\u0440\u043d\u044b\u0439 \u043a\u043e\u043c\u043f\u043e\u043d\u0435\u043d\u0442, \u0446\u0435\u043d\u0442\u0440\u0430\u043b\u0438\u0437\u043e\u0432\u0430\u043d\u043d\u043e \u0443\u043f\u0440\u0430\u0432\u043b\u044f\u044e\u0449\u0438\u0439 \u0430\u0433\u0435\u043d\u0442\u0430\u043c\u0438 \u0438 \u0441\u043e\u0431\u0438\u0440\u0430\u044e\u0449\u0438\u0439 \u0441\u0442\u0430\u0442\u0438\u0441\u0442\u0438\u043a\u0443 \u0434\u043b\u044f \u043c\u043e\u043d\u0438\u0442\u043e\u0440\u0438\u043d\u0433\u0430. \u041a\u043e\u0434 \u043d\u0430\u043f\u0438\u0441\u0430\u043d \u043d\u0430 \u044f\u0437\u044b\u043a\u0435 Python \u0438 \u0440\u0430\u0441\u043f\u0440\u043e\u0441\u0442\u0440\u0430\u043d\u044f\u0435\u0442\u0441\u044f \u043f\u043e\u0434 \u0441\u0432\u043e\u0431\u043e\u0434\u043d\u043e\u0439 \u043b\u0438\u0446\u0435\u043d\u0437\u0438\u0435\u0439 PostgreSQL License. \u041e\u0441\u043d\u043e\u0432\u043d\u044b\u0435 \u043e\u0441\u043e\u0431\u0435\u043d\u043d\u043e\u0441\u0442\u0438 temBoard: [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":105574,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[702],"tags":[],"class_list":["post-105573","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.1.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u0423\u0432\u0438\u0434\u0435\u043b \u0441\u0432\u0435\u0442 \u0432\u044b\u043f\u0443\u0441\u043a \u043f\u0440\u043e\u0435\u043a\u0442\u0430 temBoard 8.0, \u0440\u0430\u0437\u0432\u0438\u0432\u0430\u044e\u0449\u0435\u0433\u043e web-\u0438\u043d\u0442\u0435\u0440\u0444\u0435\u0439\u0441 \u0434\u043b\u044f \u0443\u0434\u0430\u043b\u0451\u043d\u043d\u043e\u0433\u043e \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f, \u043c\u043e\u043d\u0438\u0442\u043e\u0440\u0438\u043d\u0433\u0430, \u043d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0438 \u0438 \u043e\u043f\u0442\u0438\u043c\u0438\u0437\u0430\u0446\u0438\u0438 \u0421\u0423\u0411\u0414 PostgreSQL.\" \/>\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\/news\/vypusk-temboard-8-0-interfejsa-dlya-udalyonnogo-upravleniya-subd-postgresql\" \/>\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\u0412\u044b\u043f\u0443\u0441\u043a temBoard 8.0, \u0438\u043d\u0442\u0435\u0440\u0444\u0435\u0439\u0441\u0430 \u0434\u043b\u044f \u0443\u0434\u0430\u043b\u0451\u043d\u043d\u043e\u0433\u043e \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f \u0421\u0423\u0411\u0414 PostgreSQL | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u0423\u0432\u0438\u0434\u0435\u043b \u0441\u0432\u0435\u0442 \u0432\u044b\u043f\u0443\u0441\u043a \u043f\u0440\u043e\u0435\u043a\u0442\u0430 temBoard 8.0, \u0440\u0430\u0437\u0432\u0438\u0432\u0430\u044e\u0449\u0435\u0433\u043e web-\u0438\u043d\u0442\u0435\u0440\u0444\u0435\u0439\u0441 \u0434\u043b\u044f \u0443\u0434\u0430\u043b\u0451\u043d\u043d\u043e\u0433\u043e \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f, \u043c\u043e\u043d\u0438\u0442\u043e\u0440\u0438\u043d\u0433\u0430, \u043d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0438 \u0438 \u043e\u043f\u0442\u0438\u043c\u0438\u0437\u0430\u0446\u0438\u0438 \u0421\u0423\u0411\u0414 PostgreSQL.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/et\/blog\/news\/vypusk-temboard-8-0-interfejsa-dlya-udalyonnogo-upravleniya-subd-postgresql\" \/>\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=\"2022-11-15T13:36:43+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2022-11-15T13:36:43+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\udd47TemBoard 8.0 v\u00e4ljaanne, PostgreSQL andmebaasi kaugjuhtimise liides | ProHoster","description":"Valmis temBoard 8.0 v\u00e4ljaanne, mis arendab veebiliidese kaugjuhtimiseks, j\u00e4lgimiseks, seadistamiseks ja PostgreSQL andmebaasi optimeerimiseks.","canonical_url":"https:\/\/prohoster.info\/et\/blog\/news\/vypusk-temboard-8-0-interfejsa-dlya-udalyonnogo-upravleniya-subd-postgresql","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\u0412\u044b\u043f\u0443\u0441\u043a temBoard 8.0, \u0438\u043d\u0442\u0435\u0440\u0444\u0435\u0439\u0441\u0430 \u0434\u043b\u044f \u0443\u0434\u0430\u043b\u0451\u043d\u043d\u043e\u0433\u043e \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f \u0421\u0423\u0411\u0414 PostgreSQL | ProHoster","og:description":"\u0423\u0432\u0438\u0434\u0435\u043b \u0441\u0432\u0435\u0442 \u0432\u044b\u043f\u0443\u0441\u043a \u043f\u0440\u043e\u0435\u043a\u0442\u0430 temBoard 8.0, \u0440\u0430\u0437\u0432\u0438\u0432\u0430\u044e\u0449\u0435\u0433\u043e web-\u0438\u043d\u0442\u0435\u0440\u0444\u0435\u0439\u0441 \u0434\u043b\u044f \u0443\u0434\u0430\u043b\u0451\u043d\u043d\u043e\u0433\u043e \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f, \u043c\u043e\u043d\u0438\u0442\u043e\u0440\u0438\u043d\u0433\u0430, \u043d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0438 \u0438 \u043e\u043f\u0442\u0438\u043c\u0438\u0437\u0430\u0446\u0438\u0438 \u0421\u0423\u0411\u0414 PostgreSQL.","og:url":"https:\/\/prohoster.info\/et\/blog\/news\/vypusk-temboard-8-0-interfejsa-dlya-udalyonnogo-upravleniya-subd-postgresql","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":"2022-11-15T13:36:43+00:00","article:modified_time":"2022-11-15T13:36:43+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"105573","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":"default","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":"2026-02-22 15:31:07","updated":"2026-02-22 15:31:07","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\/105573","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=105573"}],"version-history":[{"count":1,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts\/105573\/revisions"}],"predecessor-version":[{"id":162401,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts\/105573\/revisions\/162401"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/media\/105574"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/media?parent=105573"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/categories?post=105573"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/tags?post=105573"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}