{"id":251,"date":"2021-04-14T11:41:00","date_gmt":"2021-04-14T09:41:00","guid":{"rendered":"https:\/\/ptdb.ch\/?p=251"},"modified":"2021-04-14T11:41:00","modified_gmt":"2021-04-14T09:41:00","slug":"postgresql-temboard-workaround-for-the-error-select-from-history_tables","status":"publish","type":"post","link":"https:\/\/ptdb.ch\/?p=251","title":{"rendered":"PostgreSQL &#8211; temBoard Workaround for the ERROR: &#8216;SELECT * FROM history_tables()&#8217;"},"content":{"rendered":"<p>If your temBoard environment grows and grows, it will become more likely that you run into issues which you haven&#8217;t had before. One of those is the following ERROR. In the temboard.log you will see the full glory of this issue.<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n$ cat \/var\/log\/temboard\/temboard.log | grep ERROR | grep history\n2021-04-09 05:14:14,186 temboardui&#x5B;604]: &#x5B;monitoring] ERROR: Could not history montitoring tables\n2021-04-09 05:14:14,186 temboardui&#x5B;604]: &#x5B;monitoring] ERROR:  'SELECT * FROM history_tables()' {}\n2021-04-09 05:14:14,230 temboardui&#x5B;604]: &#x5B;taskmanager] ERROR: PL\/pgSQL function history_tables() line 14 at EXECUTE\n2021-04-09 05:14:14,230 temboardui&#x5B;604]: &#x5B;taskmanager] ERROR:  'SELECT * FROM history_tables()' {}\n2021-04-09 05:14:14,230 temboardui&#x5B;604]: &#x5B;taskmanager] ERROR:   File &quot;\/usr\/lib\/python2.7\/site-packages\/temboardui\/plugins\/monitoring\/__init__.py&quot;, line 113, in history_tables_worker\n2021-04-09 05:14:14,230 temboardui&#x5B;604]: &#x5B;taskmanager] ERROR: PL\/pgSQL function history_tables() line 14 at EXECUTE\n2021-04-09 05:14:14,230 temboardui&#x5B;604]: &#x5B;taskmanager] ERROR:  'SELECT * FROM history_tables()' {}\n2021-04-09 08:14:03,720 temboardui&#x5B;3941]: &#x5B;monitoring] ERROR: Could not history montitoring tables\n2021-04-09 08:14:03,721 temboardui&#x5B;3941]: &#x5B;monitoring] ERROR: PL\/pgSQL function history_tables() line 14 at EXECUTE\n2021-04-09 08:14:03,721 temboardui&#x5B;3941]: &#x5B;monitoring] ERROR:  'SELECT * FROM history_tables()' {}\n2021-04-09 08:14:03,721 temboardui&#x5B;3941]: &#x5B;monitoring] ERROR:   File &quot;\/usr\/lib\/python2.7\/site-packages\/temboardui\/plugins\/monitoring\/__init__.py&quot;, line 100, in history_tables_worker\n2021-04-09 08:14:03,721 temboardui&#x5B;3941]: &#x5B;monitoring] ERROR:     res = conn.execute(&quot;SELECT * FROM history_tables()&quot;)\n2021-04-09 08:14:03,721 temboardui&#x5B;3941]: &#x5B;monitoring] ERROR: PL\/pgSQL function history_tables() line 14 at EXECUTE\n2021-04-09 08:14:03,721 temboardui&#x5B;3941]: &#x5B;monitoring] ERROR:  'SELECT * FROM history_tables()' {}\n2021-04-09 08:14:03,732 temboardui&#x5B;3941]: &#x5B;taskmanager] ERROR: PL\/pgSQL function history_tables() line 14 at EXECUTE\n2021-04-09 08:14:03,732 temboardui&#x5B;3941]: &#x5B;taskmanager] ERROR:  'SELECT * FROM history_tables()' {}\n2021-04-09 08:14:03,732 temboardui&#x5B;3941]: &#x5B;taskmanager] ERROR:   File &quot;\/usr\/lib\/python2.7\/site-packages\/temboardui\/plugins\/monitoring\/__init__.py&quot;, line 113, in history_tables_worker\n2021-04-09 08:14:03,732 temboardui&#x5B;3941]: &#x5B;taskmanager] ERROR: PL\/pgSQL function history_tables() line 14 at EXECUTE\n2021-04-09 08:14:03,732 temboardui&#x5B;3941]: &#x5B;taskmanager] ERROR:  'SELECT * FROM history_tables()' {}\n<\/pre>\n<p>It will show up in the PostgreSQL log as well.<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n2021-04-09 11:14:20.269 CEST &#x5B;7346] ERROR:  deadlock detected\n2021-04-09 11:14:20.269 CEST &#x5B;7346] DETAIL:  Process 7346 waits for ShareLock on relation 16820 of database 16566; blocked by process 7699.\n        Process 7699 waits for RowExclusiveLock on relation 16778 of database 16566; blocked by process 7346.\n        Process 7346: SELECT * FROM history_tables()\n        Process 7699:\n        INSERT INTO monitoring.metric_sessions_current\n        VALUES ('2021-04-09T11:08:37.532164+02:00', 119, 'template1', (NULL, 0, 0, 0, 0, 0, 0, 0, 0))\n2021-04-09 11:14:20.269 CEST &#x5B;7346] HINT:  See server log for query details.\n2021-04-09 11:14:20.269 CEST &#x5B;7346] CONTEXT:  SQL statement &quot;LOCK TABLE metric_xacts_current IN SHARE MODE&quot;\n        PL\/pgSQL function history_tables() line 14 at EXECUTE\n2021-04-09 11:14:20.269 CEST &#x5B;7346] STATEMENT:  SELECT * FROM history_tables()\n2021-04-09 11:14:20.275 CEST &#x5B;7721] LOG:  duration: 321704.730 ms  statement:\n        INSERT INTO monitoring.metric_sessions_current\n        VALUES ('2021-04-09T11:08:46.608808+02:00', 65, 'template1', (NULL, 0, 0, 0, 0, 0, 0, 0, 0))\n2021-04-09 11:14:20.275 CEST &#x5B;7603] LOG:  duration: 322836.309 ms  statement:\n        INSERT INTO monitoring.metric_sessions_current\n        VALUES ('2021-04-09T11:08:48.085377+02:00', 15, 'template1', (NULL, 0, 0, 0, 0, 0, 0, 0, 0))\n<\/pre>\n<p>It looks like a locking issue. As long as the temBoard service is running, you will not be able to fix the issue. However, there is very simple workaround which you can use to fix the issue. It is simply stopping the service, run the command &#8220;SELECT * FROM history_tables()&#8221; manually, and start the service again.<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n$ sudo systemctl stop temboard.service\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  Drop-In: \/etc\/systemd\/system\/temboard.service.d\n           +-override.conf\n   Active: failed (Result: exit-code) since Wed 2021-04-14 11:04:23 CEST; 5s ago\n  Process: 1560 ExecStart=\/usr\/bin\/env SYSTEMD=1 temboard -c \/etc\/temboard\/temboard.conf (code=exited, status=1\/FAILURE)\n Main PID: 1560 (code=exited, status=1\/FAILURE)\n\nApr 14 11:04:22 host01 env&#x5B;1560]: web terminated.\nApr 14 11:04:22 host01 systemd&#x5B;1]: Stopping temBoard Web UI...\nApr 14 11:04:22 host01 env&#x5B;1560]: scheduler terminated.\nApr 14 11:04:22 host01 env&#x5B;1560]: worker pool terminated.\nApr 14 11:04:22 host01 env&#x5B;1560]: worker pool terminated.\nApr 14 11:04:22 host01 env&#x5B;1560]: worker pool terminated.\nApr 14 11:04:23 host01 systemd&#x5B;1]: temboard.service: main process exited, code=exited, status=1\/FAILURE\nApr 14 11:04:23 host01 systemd&#x5B;1]: Stopped temBoard Web UI.\nApr 14 11:04:23 host01 systemd&#x5B;1]: Unit temboard.service entered failed state.\nApr 14 11:04:23 host01 systemd&#x5B;1]: temboard.service failed.\n<\/pre>\n<p>Now run the command manually until the history tables are cleared.<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n(postgres@&#x5B;local]:58888)&#x5B;temboard] set search_path = monitoring ;\nSET\n(postgres@&#x5B;local]:58888)&#x5B;temboard] SELECT * FROM history_tables();\n                tblname                | nb_rows\n---------------------------------------+---------\n metric_sessions_history               |    6168\n metric_xacts_history                  |    6168\n metric_locks_history                  |    6168\n metric_blocks_history                 |    6168\n metric_bgwriter_history               |    1364\n metric_db_size_history                |    6168\n metric_tblspc_size_history            |    2728\n metric_filesystems_size_history       |    3927\n metric_temp_files_size_delta_history  |    6104\n metric_wal_files_history              |     702\n metric_cpu_history                    |     280\n metric_process_history                |     280\n metric_memory_history                 |     280\n metric_loadavg_history                |     280\n metric_vacuum_analyze_history         |       0\n metric_replication_lag_history        |       0\n metric_replication_connection_history |     646\n metric_heap_bloat_history             |    1348\n metric_btree_bloat_history            |    1348\n(19 rows)\n\n\n(postgres@&#x5B;local]:58888)&#x5B;temboard] SELECT * FROM history_tables();\n                tblname                | nb_rows\n---------------------------------------+---------\n metric_sessions_history               |       0\n metric_xacts_history                  |       0\n metric_locks_history                  |       0\n metric_blocks_history                 |       0\n metric_bgwriter_history               |       0\n metric_db_size_history                |       0\n metric_tblspc_size_history            |       0\n metric_filesystems_size_history       |       0\n metric_temp_files_size_delta_history  |       0\n metric_wal_files_history              |       0\n metric_cpu_history                    |       0\n metric_process_history                |       0\n metric_memory_history                 |       0\n metric_loadavg_history                |       0\n metric_vacuum_analyze_history         |       0\n metric_replication_lag_history        |       0\n metric_replication_connection_history |       0\n metric_heap_bloat_history             |       0\n metric_btree_bloat_history            |       0\n(19 rows)\n<\/pre>\n<p>And afterwards start the service again.<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n$ sudo systemctl start temboard.service\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  Drop-In: \/etc\/systemd\/system\/temboard.service.d\n           +-override.conf\n   Active: active (running) since Wed 2021-04-14 11:05:02 CEST; 7s ago\n Main PID: 6561 (temboard)\n   CGroup: \/system.slice\/temboard.service\n           +-6561 temboard: web\n           +-6576 temboard: worker pool\n           +-6577 temboard: scheduler\n           +-6823 temboard: worker pool\n           +-6836 temboard: worker pool\n           +-6848 temboard: worker pool\n           +-6856 temboard: worker pool\n           +-6858 temboard: worker pool\n           +-6859 temboard: worker pool\n           +-6925 temboard: worker pool\n           +-6927 temboard: worker pool\n           +-6941 temboard: worker pool\n           +-6943 temboard: worker pool\n           +-6946 temboard: worker pool\n           +-6947 temboard: worker pool\n\nApr 14 11:05:09 host01 env&#x5B;6561]: End of collector worker.\nApr 14 11:05:09 host01 env&#x5B;6561]: End of collector worker.\nApr 14 11:05:09 host01 env&#x5B;6561]: Starting collector worker for host02.example.ch:44025\nApr 14 11:05:09 host01 env&#x5B;6561]: Starting collector worker for host02.example.ch:44026\nApr 14 11:05:09 host01 env&#x5B;6561]: Starting collector worker for host02.example.ch:44029\nApr 14 11:05:09 host01 env&#x5B;6561]: Failed to preprocess alerting check 'wal_files_archive': list index out of range\nApr 14 11:05:09 host01 env&#x5B;6561]: Failed to preprocess alerting check 'wal_files_total': list index out of range\nApr 14 11:05:09 host01 env&#x5B;6561]: Failed to preprocess alerting check 'replication_lag': list index out of range\nApr 14 11:05:09 host01 env&#x5B;6561]: Starting collector worker for host02.example.ch:44030\nApr 14 11:05:09 host01 env&#x5B;6561]: End of collector worker.\n<\/pre>\n<p>That&#8217;s it. From now on, the ERROR should not appear in the temboard.log anymore.<\/p>\n<h3>Conclusion<\/h3>\n<p>Always keep an eye on your temboard.log file and scan it for errors.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>If your temBoard environment grows and grows, it will become more likely that you run into issues which you haven&#8217;t had before. One of those is the following ERROR. In the temboard.log you will see the full glory of this issue. $ cat \/var\/log\/temboard\/temboard.log | grep ERROR | grep history 2021-04-09 05:14:14,186 temboardui&#x5B;604]: &#x5B;monitoring] ERROR: [&hellip;]<\/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-251","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 Workaround for the ERROR: &#039;SELECT * FROM history_tables()&#039; - 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=251\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PostgreSQL - temBoard Workaround for the ERROR: &#039;SELECT * FROM history_tables()&#039; - ptdb - Platinum DB\" \/>\n<meta property=\"og:description\" content=\"If your temBoard environment grows and grows, it will become more likely that you run into issues which you haven&#8217;t had before. One of those is the following ERROR. In the temboard.log you will see the full glory of this issue. $ cat \/var\/log\/temboard\/temboard.log | grep ERROR | grep history 2021-04-09 05:14:14,186 temboardui&#x5B;604]: &#x5B;monitoring] ERROR: [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ptdb.ch\/?p=251\" \/>\n<meta property=\"og:site_name\" content=\"ptdb - Platinum DB\" \/>\n<meta property=\"article:published_time\" content=\"2021-04-14T09:41:00+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=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ptdb.ch\/?p=251\",\"url\":\"https:\/\/ptdb.ch\/?p=251\",\"name\":\"PostgreSQL - temBoard Workaround for the ERROR: 'SELECT * FROM history_tables()' - ptdb - Platinum DB\",\"isPartOf\":{\"@id\":\"https:\/\/ptdb.ch\/#website\"},\"datePublished\":\"2021-04-14T09:41:00+00:00\",\"author\":{\"@id\":\"https:\/\/ptdb.ch\/#\/schema\/person\/0b7baf52d23e71d85e1c95442306090b\"},\"breadcrumb\":{\"@id\":\"https:\/\/ptdb.ch\/?p=251#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ptdb.ch\/?p=251\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ptdb.ch\/?p=251#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/ptdb.ch\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PostgreSQL &#8211; temBoard Workaround for the ERROR: &#8216;SELECT * FROM history_tables()&#8217;\"}]},{\"@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 Workaround for the ERROR: 'SELECT * FROM history_tables()' - 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=251","og_locale":"en_US","og_type":"article","og_title":"PostgreSQL - temBoard Workaround for the ERROR: 'SELECT * FROM history_tables()' - ptdb - Platinum DB","og_description":"If your temBoard environment grows and grows, it will become more likely that you run into issues which you haven&#8217;t had before. One of those is the following ERROR. In the temboard.log you will see the full glory of this issue. $ cat \/var\/log\/temboard\/temboard.log | grep ERROR | grep history 2021-04-09 05:14:14,186 temboardui&#x5B;604]: &#x5B;monitoring] ERROR: [&hellip;]","og_url":"https:\/\/ptdb.ch\/?p=251","og_site_name":"ptdb - Platinum DB","article_published_time":"2021-04-14T09:41:00+00:00","author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/ptdb.ch\/?p=251","url":"https:\/\/ptdb.ch\/?p=251","name":"PostgreSQL - temBoard Workaround for the ERROR: 'SELECT * FROM history_tables()' - ptdb - Platinum DB","isPartOf":{"@id":"https:\/\/ptdb.ch\/#website"},"datePublished":"2021-04-14T09:41:00+00:00","author":{"@id":"https:\/\/ptdb.ch\/#\/schema\/person\/0b7baf52d23e71d85e1c95442306090b"},"breadcrumb":{"@id":"https:\/\/ptdb.ch\/?p=251#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ptdb.ch\/?p=251"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/ptdb.ch\/?p=251#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/ptdb.ch\/"},{"@type":"ListItem","position":2,"name":"PostgreSQL &#8211; temBoard Workaround for the ERROR: &#8216;SELECT * FROM history_tables()&#8217;"}]},{"@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\/251","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=251"}],"version-history":[{"count":0,"href":"https:\/\/ptdb.ch\/index.php?rest_route=\/wp\/v2\/posts\/251\/revisions"}],"wp:attachment":[{"href":"https:\/\/ptdb.ch\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=251"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ptdb.ch\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=251"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ptdb.ch\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=251"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}