{"id":305,"date":"2022-01-03T10:10:03","date_gmt":"2022-01-03T09:10:03","guid":{"rendered":"https:\/\/ptdb.ch\/?p=305"},"modified":"2022-01-03T10:10:03","modified_gmt":"2022-01-03T09:10:03","slug":"postgresql-temboard-version-7-9-released-with-support-for-postgresql-14","status":"publish","type":"post","link":"https:\/\/ptdb.ch\/?p=305","title":{"rendered":"PostgreSQL: temBoard version 7.9 released with support for PostgreSQL 14"},"content":{"rendered":"<p>Dalibo released temBoard version 7.9 on the 27.12.2021, which is quite an important release because it supports now officially PostgreSQL version 14. Besides that, a lot of bugfixes went into this release as well. The most important changes in release 7.9 can be found on the temBoards documentation page.<\/p>\n<p><a href=\"https:\/\/temboard.readthedocs.io\/en\/v7\/CHANGELOG\/\">https:\/\/temboard.readthedocs.io\/en\/v7\/CHANGELOG\/<\/a><\/p>\n<p>[7.9]<\/p>\n<ul>\n<li>Support PostgreSQL 14<\/li>\n<li>Fix deadlock in monitoring<\/li>\n<li>Fix UI glitches<\/li>\n<li>Restructured documentation<\/li>\n<li>Improved logging messages<\/li>\n<li>Dropped Debian Jessie support<\/li>\n<li>agent: Monitor only local filesystem size<\/li>\n<li>agent: Set umask 027 in auto_configure.sh<\/li>\n<li>agent: Details components version in temboard-agent &#8211;version output<\/li>\n<li>agent: Fix sysv init script shipped on systemd by debian package<\/li>\n<\/ul>\n<p>Some other very important fixes, which made it into this release are the following fixes:<\/p>\n<p>Issue: If too many instance groups are configured, you can&#8217;t edit an instance and select one of the last one&#8217;s<br \/>\n<a href=\"https:\/\/github.com\/dalibo\/temboard\/issues\/925\">https:\/\/github.com\/dalibo\/temboard\/issues\/925<\/a><\/p>\n<p>Issue: Locking Issues<br \/>\n<a href=\"https:\/\/github.com\/dalibo\/temboard\/issues\/931\">https:\/\/github.com\/dalibo\/temboard\/issues\/931<\/a><\/p>\n<p>Another thing that you might notice very quickly, is that the number of rollbacked transactions on the repository DB will drop considerably. In my case the rollbacked transactions dropped by 60%.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-316\" src=\"https:\/\/ptdb.ch\/wp-content\/uploads\/2022\/01\/Rollbacked-Transactions-1.jpg\" alt=\"Rollbacked Transactions\" width=\"1401\" height=\"381\" \/><\/p>\n<p>In case you are interested in the complete list of changes between version 7.8 and 7.9 I would recommended to use the Github compare.<\/p>\n<p><a href=\"https:\/\/github.com\/dalibo\/temboard\/compare\/7.8...7.9\">https:\/\/github.com\/dalibo\/temboard\/compare\/7.8&#8230;7.9<\/a><\/p>\n<p>The latest version for Red Hat\/CentOS 7.x can be found here: <a href=\"https:\/\/yum.dalibo.org\/labs\/CentOS7-x86_64\/\">https:\/\/yum.dalibo.org\/labs\/CentOS7-x86_64\/<\/a><\/p>\n<p>temboard-7.9-1.el7.noarch.rpm<br \/>\ntemboard-agent-7.9-1.el7.noarch.rpm<\/p>\n<p>Fortunately, the upgrade from 7.8 to 7.9 is quite simply. In general, you need only to stop the service, upgrade the rpm package, run the temboard-migratedb script and start the service again.<\/p>\n<p>Stop the temBoard server and agent and start with a clean log file.<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\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\nrunning\n<\/pre>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n$ cd \/var\/log\/temboard\/\n$ sudo mv temboard.log temboard.log.before_upgrade_to_7.9\n$\n<\/pre>\n<p>Upgrade the temBoard (UI) from 7.8 to 7.9.<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n$ sudo yum localupdate temboard-7.9-1.el7.noarch.rpm\nLoaded plugins: enabled_repos_upload, langpacks, package_upload, product-id, search-disabled-repos, subscription-manager\nExamining temboard-7.9-1.el7.noarch.rpm: temboard-7.9-1.el7.noarch\nMarking temboard-7.9-1.el7.noarch.rpm as an update to temboard-7.8-1.el7.noarch\nResolving Dependencies\n-- Running transaction check\n--- Package temboard.noarch 0:7.8-1.el7 will be updated\n--- Package temboard.noarch 0:7.9-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.9-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==============================================================================================================================================================\nPackage Arch Version Repository Size\n==============================================================================================================================================================\nUpdating:\ntemboard noarch 7.9-1.el7 \/temboard-7.9-1.el7.noarch 3.9 M\n\nTransaction Summary\n==============================================================================================================================================================\nUpgrade 1 Package\n\nTotal size: 3.9 M\nIs this ok &#x5B;y\/d\/N]: y\nDownloading packages:\nRunning transaction check\nRunning transaction test\nTransaction test succeeded\nRunning transaction\nUpdating : temboard-7.9-1.el7.noarch 1\/2\nCleanup : temboard-7.8-1.el7.noarch 2\/2\nUploading Package Profile\nLoaded plugins: langpacks, product-id, subscription-manager\nVerifying : temboard-7.9-1.el7.noarch 1\/2\nVerifying : temboard-7.8-1.el7.noarch 2\/2\n\nUpdated:\ntemboard.noarch 0:7.9-1.el7\n\nComplete!\nUploading Enabled Repositories Report\nLoaded plugins: langpacks, product-id, subscription-manager\n\n<\/pre>\n<p>Check if the new version is correct.<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n$ temboard --version\nINFO: Starting temboard 7.9.\ntemBoard 7.9\nSystem Red Hat Enterprise Linux Server 7.9 (Maipo)\nPython 2.7.5 (\/usr\/bin\/python)\npsycopg2 2.5.1 (dt dec pq3 ext)\nTornado 4.2.1\nSQLAlchemy 0.9.8\nalembic 0.8.3\n<\/pre>\n<p>Upgrade the temBoard agent.<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n$ sudo yum localupdate temboard-agent-7.9-1.el7.noarch.rpm\nLoaded plugins: enabled_repos_upload, langpacks, package_upload, product-id, search-disabled-repos, subscription-manager\nExamining temboard-agent-7.9-1.el7.noarch.rpm: temboard-agent-7.9-1.el7.noarch\nMarking temboard-agent-7.9-1.el7.noarch.rpm as an update to temboard-agent-7.8-1.el7.noarch\nResolving Dependencies\n-- Running transaction check\n--- Package temboard-agent.noarch 0:7.8-1.el7 will be updated\n--- Package temboard-agent.noarch 0:7.9-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.9-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==============================================================================================================================================================\nPackage Arch Version Repository Size\n==============================================================================================================================================================\nUpdating:\ntemboard-agent noarch 7.9-1.el7 \/temboard-agent-7.9-1.el7.noarch 957 k\n\nTransaction Summary\n==============================================================================================================================================================\nUpgrade 1 Package\n\nTotal size: 957 k\nIs this ok &#x5B;y\/d\/N]: y\nDownloading packages:\nRunning transaction check\nRunning transaction test\nTransaction test succeeded\nRunning transaction\nUpdating : temboard-agent-7.9-1.el7.noarch 1\/2\nNo units found for temboard-agent.\nToo few arguments.\nCleanup : temboard-agent-7.8-1.el7.noarch 2\/2\nUploading Package Profile\nLoaded plugins: langpacks, product-id, subscription-manager\nVerifying : temboard-agent-7.9-1.el7.noarch 1\/2\nVerifying : temboard-agent-7.8-1.el7.noarch 2\/2\n\nUpdated:\ntemboard-agent.noarch 0:7.9-1.el7\n\nComplete!\nUploading Enabled Repositories Report\nLoaded plugins: langpacks, product-id, subscription-manager\n\n<\/pre>\n<p>Check if the new agent version is correct.<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n$ temboard-agent --version\nINFO: Starting temboard-agent 7.9.\ntemBoard agent 7.9\nSystem Red Hat Enterprise Linux Server 7.9 (Maipo)\nPython 3.6.8 (\/usr\/bin\/python3)\npsycopg2 2.7.7 (dt dec pq3 ext) libpq 9.2.24\n<\/pre>\n<p>Now run the database upgrade as the temboard OS user.<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n$ su - temboard\nPassword:\nLast login: Mon Jul 5 10:45:32 CEST 2021 on pts\/1\n\n$ temboard-migratedb upgrade\nINFO: Starting temboard-migratedb 7.9.\nINFO: Found config file \/etc\/temboard\/temboard.conf.\nINFO: Context impl PostgresqlImpl.\nINFO: Will assume transactional DDL.\nINFO: Running upgrade 67f52879da15 -&amp;gt; 55ab971bde17, metrics-archive-deadlock\nINFO: Database up to date.\n\n$\n<\/pre>\n<p>You might will notice that a few functions have been replaced.<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n2022-01-03 06:35:05.378 CET &#x5B;6464] LOG: statement: CREATE SCHEMA IF NOT EXISTS &quot;application&quot;;\n2022-01-03 06:35:05.379 CET &#x5B;6464] LOG: statement: ALTER TABLE public.alembic_version SET SCHEMA &quot;application&quot;;\n2022-01-03 06:35:05.379 CET &#x5B;6464] ERROR: relation &quot;public.alembic_version&quot; does not exist\n2022-01-03 06:35:05.379 CET &#x5B;6464] STATEMENT: ALTER TABLE public.alembic_version SET SCHEMA &quot;application&quot;;\n2022-01-03 06:35:05.386 CET &#x5B;6464] LOG: statement: SET search_path TO monitoring, public;\n\nCREATE OR REPLACE FUNCTION archive_current_metrics(table_name TEXT, record_type TEXT, query TEXT) RETURNS TABLE(tblname TEXT, nb_rows INTEGER)\nLANGUAGE plpgsql\nAS $$\nDECLARE\nv_table_current TEXT;\nv_table_history TEXT;\nv_query TEXT;\ni INTEGER;\nBEGIN\nv_table_current := table_name || '_current';\nv_table_history := table_name || '_history';\n-- Lock _current table to prevent concurrent updates\nEXECUTE 'LOCK TABLE ' || v_table_current || ' IN SHARE MODE NOWAIT';\nv_query := replace(query, '#history_table#', v_table_history);\nv_query := replace(v_query, '#current_table#', v_table_current);\nv_query := replace(v_query, '#record_type#', record_type);\n-- Move data into _history table\nEXECUTE v_query;\nGET DIAGNOSTICS i = ROW_COUNT;\n-- Truncate _current table\nEXECUTE 'TRUNCATE '||v_table_current;\n-- Return each history table name and the number of rows inserted\nRETURN QUERY SELECT v_table_history, i;\nEND;\n$$;\n\nDROP FUNCTION IF EXISTS history_tables();\n\nCREATE OR REPLACE FUNCTION aggregate_data_single(table_name TEXT, record_type TEXT, query TEXT) RETURNS TABLE(tblname TEXT, nb_rows INTEGER)\nLANGUAGE plpgsql\nAS $$\nDECLARE\nt JSON;\nv_agg_periods TEXT&#x5B;] := array&#x5B;'30m', '6h'];\nv_agg_table TEXT;\ni_period TEXT;\nv_query TEXT;\ni INTEGER;\nBEGIN\n-- Build and run 'aggregate' query for type of metric.\nFOREACH i_period IN ARRAY v_agg_periods LOOP\nv_agg_table := table_name || '_' || i_period || '_current';\nv_query := replace(query, '#agg_table#', v_agg_table);\nv_query := replace(v_query, '#interval#', i_period);\nv_query := replace(v_query, '#record_type#', record_type);\nv_query := replace(v_query, '#name#', table_name);\nEXECUTE v_query;\nGET DIAGNOSTICS i = ROW_COUNT;\nRETURN QUERY SELECT v_agg_table, i;\nEND LOOP;\nEND;\n$$;\n\nDROP FUNCTION IF EXISTS aggregate_data();\n<\/pre>\n<p>I 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<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n$ cd \/etc\/systemd\/system\/multi-user.target.wants\/\n$ sudo vi temboard.service\n$ cat temboard.service\n&#x5B;Unit]\nDescription=temBoard Web UI\nAfter=network.target\n \n&#x5B;Service]\nType=simple\nUser=temboard\nGroup=temboard\nExecStart=\/usr\/bin\/env SYSTEMD=1 temboard -c \/etc\/temboard\/temboard.conf\nNice=-19\n \n&#x5B;Install]\nWantedBy=multi-user.target\n<\/pre>\n<p>Startup the temBoard UI and the agent.<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n$ sudo systemctl daemon-reload\n$ sudo systemctl start temboard.service\n$ sudo systemctl start temboard-agent@12-pg58888.service\n<\/pre>\n<p>Check if the services are running correctly.<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n$ sudo systemctl status temboard.service\ntemboard.service - temBoard Web UI\nLoaded: loaded (\/usr\/lib\/systemd\/system\/temboard.service; enabled; vendor preset: disabled)\nDrop-In: \/etc\/systemd\/system\/temboard.service.d\noverride.conf\nActive: active (running) since Mon 2022-01-03 06:38:10 CET; 23s ago\nMain PID: 9641 (temboard)\nCGroup: \/system.slice\/temboard.service\n 9641 temboard: web\n 9648 temboard: worker pool\n 9649 temboard: scheduler\n 9660 temboard: worker pool\n 9663 temboard: worker pool\n 9840 temboard: worker pool\n10052 temboard: worker pool\n10151 temboard: worker pool\n10154 temboard: worker pool\n...\n...\n<\/pre>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n$ sudo systemctl status temboard-agent@12-pg58888.service\n temboard-agent@12-pg58888.service - PostgreSQL Remote Control Agent 12\/pg58888\nLoaded: loaded (\/usr\/lib\/systemd\/system\/temboard-agent@.service; enabled; vendor preset: disabled)\nActive: active (running) since Mon 2022-01-03 06:38:21 CET; 54s ago\nMain PID: 9885 (temboard-agent)\nCGroup: \/system.slice\/system-temboard\\x2dagent.slice\/temboard-agent@12-pg58888.service\n9885 temboard-agent: 12\/pg58888: main process\n9896 temboard-agent: 12\/pg58888: worker pool\n9897 temboard-agent: 12\/pg58888: scheduler\n\nJan 03 06:39:10 host01 env&#x5B;9885]: Running host probe loadavg.\nJan 03 06:39:10 host01 env&#x5B;9885]: Running instance level probe wal_files.\nJan 03 06:39:10 host01 env&#x5B;9885]: Running instance level probe replication_lag.\nJan 03 06:39:10 host01 env&#x5B;9885]: Running instance level probe temp_files_size_delta.\nJan 03 06:39:10 host01 env&#x5B;9885]: Running instance level probe replication_connection.\nJan 03 06:39:10 host01 env&#x5B;9885]: Running database level probe heap_bloat.\nJan 03 06:39:10 host01 env&#x5B;9885]: Running database level probe btree_bloat.\nJan 03 06:39:10 host01 env&#x5B;9885]: Finished probes run.\nJan 03 06:39:10 host01 env&#x5B;9885]: Add data to metrics table.\nJan 03 06:39:10 host01 env&#x5B;9885]: Collect done.\n<\/pre>\n<p>Ready. \ud83d\ude42<\/p>\n<h3>Conclusion<\/h3>\n<p>The temBoard 7.9 is very important new release which comes with PostgreSQL 14 support and a lot of important bug fixes.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Dalibo released temBoard version 7.9 on the 27.12.2021, which is quite an important release because it supports now officially PostgreSQL version 14. Besides that, a lot of bugfixes went into this release as well. The most important changes in release 7.9 can be found on the temBoards documentation page. https:\/\/temboard.readthedocs.io\/en\/v7\/CHANGELOG\/ [7.9] Support PostgreSQL 14 Fix [&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":"","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":[17,21,24],"class_list":["post-305","post","type-post","status-publish","format-standard","hentry","category-postgresql","tag-monitoring","tag-postgresql","tag-temboard","entry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>PostgreSQL: temBoard version 7.9 released with support for PostgreSQL 14 - 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=305\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PostgreSQL: temBoard version 7.9 released with support for PostgreSQL 14 - ptdb - Platinum DB\" \/>\n<meta property=\"og:description\" content=\"Dalibo released temBoard version 7.9 on the 27.12.2021, which is quite an important release because it supports now officially PostgreSQL version 14. Besides that, a lot of bugfixes went into this release as well. The most important changes in release 7.9 can be found on the temBoards documentation page. https:\/\/temboard.readthedocs.io\/en\/v7\/CHANGELOG\/ [7.9] Support PostgreSQL 14 Fix [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ptdb.ch\/?p=305\" \/>\n<meta property=\"og:site_name\" content=\"ptdb - Platinum DB\" \/>\n<meta property=\"article:published_time\" content=\"2022-01-03T09:10:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/ptdb.ch\/wp-content\/uploads\/2022\/01\/Rollbacked-Transactions-1.jpg\" \/>\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=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ptdb.ch\/?p=305\",\"url\":\"https:\/\/ptdb.ch\/?p=305\",\"name\":\"PostgreSQL: temBoard version 7.9 released with support for PostgreSQL 14 - ptdb - Platinum DB\",\"isPartOf\":{\"@id\":\"https:\/\/ptdb.ch\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/ptdb.ch\/?p=305#primaryimage\"},\"image\":{\"@id\":\"https:\/\/ptdb.ch\/?p=305#primaryimage\"},\"thumbnailUrl\":\"https:\/\/ptdb.ch\/wp-content\/uploads\/2022\/01\/Rollbacked-Transactions-1.jpg\",\"datePublished\":\"2022-01-03T09:10:03+00:00\",\"author\":{\"@id\":\"https:\/\/ptdb.ch\/#\/schema\/person\/0b7baf52d23e71d85e1c95442306090b\"},\"breadcrumb\":{\"@id\":\"https:\/\/ptdb.ch\/?p=305#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ptdb.ch\/?p=305\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/ptdb.ch\/?p=305#primaryimage\",\"url\":\"\",\"contentUrl\":\"\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ptdb.ch\/?p=305#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/ptdb.ch\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PostgreSQL: temBoard version 7.9 released with support for PostgreSQL 14\"}]},{\"@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: temBoard version 7.9 released with support for PostgreSQL 14 - 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=305","og_locale":"en_US","og_type":"article","og_title":"PostgreSQL: temBoard version 7.9 released with support for PostgreSQL 14 - ptdb - Platinum DB","og_description":"Dalibo released temBoard version 7.9 on the 27.12.2021, which is quite an important release because it supports now officially PostgreSQL version 14. Besides that, a lot of bugfixes went into this release as well. The most important changes in release 7.9 can be found on the temBoards documentation page. https:\/\/temboard.readthedocs.io\/en\/v7\/CHANGELOG\/ [7.9] Support PostgreSQL 14 Fix [&hellip;]","og_url":"https:\/\/ptdb.ch\/?p=305","og_site_name":"ptdb - Platinum DB","article_published_time":"2022-01-03T09:10:03+00:00","og_image":[{"url":"https:\/\/ptdb.ch\/wp-content\/uploads\/2022\/01\/Rollbacked-Transactions-1.jpg","type":"","width":"","height":""}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/ptdb.ch\/?p=305","url":"https:\/\/ptdb.ch\/?p=305","name":"PostgreSQL: temBoard version 7.9 released with support for PostgreSQL 14 - ptdb - Platinum DB","isPartOf":{"@id":"https:\/\/ptdb.ch\/#website"},"primaryImageOfPage":{"@id":"https:\/\/ptdb.ch\/?p=305#primaryimage"},"image":{"@id":"https:\/\/ptdb.ch\/?p=305#primaryimage"},"thumbnailUrl":"https:\/\/ptdb.ch\/wp-content\/uploads\/2022\/01\/Rollbacked-Transactions-1.jpg","datePublished":"2022-01-03T09:10:03+00:00","author":{"@id":"https:\/\/ptdb.ch\/#\/schema\/person\/0b7baf52d23e71d85e1c95442306090b"},"breadcrumb":{"@id":"https:\/\/ptdb.ch\/?p=305#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ptdb.ch\/?p=305"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/ptdb.ch\/?p=305#primaryimage","url":"","contentUrl":""},{"@type":"BreadcrumbList","@id":"https:\/\/ptdb.ch\/?p=305#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/ptdb.ch\/"},{"@type":"ListItem","position":2,"name":"PostgreSQL: temBoard version 7.9 released with support for PostgreSQL 14"}]},{"@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\/305","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=305"}],"version-history":[{"count":0,"href":"https:\/\/ptdb.ch\/index.php?rest_route=\/wp\/v2\/posts\/305\/revisions"}],"wp:attachment":[{"href":"https:\/\/ptdb.ch\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=305"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ptdb.ch\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=305"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ptdb.ch\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=305"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}