{"id":263,"date":"2021-06-01T15:44:42","date_gmt":"2021-06-01T13:44:42","guid":{"rendered":"https:\/\/ptdb.ch\/?p=263"},"modified":"2021-06-01T15:44:42","modified_gmt":"2021-06-01T13:44:42","slug":"postgresql-how-to-upgrade-temboard-version-7-6-to-7-7","status":"publish","type":"post","link":"https:\/\/ptdb.ch\/?p=263","title":{"rendered":"PostgreSQL: How to Upgrade temBoard Version 7.6 to 7.7"},"content":{"rendered":"

Dalibo released today a new temBoard bugfixing release with some minor adjustments. The main scope of this release, is to make temBoard Python 3 and CentOS 8 ready. You might will notice the that a package called python future will be installed along with temBoard 7.7. (python2-future-0.18.2-2.el7.noarch). Python future is the missing compatibility layer between Python 2 and Python 3. It allows you to use a single, clean Python 3.x-compatible codebase to support both Python 2 and Python 3 with minimal overhead. It case you want to learn more about the python future project, take a look a the following website: http:\/\/python-future.org\/<\/a><\/p>\n

The new verions are temBoard version 7.7 and temBoard agent version 7.7.<\/p>\n

\"\"<\/p>\n

The latest version for Red Hat\/CentOS 7.x can be found here: https:\/\/yum.dalibo.org\/labs\/CentOS7-x86_64\/<\/a><\/p>\n

temboard-7.7-1.el7.noarch.rpm
\ntemboard-agent-7.7-1.el7.noarch.rpm<\/p>\n

Fortunately, the upgrade from 7.6 to 7.7 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.7\n\n$ cd \/app\/lib\/postgres\/pgproduct\/stage\/temboard\/7\/\n$ sudo yum localupdate temboard-7.7-1.el7.noarch.rpm\n$ sudo yum localupdate temboard-agent-7.7-1.el7.noarch.rpm\n<\/pre>\n
Upgrade the temBoard (UI) from 7.6 to 7.7<\/p>\n
\n$ sudo yum localupdate temboard-7.7-1.el7.noarch.rpm\nLoaded plugins: enabled_repos_upload, langpacks, package_upload, product-id, search-disabled-repos, subscription-manager\nExamining temboard-7.7-1.el7.noarch.rpm: temboard-7.7-1.el7.noarch\nMarking temboard-7.7-1.el7.noarch.rpm as an update to temboard-7.6-1.el7.noarch\nResolving Dependencies\n--> Running transaction check\n---> Package temboard.noarch 0:7.6-1.el7 will be updated\n---> Package temboard.noarch 0:7.7-1.el7 will be an update\n--> Processing Dependency: python-future for package: temboard-7.7-1.el7.noarch\nepel\/x86_64\/metalink                                                                                                                                   |  31 kB  00:00:00\nepel                                                                                                                                                   | 4.7 kB  00:00:00\nrhel-7-server-extras-rpms                                                                                                                              | 2.0 kB  00:00:00\nrhel-7-server-optional-rpms                                                                                                                            | 2.0 kB  00:00:00\nrhel-7-server-rh-common-rpms                                                                                                                           | 2.1 kB  00:00:00\nrhel-7-server-rpms                                                                                                                                     | 2.0 kB  00:00:00\nrhel-7-server-satellite-tools-6.8-rpms                                                                                                                 | 2.1 kB  00:00:00\nrhel-7-server-supplementary-rpms                                                                                                                       | 2.3 kB  00:00:00\nrhel-server-rhscl-7-rpms                                                                                                                               | 2.3 kB  00:00:00\n(1\/2): epel\/x86_64\/updateinfo                                                                                                                          | 1.0 MB  00:00:00\n(2\/2): epel\/x86_64\/primary_db                                                                                                                          | 6.9 MB  00:00:00\n--> Running transaction check\n---> Package python2-future.noarch 0:0.18.2-2.el7 will be installed\n--> Finished Dependency Resolution\n\nDependencies Resolved\n\n==============================================================================================================================================================================\n Package                                  Arch                             Version                                 Repository                                            Size\n==============================================================================================================================================================================\nUpdating:\n temboard                                 noarch                           7.7-1.el7                               \/temboard-7.7-1.el7.noarch                           3.9 M\nInstalling for dependencies:\n python2-future                           noarch                           0.18.2-2.el7                            epel                                                 806 k\n\nTransaction Summary\n==============================================================================================================================================================================\nInstall             ( 1 Dependent package)\nUpgrade  1 Package\n\nTotal size: 4.7 M\nTotal download size: 806 k\nIs this ok [y\/d\/N]: y\nDownloading packages:\npython2-future-0.18.2-2.el7.noarch.rpm                                                                                                                 | 806 kB  00:00:00\nRunning transaction check\nRunning transaction test\nTransaction test succeeded\nRunning transaction\n  Installing : python2-future-0.18.2-2.el7.noarch                                                                                                                         1\/3\n  Updating   : temboard-7.7-1.el7.noarch                                                                                                                                  2\/3\n  Cleanup    : temboard-7.6-1.el7.noarch                                                                                                                                  3\/3\nUploading Package Profile\nLoaded plugins: langpacks, product-id, subscription-manager\n  Verifying  : temboard-7.7-1.el7.noarch                                                                                                                                  1\/3\n  Verifying  : python2-future-0.18.2-2.el7.noarch                                                                                                                         2\/3\n  Verifying  : temboard-7.6-1.el7.noarch                                                                                                                                  3\/3\n\nDependency Installed:\n  python2-future.noarch 0:0.18.2-2.el7\n\nUpdated:\n  temboard.noarch 0:7.7-1.el7\n\nComplete!\nUploading Enabled Repositories Report\nLoaded plugins: langpacks, product-id, subscription-manager\n\n\n<\/pre>\n
Upgrade the temBoard agent from 7.6 to 7.7.<\/p>\n
\n\n$ sudo yum localupdate temboard-agent-7.7-1.el7.noarch.rpm\nLoaded plugins: enabled_repos_upload, langpacks, package_upload, product-id, search-disabled-repos, subscription-manager\nExamining temboard-agent-7.7-1.el7.noarch.rpm: temboard-agent-7.7-1.el7.noarch\nMarking temboard-agent-7.7-1.el7.noarch.rpm as an update to temboard-agent-7.6-1.el7.noarch\nResolving Dependencies\n--> Running transaction check\n---> Package temboard-agent.noarch 0:7.6-1.el7 will be updated\n---> Package temboard-agent.noarch 0:7.7-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.8-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.7-1.el7                            \/temboard-agent-7.7-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.7-1.el7.noarch                                                                                                                            1\/2\nNo units found for temboard-agent.\nToo few arguments.\n  Cleanup    : temboard-agent-7.6-1.el7.noarch                                                                                                                            2\/2\nUploading Package Profile\nLoaded plugins: langpacks, product-id, subscription-manager\n  Verifying  : temboard-agent-7.7-1.el7.noarch                                                                                                                            1\/2\n  Verifying  : temboard-agent-7.6-1.el7.noarch                                                                                                                            2\/2\n\nUpdated:\n  temboard-agent.noarch 0:7.7-1.el7\n\nComplete!\nUploading Enabled Repositories Report\nLoaded plugins: langpacks, product-id, subscription-manager\n\n<\/pre>\n
Now 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.7.\n INFO: Found config file \/etc\/temboard\/temboard.conf.\n INFO: Context impl PostgresqlImpl.\n INFO: Will assume transactional DDL.\n INFO: Running upgrade d2120f410bb5 -> 9fe3bfb83329, Grant privileges on statements objects\n INFO: Database up to date.\n\n<\/pre>\n
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
\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>\n
Startup 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>\n
Check if the services are running correctly.<\/p>\n
\n$ sudo systemctl status temboard.service\n\u25cf temboard.service - temBoard Web UI\n   Loaded: loaded (\/usr\/lib\/systemd\/system\/temboard.service; enabled; vendor preset: disabled)\n  Drop-In: \/etc\/systemd\/system\/temboard.service.d\n           \u2514\u2500override.conf\n   Active: active (running) since Tue 2021-06-01 14:41:46 CEST; 23s ago\n Main PID: 5334 (temboard)\n   CGroup: \/system.slice\/temboard.service\n           \u251c\u25005334 temboard: web\n           \u251c\u25005348 temboard: worker pool\n           \u251c\u25005349 temboard: scheduler\n           \u251c\u25005362 temboard: worker pool\n           \u251c\u25005917 temboard: worker pool\n           \u251c\u25005928 temboard: worker pool\n           \u251c\u25005937 temboard: worker pool\n\n\n$ sudo systemctl status temboard-agent@12-pg58888.service\n\u25cf 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 Tue 2021-06-01 14:42:55 CEST; 16s ago\n Main PID: 6971 (temboard-agent)\n   CGroup: \/system.slice\/system-temboard\\x2dagent.slice\/temboard-agent@12-pg58888.service\n           \u251c\u25006971 temboard-agent: 12\/pg58888: main process\n           \u251c\u25007006 temboard-agent: 12\/pg58888: worker pool\n           \u2514\u25007007 temboard-agent: 12\/pg58888: scheduler\n<\/pre>\n
Ready. \ud83d\ude42<\/p>\n
Conclusion<\/h3>\n
The temBoard 7.7 is a quite small bug fixing release which makes temBoard ready for Python 3 and CentOS 8 (which comes with Python 3 per default).<\/p>\n","protected":false},"excerpt":{"rendered":"
Dalibo released today a new temBoard bugfixing release with some minor adjustments. The main scope of this release, is to make temBoard Python 3 and CentOS 8 ready. You might will notice the that a package called python future will be installed along with temBoard 7.7. (python2-future-0.18.2-2.el7.noarch). Python future is the missing compatibility layer between […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","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-263","post","type-post","status-publish","format-standard","hentry","category-postgresql","tag-monitoring","tag-postgresql","tag-temboard","entry"],"yoast_head":"\nPostgreSQL: How to Upgrade temBoard Version 7.6 to 7.7 - 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=263\" \/>\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.6 to 7.7 - ptdb - Platinum DB\" \/>\n<meta property=\"og:description\" content=\"Dalibo released today a new temBoard bugfixing release with some minor adjustments. The main scope of this release, is to make temBoard Python 3 and CentOS 8 ready. You might will notice the that a package called python future will be installed along with temBoard 7.7. (python2-future-0.18.2-2.el7.noarch). Python future is the missing compatibility layer between […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ptdb.ch\/?p=263\" \/>\n<meta property=\"og:site_name\" content=\"ptdb - Platinum DB\" \/>\n<meta property=\"article:published_time\" content=\"2021-06-01T13:44:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/ptdb.ch\/wp-content\/uploads\/2021\/06\/temBoard-Release-7.7.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=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ptdb.ch\/?p=263\",\"url\":\"https:\/\/ptdb.ch\/?p=263\",\"name\":\"PostgreSQL: How to Upgrade temBoard Version 7.6 to 7.7 - ptdb - Platinum DB\",\"isPartOf\":{\"@id\":\"https:\/\/ptdb.ch\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/ptdb.ch\/?p=263#primaryimage\"},\"image\":{\"@id\":\"https:\/\/ptdb.ch\/?p=263#primaryimage\"},\"thumbnailUrl\":\"https:\/\/ptdb.ch\/wp-content\/uploads\/2021\/06\/temBoard-Release-7.7.jpg\",\"datePublished\":\"2021-06-01T13:44:42+00:00\",\"author\":{\"@id\":\"https:\/\/ptdb.ch\/#\/schema\/person\/0b7baf52d23e71d85e1c95442306090b\"},\"breadcrumb\":{\"@id\":\"https:\/\/ptdb.ch\/?p=263#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ptdb.ch\/?p=263\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/ptdb.ch\/?p=263#primaryimage\",\"url\":\"\",\"contentUrl\":\"\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ptdb.ch\/?p=263#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/ptdb.ch\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PostgreSQL: How to Upgrade temBoard Version 7.6 to 7.7\"}]},{\"@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.6 to 7.7 - 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=263","og_locale":"en_US","og_type":"article","og_title":"PostgreSQL: How to Upgrade temBoard Version 7.6 to 7.7 - ptdb - Platinum DB","og_description":"Dalibo released today a new temBoard bugfixing release with some minor adjustments. The main scope of this release, is to make temBoard Python 3 and CentOS 8 ready. You might will notice the that a package called python future will be installed along with temBoard 7.7. (python2-future-0.18.2-2.el7.noarch). Python future is the missing compatibility layer between […]","og_url":"https:\/\/ptdb.ch\/?p=263","og_site_name":"ptdb - Platinum DB","article_published_time":"2021-06-01T13:44:42+00:00","og_image":[{"url":"https:\/\/ptdb.ch\/wp-content\/uploads\/2021\/06\/temBoard-Release-7.7.jpg","type":"","width":"","height":""}],"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=263","url":"https:\/\/ptdb.ch\/?p=263","name":"PostgreSQL: How to Upgrade temBoard Version 7.6 to 7.7 - ptdb - Platinum DB","isPartOf":{"@id":"https:\/\/ptdb.ch\/#website"},"primaryImageOfPage":{"@id":"https:\/\/ptdb.ch\/?p=263#primaryimage"},"image":{"@id":"https:\/\/ptdb.ch\/?p=263#primaryimage"},"thumbnailUrl":"https:\/\/ptdb.ch\/wp-content\/uploads\/2021\/06\/temBoard-Release-7.7.jpg","datePublished":"2021-06-01T13:44:42+00:00","author":{"@id":"https:\/\/ptdb.ch\/#\/schema\/person\/0b7baf52d23e71d85e1c95442306090b"},"breadcrumb":{"@id":"https:\/\/ptdb.ch\/?p=263#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ptdb.ch\/?p=263"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/ptdb.ch\/?p=263#primaryimage","url":"","contentUrl":""},{"@type":"BreadcrumbList","@id":"https:\/\/ptdb.ch\/?p=263#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/ptdb.ch\/"},{"@type":"ListItem","position":2,"name":"PostgreSQL: How to Upgrade temBoard Version 7.6 to 7.7"}]},{"@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\/263","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=263"}],"version-history":[{"count":0,"href":"https:\/\/ptdb.ch\/index.php?rest_route=\/wp\/v2\/posts\/263\/revisions"}],"wp:attachment":[{"href":"https:\/\/ptdb.ch\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=263"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ptdb.ch\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=263"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ptdb.ch\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=263"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}