https:\/\/github.com\/dalibo\/temboard\/issues\/879<\/a><\/p>\nIt is not a major issue, however, it is quite confusing if you see users executing a SQL statement, where you know that those user never did. Fortunately, the upgrade from 7.3 to 7.4 is quite simply. In general, you need only to stop the service, upgrade the rpm package, and start the service again.<\/p>\n
\n$ sudo systemctl stop temboard.service\n$ sudo systemctl stop temboard-agent@12-pg58888.service\n$ sudo systemctl reset-failed\n$ sudo systemctl is-system-running\n\n$ cd \/var\/log\/temboard\/\n$ sudo mv temboard.log temboard.log.before_upgrade_to_7.4\n\n$ cd \/app\/lib\/postgres\/pgproduct\/stage\/temboard\/7\/\n$ sudo yum localupdate temboard-7.4-1.el7.noarch.rpm\n$ sudo yum localupdate temboard-agent-7.5-1.el7.noarch.rpm\n<\/pre>\nUpgrade the temBoard (UI) from 7.3 to 7.4<\/p>\n
\n$ sudo yum localupdate temboard-7.4-1.el7.noarch.rpm\nLoaded plugins: enabled_repos_upload, langpacks, package_upload, product-id, search-disabled-repos, subscription-manager\nExamining temboard-7.4-1.el7.noarch.rpm: temboard-7.4-1.el7.noarch\nMarking temboard-7.4-1.el7.noarch.rpm as an update to temboard-7.3-1.el7.noarch\nResolving Dependencies\n--> Running transaction check\n---> Package temboard.noarch 0:7.3-1.el7 will be updated\n---> Package temboard.noarch 0:7.4-1.el7 will be an update\n--> Finished Dependency Resolution\nepel\/x86_64\/metalink | 26 kB 00:00:00\nepel\/x86_64 | 4.7 kB 00:00:00\nepel\/x86_64\/updateinfo | 1.0 MB 00:00:00\nepel\/x86_64\/primary_db | 6.9 MB 00:00:00\nrhel-7-server-extras-rpms\/x86_64 | 2.0 kB 00:00:00\nrhel-7-server-optional-rpms\/x86_64 | 2.0 kB 00:00:00\nrhel-7-server-rh-common-rpms\/x86_64 | 2.1 kB 00:00:00\nrhel-7-server-rpms\/x86_64 | 2.0 kB 00:00:00\nrhel-7-server-satellite-tools-6.7-rpms\/x86_64 | 2.1 kB 00:00:00\nrhel-7-server-supplementary-rpms\/x86_64 | 2.3 kB 00:00:00\nrhel-server-rhscl-7-rpms\/x86_64 | 2.3 kB 00:00:00\n\nDependencies Resolved\n\n===================================================================================================================================================================================\n Package Arch Version Repository Size\n===================================================================================================================================================================================\nUpdating:\n temboard noarch 7.4-1.el7 \/temboard-7.4-1.el7.noarch 3.9 M\n\nTransaction Summary\n===================================================================================================================================================================================\nUpgrade 1 Package\n\nTotal size: 3.9 M\nIs this ok [y\/d\/N]: y\nDownloading packages:\nRunning transaction check\nRunning transaction test\nTransaction test succeeded\nRunning transaction\n Updating : temboard-7.4-1.el7.noarch 1\/2\n Cleanup : temboard-7.3-1.el7.noarch 2\/2\nUploading Package Profile\nLoaded plugins: langpacks, product-id, subscription-manager\n Verifying : temboard-7.4-1.el7.noarch 1\/2\n Verifying : temboard-7.3-1.el7.noarch 2\/2\n\nUpdated:\n temboard.noarch 0:7.4-1.el7\n\nComplete!\nUploading Enabled Repositories Report\nLoaded plugins: langpacks, product-id, subscription-manager\n<\/pre>\nUpgrade the temBoard agent from 7.4 to 7.5.<\/p>\n
\n$ sudo yum localupdate temboard-agent-7.5-1.el7.noarch.rpm\nLoaded plugins: enabled_repos_upload, langpacks, package_upload, product-id, search-disabled-repos, subscription-manager\nExamining temboard-agent-7.5-1.el7.noarch.rpm: temboard-agent-7.5-1.el7.noarch\nMarking temboard-agent-7.5-1.el7.noarch.rpm as an update to temboard-agent-7.4-1.el7.noarch\nResolving Dependencies\n--> Running transaction check\n---> Package temboard-agent.noarch 0:7.4-1.el7 will be updated\n---> Package temboard-agent.noarch 0:7.5-1.el7 will be an update\n--> Finished Dependency Resolution\nrhel-7-server-extras-rpms\/x86_64 | 2.0 kB 00:00:00\nrhel-7-server-optional-rpms\/x86_64 | 2.0 kB 00:00:00\nrhel-7-server-rh-common-rpms\/x86_64 | 2.1 kB 00:00:00\nrhel-7-server-rpms\/x86_64 | 2.0 kB 00:00:00\nrhel-7-server-satellite-tools-6.7-rpms\/x86_64 | 2.1 kB 00:00:00\nrhel-7-server-supplementary-rpms\/x86_64 | 2.3 kB 00:00:00\nrhel-server-rhscl-7-rpms\/x86_64 | 2.3 kB 00:00:00\n\nDependencies Resolved\n\n===================================================================================================================================================================================\n Package Arch Version Repository Size\n===================================================================================================================================================================================\nUpdating:\n temboard-agent noarch 7.5-1.el7 \/temboard-agent-7.5-1.el7.noarch 945 k\n\nTransaction Summary\n===================================================================================================================================================================================\nUpgrade 1 Package\n\nTotal size: 945 k\nIs this ok [y\/d\/N]: y\nDownloading packages:\nRunning transaction check\nRunning transaction test\nTransaction test succeeded\nRunning transaction\n Updating : temboard-agent-7.5-1.el7.noarch 1\/2\nNo units found for temboard-agent.\nToo few arguments.\n Cleanup : temboard-agent-7.4-1.el7.noarch 2\/2\nUploading Package Profile\nLoaded plugins: langpacks, product-id, subscription-manager\n Verifying : temboard-agent-7.5-1.el7.noarch 1\/2\n Verifying : temboard-agent-7.4-1.el7.noarch 2\/2\n\nUpdated:\n temboard-agent.noarch 0:7.5-1.el7\n\nComplete!\nUploading Enabled Repositories Report\nLoaded plugins: langpacks, product-id, subscription-manager\n\n<\/pre>\nNow run the database upgrade as the temboard OS user.<\/p>\n
\n$ su - temboard\n\n$ temboard-migratedb upgrade\n INFO: Starting temboard-migratedb 7.4.\n INFO: Found config file \/etc\/temboard\/temboard.conf.\n INFO: Context impl PostgresqlImpl.\n INFO: Will assume transactional DDL.\n INFO: Database up to date.\n<\/pre>\nI usually adjust the temboard service as well with the nice value of -19. (Nice=-19). This is an optional step and not mandatory. I do it only to give the temBoard service the highest CPU priority.<\/p>\n
\n$ cd \/etc\/systemd\/system\/multi-user.target.wants\/\n$ sudo vi temboard.service\n\n$ cat temboard.service\n[Unit]\nDescription=temBoard Web UI\nAfter=network.target\n\n[Service]\nType=simple\nUser=temboard\nGroup=temboard\nExecStart=\/usr\/bin\/env SYSTEMD=1 temboard -c \/etc\/temboard\/temboard.conf\nNice=-19\n\n[Install]\nWantedBy=multi-user.target\n<\/pre>\nStartup the temBoard UI and the agent.<\/p>\n
\n$ sudo systemctl daemon-reload\n\n$ sudo systemctl start temboard.service\n$ sudo systemctl start temboard-agent@12-pg58888.service\n<\/pre>\nCheck if the services are running correctly.<\/p>\n
\n$ sudo systemctl status temboard.service\n? temboard.service - temBoard Web UI\n Loaded: loaded (\/usr\/lib\/systemd\/system\/temboard.service; enabled; vendor preset: disabled)\n Active: active (running) since Sun 2021-01-03 09:47:51 CET; 17s ago\n Main PID: 30953 (temboard)\n CGroup: \/system.slice\/temboard.service\n +-30953 temboard: web\n +-30960 temboard: worker pool\n +-30961 temboard: scheduler\n +-30973 temboard: worker pool\n\n\n$ sudo systemctl status temboard-agent@12-pg58888.service\n? temboard-agent@12-pg58888.service - PostgreSQL Remote Control Agent 12\/pg58888\n Loaded: loaded (\/usr\/lib\/systemd\/system\/temboard-agent@.service; enabled; vendor preset: disabled)\n Active: active (running) since Sun 2021-01-03 09:47:59 CET; 49s ago\n Main PID: 31234 (temboard-agent)\n CGroup: \/system.slice\/system-temboard\\x2dagent.slice\/temboard-agent@12-pg58888.service\n +-31234 temboard-agent: 12\/pg58888: main process\n +-31688 temboard-agent: 12\/pg58888: worker pool\n +-31689 temboard-agent: 12\/pg58888: scheduler\n\n<\/pre>\nReady. \ud83d\ude42<\/p>\n
Conclusion<\/h3>\n
The temBoard 7.4 is a quite small bug fixing release, however, if you are using the statements plugin, this might be quite interesting for you.<\/p>\n","protected":false},"excerpt":{"rendered":"
Dalibo released a quite important temBoard bugfixing release right before Christmas last year. Especially if you are using the statements plugin, this might be interesting to you. The new verions are temBoard version 7.4 and temBoard agent version 7.5. The latest version for Red Hat\/CentOS 7.x can be found here: https:\/\/yum.dalibo.org\/labs\/CentOS7-x86_64\/ temboard-7.4-1.el7.noarch.rpm 15-Dec-2020 temboard-agent-7.5-1.el7.noarch.rpm 14-Dec-2020 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ocean_post_layout":"","ocean_both_sidebars_style":"","ocean_both_sidebars_content_width":0,"ocean_both_sidebars_sidebars_width":0,"ocean_sidebar":"","ocean_second_sidebar":"","ocean_disable_margins":"enable","ocean_add_body_class":"","ocean_shortcode_before_top_bar":"","ocean_shortcode_after_top_bar":"","ocean_shortcode_before_header":"","ocean_shortcode_after_header":"","ocean_has_shortcode":"","ocean_shortcode_after_title":"","ocean_shortcode_before_footer_widgets":"","ocean_shortcode_after_footer_widgets":"","ocean_shortcode_before_footer_bottom":"","ocean_shortcode_after_footer_bottom":"","ocean_display_top_bar":"default","ocean_display_header":"default","ocean_header_style":"","ocean_center_header_left_menu":"","ocean_custom_header_template":"","ocean_custom_logo":0,"ocean_custom_retina_logo":0,"ocean_custom_logo_max_width":0,"ocean_custom_logo_tablet_max_width":0,"ocean_custom_logo_mobile_max_width":0,"ocean_custom_logo_max_height":0,"ocean_custom_logo_tablet_max_height":0,"ocean_custom_logo_mobile_max_height":0,"ocean_header_custom_menu":"","ocean_menu_typo_font_family":"","ocean_menu_typo_font_subset":"","ocean_menu_typo_font_size":0,"ocean_menu_typo_font_size_tablet":0,"ocean_menu_typo_font_size_mobile":0,"ocean_menu_typo_font_size_unit":"px","ocean_menu_typo_font_weight":"","ocean_menu_typo_font_weight_tablet":"","ocean_menu_typo_font_weight_mobile":"","ocean_menu_typo_transform":"","ocean_menu_typo_transform_tablet":"","ocean_menu_typo_transform_mobile":"","ocean_menu_typo_line_height":0,"ocean_menu_typo_line_height_tablet":0,"ocean_menu_typo_line_height_mobile":0,"ocean_menu_typo_line_height_unit":"","ocean_menu_typo_spacing":0,"ocean_menu_typo_spacing_tablet":0,"ocean_menu_typo_spacing_mobile":0,"ocean_menu_typo_spacing_unit":"","ocean_menu_link_color":"","ocean_menu_link_color_hover":"","ocean_menu_link_color_active":"","ocean_menu_link_background":"","ocean_menu_link_hover_background":"","ocean_menu_link_active_background":"","ocean_menu_social_links_bg":"","ocean_menu_social_hover_links_bg":"","ocean_menu_social_links_color":"","ocean_menu_social_hover_links_color":"","ocean_disable_title":"default","ocean_disable_heading":"default","ocean_post_title":"","ocean_post_subheading":"","ocean_post_title_style":"","ocean_post_title_background_color":"","ocean_post_title_background":0,"ocean_post_title_bg_image_position":"","ocean_post_title_bg_image_attachment":"","ocean_post_title_bg_image_repeat":"","ocean_post_title_bg_image_size":"","ocean_post_title_height":0,"ocean_post_title_bg_overlay":0.5,"ocean_post_title_bg_overlay_color":"","ocean_disable_breadcrumbs":"default","ocean_breadcrumbs_color":"","ocean_breadcrumbs_separator_color":"","ocean_breadcrumbs_links_color":"","ocean_breadcrumbs_links_hover_color":"","ocean_display_footer_widgets":"default","ocean_display_footer_bottom":"default","ocean_custom_footer_template":"","ocean_post_oembed":"","ocean_post_self_hosted_media":"","ocean_post_video_embed":"","ocean_link_format":"","ocean_link_format_target":"self","ocean_quote_format":"","ocean_quote_format_link":"post","ocean_gallery_link_images":"on","ocean_gallery_id":[],"footnotes":""},"categories":[6],"tags":[21,24],"class_list":["post-184","post","type-post","status-publish","format-standard","hentry","category-postgresql","tag-postgresql","tag-temboard","entry"],"yoast_head":"\n
PostgreSQL: How to Upgrade temBoard Version 7.3 to 7.4 - ptdb - Platinum DB<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ptdb.ch\/?p=184\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PostgreSQL: How to Upgrade temBoard Version 7.3 to 7.4 - ptdb - Platinum DB\" \/>\n<meta property=\"og:description\" content=\"Dalibo released a quite important temBoard bugfixing release right before Christmas last year. Especially if you are using the statements plugin, this might be interesting to you. The new verions are temBoard version 7.4 and temBoard agent version 7.5. The latest version for Red Hat\/CentOS 7.x can be found here: https:\/\/yum.dalibo.org\/labs\/CentOS7-x86_64\/ temboard-7.4-1.el7.noarch.rpm 15-Dec-2020 temboard-agent-7.5-1.el7.noarch.rpm 14-Dec-2020 […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ptdb.ch\/?p=184\" \/>\n<meta property=\"og:site_name\" content=\"ptdb - Platinum DB\" \/>\n<meta property=\"article:published_time\" content=\"2021-01-03T10:25:17+00:00\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ptdb.ch\/?p=184\",\"url\":\"https:\/\/ptdb.ch\/?p=184\",\"name\":\"PostgreSQL: How to Upgrade temBoard Version 7.3 to 7.4 - ptdb - Platinum DB\",\"isPartOf\":{\"@id\":\"https:\/\/ptdb.ch\/#website\"},\"datePublished\":\"2021-01-03T10:25:17+00:00\",\"author\":{\"@id\":\"https:\/\/ptdb.ch\/#\/schema\/person\/0b7baf52d23e71d85e1c95442306090b\"},\"breadcrumb\":{\"@id\":\"https:\/\/ptdb.ch\/?p=184#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ptdb.ch\/?p=184\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ptdb.ch\/?p=184#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/ptdb.ch\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PostgreSQL: How to Upgrade temBoard Version 7.3 to 7.4\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/ptdb.ch\/#website\",\"url\":\"https:\/\/ptdb.ch\/\",\"name\":\"ptdb - Platinum DB\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/ptdb.ch\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/ptdb.ch\/#\/schema\/person\/0b7baf52d23e71d85e1c95442306090b\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/ptdb.ch\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1a3dffc48c5f6bae0b88a9f0b2a986d48d322673fbc2880c5abbfab96e45da8a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1a3dffc48c5f6bae0b88a9f0b2a986d48d322673fbc2880c5abbfab96e45da8a?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"sameAs\":[\"https:\/\/ptdb.ch\"],\"url\":\"https:\/\/ptdb.ch\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"PostgreSQL: How to Upgrade temBoard Version 7.3 to 7.4 - ptdb - Platinum DB","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/ptdb.ch\/?p=184","og_locale":"en_US","og_type":"article","og_title":"PostgreSQL: How to Upgrade temBoard Version 7.3 to 7.4 - ptdb - Platinum DB","og_description":"Dalibo released a quite important temBoard bugfixing release right before Christmas last year. Especially if you are using the statements plugin, this might be interesting to you. The new verions are temBoard version 7.4 and temBoard agent version 7.5. The latest version for Red Hat\/CentOS 7.x can be found here: https:\/\/yum.dalibo.org\/labs\/CentOS7-x86_64\/ temboard-7.4-1.el7.noarch.rpm 15-Dec-2020 temboard-agent-7.5-1.el7.noarch.rpm 14-Dec-2020 […]","og_url":"https:\/\/ptdb.ch\/?p=184","og_site_name":"ptdb - Platinum DB","article_published_time":"2021-01-03T10:25:17+00:00","author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/ptdb.ch\/?p=184","url":"https:\/\/ptdb.ch\/?p=184","name":"PostgreSQL: How to Upgrade temBoard Version 7.3 to 7.4 - ptdb - Platinum DB","isPartOf":{"@id":"https:\/\/ptdb.ch\/#website"},"datePublished":"2021-01-03T10:25:17+00:00","author":{"@id":"https:\/\/ptdb.ch\/#\/schema\/person\/0b7baf52d23e71d85e1c95442306090b"},"breadcrumb":{"@id":"https:\/\/ptdb.ch\/?p=184#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ptdb.ch\/?p=184"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/ptdb.ch\/?p=184#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/ptdb.ch\/"},{"@type":"ListItem","position":2,"name":"PostgreSQL: How to Upgrade temBoard Version 7.3 to 7.4"}]},{"@type":"WebSite","@id":"https:\/\/ptdb.ch\/#website","url":"https:\/\/ptdb.ch\/","name":"ptdb - Platinum DB","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ptdb.ch\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/ptdb.ch\/#\/schema\/person\/0b7baf52d23e71d85e1c95442306090b","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/ptdb.ch\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/1a3dffc48c5f6bae0b88a9f0b2a986d48d322673fbc2880c5abbfab96e45da8a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1a3dffc48c5f6bae0b88a9f0b2a986d48d322673fbc2880c5abbfab96e45da8a?s=96&d=mm&r=g","caption":"admin"},"sameAs":["https:\/\/ptdb.ch"],"url":"https:\/\/ptdb.ch\/?author=1"}]}},"_links":{"self":[{"href":"https:\/\/ptdb.ch\/index.php?rest_route=\/wp\/v2\/posts\/184","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ptdb.ch\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ptdb.ch\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ptdb.ch\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ptdb.ch\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=184"}],"version-history":[{"count":0,"href":"https:\/\/ptdb.ch\/index.php?rest_route=\/wp\/v2\/posts\/184\/revisions"}],"wp:attachment":[{"href":"https:\/\/ptdb.ch\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=184"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ptdb.ch\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=184"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ptdb.ch\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=184"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}