{"id":476,"date":"2025-12-10T09:10:33","date_gmt":"2025-12-10T09:10:33","guid":{"rendered":"https:\/\/ptdb.ch\/?p=476"},"modified":"2025-12-10T12:42:59","modified_gmt":"2025-12-10T12:42:59","slug":"postgresql-how-to-upgrade-temboard-from-9-0-1-to-10-0-0","status":"publish","type":"post","link":"https:\/\/ptdb.ch\/?p=476","title":{"rendered":"PostgreSQL: How to Upgrade temBoard from 9.0.1 to 10.0.0"},"content":{"rendered":"<p>Dalibo released on the 08th of December temBoard version 10.0.0. The new release does not come with\u00a0 a lot of new features, however, it is still worth upgrading, because temBoard 10.0.0 supports now PostgreSQL 18 and Red Hat 10.<\/p>\n<p>The top changes are<\/p>\n<ul>\n<li>Fix register-instance CLI<\/li>\n<li>Fix running daemonized<\/li>\n<li>Raise proper error on unknown environment<\/li>\n<li>Improve alerting performance<\/li>\n<li>Support Tornado 6.4 on RHEL9<\/li>\n<li>Postgres 18 support<\/li>\n<li>Requires Python 3.9<\/li>\n<li>Packages for Debian Trixie<\/li>\n<li>Packages for RHEL 10<\/li>\n<li>Add cookie_timeout to UI configuration<\/li>\n<li>Drop PyPI availability. Use APT\/YUM repositories or GitHub releases<\/li>\n<li>Deprecated: agent plugin administration is ignored<\/li>\n<li>Add Databases list in CSV Export<\/li>\n<li>Allow password reset in login page<\/li>\n<li>Add pagination in the UI home page<\/li>\n<li>UI colorblind-friendly improvements<\/li>\n<\/ul>\n<p>For more information take a look at the following link<\/p>\n<p><a href=\"https:\/\/temboard.readthedocs.io\/en\/latest\/changelog\/\">https:\/\/temboard.readthedocs.io\/en\/latest\/changelog\/<\/a><\/p>\n<p>You can compare changes between release 9.0.1 and 10.0.0 and see how many changes went into this release<\/p>\n<p><a href=\"https:\/\/github.com\/dalibo\/temboard\/compare\/v9.0.1...v10.0.0\">https:\/\/github.com\/dalibo\/temboard\/compare\/v9.0.1&#8230;v10.0.0<\/a><\/p>\n<p>However, in this blog post I would like to focus on the upgrade procedure to the version 10.0.0.<\/p>\n<p>Before you start, read the upgrade docs carefully. You can find them here.<\/p>\n<p><a href=\"https:\/\/temboard.readthedocs.io\/en\/latest\/server_upgrade\/\">https:\/\/temboard.readthedocs.io\/en\/latest\/server_upgrade\/<\/a><\/p>\n<p>From a high level view, the most important steps are:<\/p>\n<ul>\n<li>Download the rpm files for your Linux release (RHEL 9.x in my case)<br \/>\n<a href=\"https:\/\/github.com\/dalibo\/temboard\">https:\/\/github.com\/dalibo\/temboard<\/a><\/li>\n<li>Backup your repository database<\/li>\n<li>Backup temboard.conf, temboard-agent.conf and other temboard related files<\/li>\n<li>Upgrade first the agents to at least 9.0.1 if not already done<\/li>\n<li>Upgrade temboard to 10.0.0<\/li>\n<li>Upgrade temboard agents to 10.0.0<\/li>\n<\/ul>\n<p>In this blog post, I will jump right into the temBoard server and temBoard Agent upgrade process.<\/p>\n<p>Check the installed version.<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\n$ rpm -qa | grep temboard\r\ntemboard-9.0.1-1.el9.noarch\r\ntemboard-agent-9.0.1-1.el9.noarch\r\n<\/pre>\n<p>Stop the temBoard server and agent and start with a clean log file.<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\n$ sudo systemctl stop temboard-agent@PGMP01A.service\r\n$ sudo systemctl stop temboard.service\r\n$ sudo systemctl reset-failed\r\n$ sudo systemctl is-system-running\r\nrunning\r\n$ cd \/var\/log\/temboard\/\r\n$ sudo mv temboard.log temboard.log.before_upgrade_to_10.0.0\r\n$ cd \/etc\/temboard\/; cp -p temboard.conf temboard.conf.20251209a\r\n<\/pre>\n<p>Run the localupdate command with the new rpm.<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\n$ sudo dnf localupdate temboard-10.0.0-1.el9.x86_64.rpm\r\nUpdating Subscription Management repositories.\r\n\r\nThis system has release set to 9 and it receives updates only for this release.\r\n\r\nRed Hat Satellite Client 6 for RHEL 9 x86_64 (RPMs) 39 kB\/s | 2.3 kB 00:00\r\nRed Hat CodeReady Linux Builder for RHEL 9 x86_64 (RPMs) 72 kB\/s | 2.9 kB 00:00\r\nRed Hat Enterprise Linux 9 for x86_64 - AppStream (RPMs) 57 kB\/s | 2.9 kB 00:00\r\nRed Hat Enterprise Linux 9 for x86_64 - BaseOS (RPMs) 63 kB\/s | 2.6 kB 00:00\r\nRed Hat Enterprise Linux 9 for x86_64 - Supplementary (RPMs) 41 kB\/s | 2.0 kB 00:00\r\nDependencies resolved.\r\n==========================================================================================================================================================================================\r\nPackage Architecture Version Repository Size\r\n==========================================================================================================================================================================================\r\nUpgrading:\r\ntemboard x86_64 10.0.0-1.el9 @commandline 4.9 M\r\n\r\nTransaction Summary\r\n==========================================================================================================================================================================================\r\nUpgrade 1 Package\r\n\r\nTotal size: 4.9 M\r\nIs this ok &#x5B;y\/N]: y\r\nDownloading Packages:\r\nRunning transaction check\r\nTransaction check succeeded.\r\nRunning transaction test\r\nTransaction test succeeded.\r\nRunning transaction\r\nPreparing : 1\/1\r\nUpgrading : temboard-10.0.0-1.el9.x86_64 1\/2\r\nRunning scriptlet: temboard-10.0.0-1.el9.x86_64 1\/2\r\nRunning scriptlet: temboard-9.0.1-1.el9.noarch 2\/2\r\nCleanup : temboard-9.0.1-1.el9.noarch 2\/2\r\nRunning scriptlet: temboard-9.0.1-1.el9.noarch 2\/2\r\nVerifying : temboard-10.0.0-1.el9.x86_64 1\/2\r\nVerifying : temboard-9.0.1-1.el9.noarch 2\/2\r\nInstalled products updated.\r\n\r\nUpgraded:\r\ntemboard-10.0.0-1.el9.x86_64\r\n\r\nComplete!\r\n<\/pre>\n<p>Now upgrade the temBoard agent.<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\n$ sudo dnf localupdate temboard-agent-10.0.0-1.el9.noarch.rpm\r\nUpdating Subscription Management repositories.\r\n\r\nThis system has release set to 9 and it receives updates only for this release.\r\n\r\nRed Hat Satellite Client 6 for RHEL 9 x86_64 (RPMs) 38 kB\/s | 2.3 kB 00:00\r\nRed Hat CodeReady Linux Builder for RHEL 9 x86_64 (RPMs) 55 kB\/s | 2.9 kB 00:00\r\nRed Hat Enterprise Linux 9 for x86_64 - AppStream (RPMs) 54 kB\/s | 2.9 kB 00:00\r\nRed Hat Enterprise Linux 9 for x86_64 - BaseOS (RPMs) 54 kB\/s | 2.6 kB 00:00\r\nRed Hat Enterprise Linux 9 for x86_64 - Supplementary (RPMs) 35 kB\/s | 2.0 kB 00:00\r\nDependencies resolved.\r\n==========================================================================================================================================================================================\r\nPackage Architecture Version Repository Size\r\n==========================================================================================================================================================================================\r\nUpgrading:\r\ntemboard-agent noarch 10.0.0-1.el9 @commandline 307 k\r\n\r\nTransaction Summary\r\n==========================================================================================================================================================================================\r\nUpgrade 1 Package\r\n\r\nTotal size: 307 k\r\nIs this ok &#x5B;y\/N]: y\r\nDownloading Packages:\r\nRunning transaction check\r\nTransaction check succeeded.\r\nRunning transaction test\r\nTransaction test succeeded.\r\nRunning transaction\r\nPreparing : 1\/1\r\nUpgrading : temboard-agent-10.0.0-1.el9.noarch 1\/2\r\nRunning scriptlet: temboard-agent-10.0.0-1.el9.noarch 1\/2\r\nRunning scriptlet: temboard-agent-9.0.1-1.el9.noarch 2\/2\r\nCleanup : temboard-agent-9.0.1-1.el9.noarch 2\/2\r\nRunning scriptlet: temboard-agent-9.0.1-1.el9.noarch 2\/2\r\nVerifying : temboard-agent-10.0.0-1.el9.noarch 1\/2\r\nVerifying : temboard-agent-9.0.1-1.el9.noarch 2\/2\r\nInstalled products updated.\r\n\r\nUpgraded:\r\ntemboard-agent-10.0.0-1.el9.noarch\r\n\r\nComplete!\r\n<\/pre>\n<p>Run the temBoard migration script. Before doing that, you need to switch to the temboard OS user.<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\n$ su - temboard\r\nPassword:\r\nLast login: Mon Dec 8 20:50:42 CET 2025 from 10.86.48.22 on pts\/1\r\ntemboard@host01:\/var\/lib\/temboard\r\n$\r\n<\/pre>\n<p>You might also want to check the help page, to see all available commands.<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\n$ \/usr\/bin\/temboard --help\r\nINFO: app: Starting temboard. version=10.0.0\r\nusage: temboard &#x5B;-h] &#x5B;-c CONFIGFILE] &#x5B;--verbose] &#x5B;-V] COMMAND ...\r\n\r\ntemBoard UI 10.0.0.\r\n\r\nCOMMAND is optional. Default command is `serve`, the combined\r\nservice. See available commands below.\r\n\r\noptional arguments:\r\n-h, --help show this help message and exit\r\n-c CONFIGFILE, --config CONFIGFILE\r\nConfiguration file\r\n--verbose, --debug Enable verbose messages for temBoard.\r\n-V, --version show version and exit\r\n\r\nAvailable commands:\r\nCOMMAND Name of one sub-command described bellow.\r\napikey Manage API keys.\r\ngenerate-key Generate signing key.\r\nmigratedb Manage temBoard own database.\r\nquery-agent Query a temBoard agent\r\nregister-instance Out-of-bound registration of a PostgreSQL instance.\r\nroutes List HTTP routes map.\r\nserve Combined web server and background workers.\r\ntasks Manage background tasks.\r\nweb Standalone web server.\r\n<\/pre>\n<p>Now run the migratedb script.<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\n\r\n$ temboard migratedb upgrade\r\nINFO: app: Starting temboard. version=10.0.0\r\nINFO: app: Using config file \/etc\/temboard\/temboard.conf.\r\n<\/pre>\n<p>This time, you will not see any entries in the postgresql database log file, because no SQL is applied this time.<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\n...\r\n...\r\n<\/pre>\n<p>Adjust the temBoard systemd service.<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\n$ cd \/etc\/systemd\/system\/\r\n$ sudo vi temboard.service\r\n$ cat temboard.service\r\n&#x5B;Unit]\r\nDescription=temBoard Server\r\nAfter=network.target\r\n\r\n&#x5B;Service]\r\nType=simple\r\nUser=temboard\r\nGroup=temboard\r\nEnvironment=&quot;SYSTEMD=1&quot;\r\nEnvironment=&quot;LD_LIBRARY_PATH=\/app\/lib\/postgres\/pgproduct\/pg-18.1\/lib&quot;\r\nExecStart=\/usr\/bin\/temboard -c \/etc\/temboard\/temboard.conf serve\r\nExecReload=\/bin\/kill -HUP $MAINPID\r\n\r\n&#x5B;Install]\r\nWantedBy=multi-user.target\r\n<\/pre>\n<p>Adjust the temBoard agent systemd service.<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\n$ cd \/etc\/systemd\/system\/multi-user.target.wants\/\r\n$ sudo vi temboard-agent@PGMP01A.service\r\npostgres@host01:\/etc\/systemd\/system\/multi-user.target.wants\/ &#x5B;PGMP01A] cat temboard-agent@PGMP01A.service\r\n&#x5B;Unit]\r\nDescription=PostgreSQL Remote Control Agent %I\r\nAfter=network.target postgresql@%i.service\r\nAssertPathExists=\/etc\/temboard-agent\/%I\/temboard-agent.conf\r\n\r\n&#x5B;Service]\r\nType=simple\r\nUser=postgres\r\nGroup=postgres\r\nEnvironment=&quot;SYSTEMD=1&quot;\r\nEnvironment=&quot;LD_LIBRARY_PATH=\/app\/lib\/postgres\/pgproduct\/pg-18.1\/lib&quot;\r\nExecStart=\/usr\/bin\/temboard-agent -c \/etc\/temboard-agent\/%I\/temboard-agent.conf serve\r\n# Increase OOM Score to ensure agent is killed before Postgres.\r\nOOMScoreAdjust=15\r\n\r\n&#x5B;Install]\r\nWantedBy=multi-user.target\r\n<\/pre>\n<p>Remove the deprecated agent administration plugin.<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\n$ cd \/etc\/temboard-agent\/PGMP01A\/\r\n$ cp -p temboard-agent.conf temboard-agent.conf.20251209a\r\n<\/pre>\n<p>Remove the following block.<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\n&#x5B;administration]\r\n# Path to pg_ctl. %s is either start, restart or reload.\r\npg_ctl = \/app\/lib\/postgres\/pgproduct\/pg-18.1\/bin\/pg_ctl %s -D \/app\/lib\/postgres\/pgdata\/18\/PGMP01A\r\n<\/pre>\n<p>To activate the new systemd files, you got to reload the systemd daemon.<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\n$ sudo systemctl reset-failed\r\n$ sudo systemctl daemon-reload\r\n$\r\n<\/pre>\n<p>Check the rpm packages.<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\n$ rpm -qa | grep temboard\r\ntemboard-10.0.0-1.el9.x86_64\r\ntemboard-agent-10.0.0-1.el9.noarch\r\n<\/pre>\n<p>Now we can start the services.<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\n$ sudo systemctl start temboard.service\r\n$ sudo systemctl start temboard-agent@PGMP01A.service\r\n<\/pre>\n<p>Check if everything is running as expected.<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\n$ sudo systemctl status temboard.service\r\n\u25cf temboard.service - temBoard Server\r\nLoaded: loaded (\/etc\/systemd\/system\/temboard.service; disabled; preset: disabled)\r\nDrop-In: \/etc\/systemd\/system\/temboard.service.d\r\n\u2514\u2500override.conf\r\nActive: active (running) since Tue 2025-12-09 08:53:30 CET; 15s ago\r\nMain PID: 181243 (temboard)\r\nTasks: 30 (limit: 306180)\r\nMemory: 651.1M\r\nCPU: 6.465s\r\nCGroup: \/system.slice\/temboard.service\r\n\u251c\u2500181243 &quot;temboard: web&quot;\r\n\u251c\u2500181262 &quot;temboard: scheduler&quot;\r\n\u251c\u2500181263 &quot;temboard: worker pool&quot;\r\n\u251c\u2500181278 &quot;temboard: task temboardui.plugins.monitoring.aggregate_data_worker&quot;\r\n\u251c\u2500181279 &quot;temboard: task temboardui.plugins.monitoring.history_tables_worker&quot;\r\n\u251c\u2500181281 &quot;temboard: task temboardui.plugins.monitoring.purge_data_worker&quot;\r\n\u251c\u2500181285 &quot;temboard: task temboardui.plugins.statements.pull_data_worker&quot;\r\n\u251c\u2500181287 &quot;temboard: task temboardui.plugins.statements.statements_purge_worker&quot;\r\n\u251c\u2500181308 &quot;temboard: task temboardui.plugins.monitoring.collector_batch&quot;\r\n\u251c\u2500181309 &quot;temboard: task temboardui.plugins.monitoring.collector_batch&quot;\r\n\u251c\u2500181312 &quot;temboard: task temboardui.plugins.monitoring.collector_batch&quot;\r\n\u251c\u2500181314 &quot;temboard: task temboardui.plugins.monitoring.collector_batch&quot;\r\n\u251c\u2500181316 &quot;temboard: task temboardui.plugins.monitoring.collector_batch&quot;\r\n\u251c\u2500181318 &quot;temboard: task temboardui.plugins.monitoring.collector_batch&quot;\r\n\u251c\u2500181319 &quot;temboard: task temboardui.plugins.monitoring.collector_batch&quot;\r\n\u251c\u2500181323 &quot;temboard: task temboardui.plugins.monitoring.collector_batch&quot;\r\n\u251c\u2500181324 &quot;temboard: task temboardui.plugins.monitoring.collector_batch&quot;\r\n\u251c\u2500181325 &quot;temboard: task temboardui.plugins.monitoring.collector_batch&quot;\r\n\u251c\u2500181327 &quot;temboard: task temboardui.plugins.monitoring.collector_batch&quot;\r\n\u251c\u2500181329 &quot;temboard: task temboardui.plugins.monitoring.collector_batch&quot;\r\n\u251c\u2500181331 &quot;temboard: task temboardui.plugins.monitoring.collector_batch&quot;\r\n\u251c\u2500181332 &quot;temboard: task temboardui.plugins.monitoring.collector_batch&quot;\r\n\u251c\u2500181333 &quot;temboard: task temboardui.plugins.monitoring.collector_batch&quot;\r\n\u251c\u2500181334 &quot;temboard: task temboardui.plugins.monitoring.collector_batch&quot;\r\n\u251c\u2500181336 &quot;temboard: task temboardui.plugins.monitoring.collector_batch&quot;\r\n\u251c\u2500181340 &quot;temboard: task temboardui.plugins.monitoring.collector_batch&quot;\r\n\u251c\u2500181342 &quot;temboard: task temboardui.plugins.monitoring.collector_batch&quot;\r\n\u2514\u2500181345 &quot;temboard: task temboardui.plugins.monitoring.collector_batch&quot;\r\n\r\nDec 09 08:53:30 host01 systemd&#x5B;1]: Started temBoard Server.\r\nDec 09 08:53:31 host01 temboard&#x5B;181243]: INFO: app: Starting temboard. version=10.0.0\r\nDec 09 08:53:31 host01 temboard&#x5B;181243]: INFO: app: Using config file \/etc\/temboard\/temboard.conf.\r\n<\/pre>\n<p>Check the agent as well.<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\n$ sudo systemctl status temboard-agent@PGMP01A.service\r\n\u25cf temboard-agent@PGMP01A.service - PostgreSQL Remote Control Agent PGMP01A\r\nLoaded: loaded (\/usr\/lib\/systemd\/system\/temboard-agent@.service; enabled; preset: disabled)\r\nActive: active (running) since Tue 2025-12-09 08:53:37 CET; 41s ago\r\nMain PID: 181451 (temboard-agent)\r\nTasks: 6 (limit: 306180)\r\nMemory: 33.4M\r\nCPU: 548ms\r\nCGroup: \/system.slice\/system-temboard\\x2dagent.slice\/temboard-agent@PGMP01A.service\r\n\u251c\u2500181451 &quot;temboard-agent: PGMP01A: web&quot;\r\n\u251c\u2500181453 &quot;temboard-agent: PGMP01A: scheduler&quot;\r\n\u251c\u2500181454 &quot;temboard-agent: PGMP01A: worker pool&quot;\r\n\u2514\u2500181467 &quot;temboard-agent: PGMP01A: task temboardagent.plugins.dashboard.dashboard_collector_batch_worker&quot;\r\n\r\nDec 09 08:53:37 host01 systemd&#x5B;1]: Started PostgreSQL Remote Control Agent PGMP01A.\r\nDec 09 08:53:37 host01 temboard-agent&#x5B;181451]: INFO: app: Starting temboard-agent. version=10.0.0\r\nDec 09 08:53:37 host01 temboard-agent&#x5B;181451]: INFO: app: Using config file \/etc\/temboard-agent\/PGMP01A\/temboard-agent.conf.\r\nDec 09 08:53:37 host01 temboard-agent&#x5B;181451]: WARNING: agent: Deprecated: agent plugin administration is ignored\r\n<\/pre>\n<p>Check if the new temboard ui and temboard agent version is correct.<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\n$ temboard --version\r\nINFO: app: Starting temboard. version=10.0.0\r\ntemBoard 10.0.0 (\/usr\/bin\/temboard)\r\nSystem Red Hat Enterprise Linux 9.6 (Plow)\r\nPython 3.9.21 (\/usr\/bin\/python3.9)\r\ncryptography 36.0.1\r\nTornado 6.4.2\r\nFlask 3.1.2\r\nlibpq 17.5\r\npsycopg2 2.8.6 (dt dec pq3 ext lo64)\r\nSQLAlchemy 1.4.54\r\n<\/pre>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\n$ temboard-agent --version\r\nINFO: app: Starting temboard-agent. version=10.0.0\r\ntemBoard agent 10.0.0 (\/usr\/bin\/temboard-agent)\r\nSystem Red Hat Enterprise Linux 9.6 (Plow)\r\nPython 3.9.21 (\/usr\/bin\/python3.9)\r\nbottle 0.13.4\r\ncryptography 36.0.1\r\nlibpq 17.5\r\npsycopg2 2.8.6 (dt dec pq3 ext lo64)\r\n<\/pre>\n<p>Now, everything is fine and we are ready to go.<\/p>\n<h3>Conclusion<\/h3>\n<p>That new release from Dalibo included mainly PostgreSQL 18 and Red Hat 10 compatibility and a few bug fixes. However, this is still an important release for all people that are running PostgreSQL 18. I will write a few blog posts about the cool stuff in temBoard version 10.0.0 very soon. Have fun with the new version.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Dalibo released on the 08th of December temBoard version 10.0.0. The new release does not come with\u00a0 a lot of new features, however, it is still worth upgrading, because temBoard 10.0.0 supports now PostgreSQL 18 and Red Hat 10. The top changes are Fix register-instance CLI Fix running daemonized Raise proper error on unknown environment [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","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":"0","ocean_second_sidebar":"0","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":"0","ocean_custom_header_template":"0","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":"0","ocean_menu_typo_font_family":"0","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":"0","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,7],"tags":[17,21,24],"class_list":["post-476","post","type-post","status-publish","format-standard","hentry","category-postgresql","category-red-hat","tag-monitoring","tag-postgresql","tag-temboard","entry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>PostgreSQL: How to Upgrade temBoard from 9.0.1 to 10.0.0 - 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=476\" \/>\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 from 9.0.1 to 10.0.0 - ptdb - Platinum DB\" \/>\n<meta property=\"og:description\" content=\"Dalibo released on the 08th of December temBoard version 10.0.0. The new release does not come with\u00a0 a lot of new features, however, it is still worth upgrading, because temBoard 10.0.0 supports now PostgreSQL 18 and Red Hat 10. The top changes are Fix register-instance CLI Fix running daemonized Raise proper error on unknown environment [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ptdb.ch\/?p=476\" \/>\n<meta property=\"og:site_name\" content=\"ptdb - Platinum DB\" \/>\n<meta property=\"article:published_time\" content=\"2025-12-10T09:10:33+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-12-10T12:42:59+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=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/ptdb.ch\\\/?p=476#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/ptdb.ch\\\/?p=476\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/ptdb.ch\\\/#\\\/schema\\\/person\\\/0b7baf52d23e71d85e1c95442306090b\"},\"headline\":\"PostgreSQL: How to Upgrade temBoard from 9.0.1 to 10.0.0\",\"datePublished\":\"2025-12-10T09:10:33+00:00\",\"dateModified\":\"2025-12-10T12:42:59+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/ptdb.ch\\\/?p=476\"},\"wordCount\":1874,\"keywords\":[\"Monitoring\",\"PostgreSQL\",\"temBoard\"],\"articleSection\":[\"PostgreSQL\",\"Red Hat\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/ptdb.ch\\\/?p=476\",\"url\":\"https:\\\/\\\/ptdb.ch\\\/?p=476\",\"name\":\"PostgreSQL: How to Upgrade temBoard from 9.0.1 to 10.0.0 - ptdb - Platinum DB\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/ptdb.ch\\\/#website\"},\"datePublished\":\"2025-12-10T09:10:33+00:00\",\"dateModified\":\"2025-12-10T12:42:59+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/ptdb.ch\\\/#\\\/schema\\\/person\\\/0b7baf52d23e71d85e1c95442306090b\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/ptdb.ch\\\/?p=476#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/ptdb.ch\\\/?p=476\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/ptdb.ch\\\/?p=476#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/ptdb.ch\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PostgreSQL: How to Upgrade temBoard from 9.0.1 to 10.0.0\"}]},{\"@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:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1a3dffc48c5f6bae0b88a9f0b2a986d48d322673fbc2880c5abbfab96e45da8a?s=96&d=mm&r=g\",\"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 from 9.0.1 to 10.0.0 - 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=476","og_locale":"en_US","og_type":"article","og_title":"PostgreSQL: How to Upgrade temBoard from 9.0.1 to 10.0.0 - ptdb - Platinum DB","og_description":"Dalibo released on the 08th of December temBoard version 10.0.0. The new release does not come with\u00a0 a lot of new features, however, it is still worth upgrading, because temBoard 10.0.0 supports now PostgreSQL 18 and Red Hat 10. The top changes are Fix register-instance CLI Fix running daemonized Raise proper error on unknown environment [&hellip;]","og_url":"https:\/\/ptdb.ch\/?p=476","og_site_name":"ptdb - Platinum DB","article_published_time":"2025-12-10T09:10:33+00:00","article_modified_time":"2025-12-10T12:42:59+00:00","author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/ptdb.ch\/?p=476#article","isPartOf":{"@id":"https:\/\/ptdb.ch\/?p=476"},"author":{"name":"admin","@id":"https:\/\/ptdb.ch\/#\/schema\/person\/0b7baf52d23e71d85e1c95442306090b"},"headline":"PostgreSQL: How to Upgrade temBoard from 9.0.1 to 10.0.0","datePublished":"2025-12-10T09:10:33+00:00","dateModified":"2025-12-10T12:42:59+00:00","mainEntityOfPage":{"@id":"https:\/\/ptdb.ch\/?p=476"},"wordCount":1874,"keywords":["Monitoring","PostgreSQL","temBoard"],"articleSection":["PostgreSQL","Red Hat"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/ptdb.ch\/?p=476","url":"https:\/\/ptdb.ch\/?p=476","name":"PostgreSQL: How to Upgrade temBoard from 9.0.1 to 10.0.0 - ptdb - Platinum DB","isPartOf":{"@id":"https:\/\/ptdb.ch\/#website"},"datePublished":"2025-12-10T09:10:33+00:00","dateModified":"2025-12-10T12:42:59+00:00","author":{"@id":"https:\/\/ptdb.ch\/#\/schema\/person\/0b7baf52d23e71d85e1c95442306090b"},"breadcrumb":{"@id":"https:\/\/ptdb.ch\/?p=476#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ptdb.ch\/?p=476"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/ptdb.ch\/?p=476#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/ptdb.ch\/"},{"@type":"ListItem","position":2,"name":"PostgreSQL: How to Upgrade temBoard from 9.0.1 to 10.0.0"}]},{"@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:\/\/secure.gravatar.com\/avatar\/1a3dffc48c5f6bae0b88a9f0b2a986d48d322673fbc2880c5abbfab96e45da8a?s=96&d=mm&r=g","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\/476","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=476"}],"version-history":[{"count":9,"href":"https:\/\/ptdb.ch\/index.php?rest_route=\/wp\/v2\/posts\/476\/revisions"}],"predecessor-version":[{"id":486,"href":"https:\/\/ptdb.ch\/index.php?rest_route=\/wp\/v2\/posts\/476\/revisions\/486"}],"wp:attachment":[{"href":"https:\/\/ptdb.ch\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=476"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ptdb.ch\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=476"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ptdb.ch\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=476"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}