{"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\/it\/blog\/news\/vypusk-temboard-8-0-interfejsa-dlya-udalyonnogo-upravleniya-subd-postgresql","title":{"rendered":"Rilascio di temBoard 8.0, interfaccia per la gestione remota del DBMS PostgreSQL.","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>\u00c8 stato rilasciato il progetto temBoard 8.0, che sviluppa un'interfaccia web per la gestione remota, il monitoraggio, la configurazione e l'ottimizzazione del DBMS PostgreSQL. Il prodotto include un agente leggero, installato su ogni server con PostgreSQL, e un componente server che gestisce centralmente gli agenti e raccoglie statistiche per il monitoraggio. Il codice \u00e8 scritto in Python e distribuito con una licenza libera, la PostgreSQL License.    <\/p>\n<p>Caratteristiche principali di temBoard:  <\/p>\n<ul>\n<li class=\"l\"> Possibilit\u00e0 di gestire centinaia di istanze di DBMS PostgreSQL tramite un'unica interfaccia web centralizzata.\n<li class=\"l\"> Disponibilit\u00e0 di schermi informativi per valutare sia lo stato generale di tutti i DBMS che una valutazione pi\u00f9 dettagliata di ciascuna istanza.  <center><img decoding=\"async\" alt=\"Rilascio di temBoard 8.0, interfaccia per la gestione remota del DBMS PostgreSQL.\" src=\"\/wp-content\/uploads\/2022\/11\/1202a1d022bb8d2644f60fefef812594.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/center>\n<li class=\"l\"> Monitoraggio dello stato del DBMS utilizzando diverse metriche.\n<li class=\"l\"> Supporto per la gestione delle sessioni attive attualmente nel DBMS.\n<li class=\"l\"> Monitoraggio delle operazioni di pulizia (VACUUM) di tabelle e indici.\n<li class=\"l\"> Monitoraggio delle query lente al database.\n<li class=\"l\"> Interfaccia per ottimizzare le impostazioni di PostgreSQL.  <\/ul>\n<p>Nella nuova versione:  <\/p>\n<ul>\n<li class=\"l\"> \u00c8 stata rivista l'autenticazione e l'organizzazione del canale di collegamento tra l'interfaccia di gestione e gli agenti. Le modifiche hanno semplificato il dispiegamento degli agenti e migliorato la sicurezza del canale di comunicazione con essi. Tutte le richieste agli agenti sono ora ulteriormente firmate digitalmente utilizzando la crittografia asimmetrica con chiavi pubbliche, mentre l'interfaccia funge da fornitore di identificazione per gli agenti. L'autenticazione con password, concordata sia dall'agente che dall'interfaccia, non \u00e8 pi\u00f9 utilizzata. Ora le password vengono utilizzate solo per organizzare la connessione degli utenti all'interfaccia.\n<li class=\"l\"> \u00c8 stata proposta una nuova interfaccia a riga di comando. Le utilit\u00e0 separate temboard-migratedb e temboard-agent-register sono state sostituite da comandi integrati, richiamabili tramite i file eseguibili temboard e temboard-agent. Sono stati aggiunti comandi integrati per eseguire operazioni tipiche di amministrazione e monitoraggio dalla riga di comando.\n<li class=\"l\"> \u00c8 stato aggiunto il supporto per PostgreSQL 15, RHEL 9 e Debian 12. \u00c8 terminato il supporto per PostgreSQL 9.4 e 9.5, cos\u00ec come per Python 2.7 e 3.5.\n<li class=\"l\"> In temboard \u00e8 stato aggiunto il comando &#171;register-instance&#187; per la registrazione degli agenti, che a differenza del comando &#171;temboard-agent register&#187;, viene eseguito dal lato <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/it\/server\/dts-los-angeles\/\"   title=\"server\" data-wpil-keyword-link=\"linked\"  data-wpil-monitor-id=\"3873\">server<\/a> e non richiede l'accesso in rete dell'agente, ovvero pu\u00f2 essere utilizzato per aggiungere nuovi istanti in modalit\u00e0 offline.\n<li class=\"l\"> Ridotto il carico dell'agente sul sistema \u2014 il numero delle transazioni eseguite \u00e8 stato ridotto del 25%, implementata la cache dei valori standard e il multiplexing delle attivit\u00e0.\n<li class=\"l\"> Per impostazione predefinita, la dimensione dei dati di monitoraggio memorizzati \u00e8 ridotta a 2 anni.\n<li class=\"l\"> Aggiunta la possibilit\u00e0 di caricare i dati di inventario in formato CSV.\n<li class=\"l\"> Garantito il riavvio automatico dei processi in background dell'interfaccia e dell'agente dopo il termine anomalo.  <\/ul>\n<p>Aggiuntivamente, si segnala il rilascio dello strumento Pyrseas 0.10.0, progettato per supportare i database PostgreSQL e automatizzare le operazioni di aggiornamento della struttura dei dati. Pyrseas converte uno schema standard con una struttura di database e i metadati associati in formato YAML o JSON, pi\u00f9 adatto per l'uso in sistemi di controllo versione. Utilizzando la rappresentazione in formato YAML, Pyrseas genera SQL per eseguire la sincronizzazione della struttura di un database con un altro (ovvero \u00e8 possibile apportare facilmente modifiche alla struttura e propagandole ad altri database). Il codice del progetto \u00e8 scritto in Python e distribuito con licenza BSD.   <\/p>\n<p>La nuova versione di Pyrseas si distingue per il passaggio a Psycopg 3, una versione completamente revisionata del modulo per lavorare con PostgreSQL nei programmi Python, che supporta l'interazione asincrona con il database e fornisce interfacce basate su DBAPI e asyncio. Nella nuova versione, inoltre, \u00e8 stata interrotta la compatibilit\u00e0 con Python 2.x e rimosso pgdbconn dalle dipendenze. \u00c8 garantito il supporto per le versioni di PostgreSQL dalla 10 alla 15.<br \/>\n<br \/>Fonte: <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\/it\/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=\"it_IT\" \/>\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\/it\/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\udd47Uscita di temBoard 8.0, interfaccia per la gestione remota del DBMS PostgreSQL | ProHoster","description":"\u00c8 stato rilasciato il progetto temBoard 8.0, che sviluppa un'interfaccia web per la gestione remota, il monitoraggio, la configurazione e l'ottimizzazione di database PostgreSQL.","canonical_url":"https:\/\/prohoster.info\/it\/blog\/news\/vypusk-temboard-8-0-interfejsa-dlya-udalyonnogo-upravleniya-subd-postgresql","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"it_IT","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\/it\/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\/it\/wp-json\/wp\/v2\/posts\/105573","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/it\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/it\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/it\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/it\/wp-json\/wp\/v2\/comments?post=105573"}],"version-history":[{"count":1,"href":"https:\/\/prohoster.info\/it\/wp-json\/wp\/v2\/posts\/105573\/revisions"}],"predecessor-version":[{"id":162401,"href":"https:\/\/prohoster.info\/it\/wp-json\/wp\/v2\/posts\/105573\/revisions\/162401"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/it\/wp-json\/wp\/v2\/media\/105574"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/it\/wp-json\/wp\/v2\/media?parent=105573"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/it\/wp-json\/wp\/v2\/categories?post=105573"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/it\/wp-json\/wp\/v2\/tags?post=105573"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}