{"id":33294,"date":"2024-05-27T08:05:58","date_gmt":"2024-05-27T06:05:58","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=33294"},"modified":"2024-05-27T08:09:31","modified_gmt":"2024-05-27T06:09:31","slug":"time-to-test-postgresql-17beta1-is-there","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/time-to-test-postgresql-17beta1-is-there\/","title":{"rendered":"Time to test: PostgreSQL 17beta1 is there"},"content":{"rendered":"\n<p>It is this time of the year when a new PostgreSQL major version beta release is available for testing. PostgreSQL 17 (scheduled to be released later this year) is no exception to that: Last week, the first beta of PostgreSQL 17 was <a href=\"https:\/\/www.postgresql.org\/about\/news\/postgresql-17-beta-1-released-2865\/\" target=\"_blank\" rel=\"noreferrer noopener\">announced<\/a>. While many people are not really interested in beta releases, they really should be, especially when it comes to critical applications. If they \/ you test now, potential bugs can be fixed before the final version will be released.<\/p>\n\n\n\n<p>I am absolutely aware that testing takes time, but this time is spend wisely and you can really help the PostgreSQL community be reporting back any issues you&#8217;ll face. The earlier you can do this, the better.<\/p>\n\n\n\n<p>The <a href=\"https:\/\/www.postgresql.org\/about\/news\/postgresql-17-beta-1-released-2865\/\">release announcement<\/a> contains a summary of the major new features you might be interested in. But there is much more to explore in the <a href=\"https:\/\/www.postgresql.org\/docs\/17\/release-17.html\" target=\"_blank\" rel=\"noreferrer noopener\">release notes<\/a> (just keep in mind that the release notes are also subject to change until the final release of PostgreSQL 17).<\/p>\n\n\n\n<p>I&#8217;ve written about some of the new features here on this blog and if you want to follow up here is the list of blog posts:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/www.dbi-services.com\/blog\/postgresql-17-transaction_timeout\/\">PostgreSQL 17: transaction_timeout<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.dbi-services.com\/blog\/postgresql-17-track-skipped-rows-from-copy-in-pg_stat_progress_copy\/\">PostgreSQL 17: Track skipped rows from COPY in pg_stat_progress_copy<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.dbi-services.com\/blog\/postgresql-17-incremental-backups-pg_walsummary\/\">PostgreSQL 17: Incremental backups, pg_walsummary<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.dbi-services.com\/blog\/postgresql-17-copy-and-save_error_to\/\">PostgreSQL 17: copy and SAVE_ERROR_TO<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.dbi-services.com\/blog\/postgresql-17-incremental-backups-system-information-functions\/\">PostgreSQL 17: Incremental backups, system information functions<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.dbi-services.com\/blog\/postgresql-17-incremental-backups-and-backup-chains\/\">PostgreSQL 17: Incremental backups and backup chains<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.dbi-services.com\/blog\/postgresql-17-support-for-incremental-backups\/\">PostgreSQL 17: Support for incremental backups<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.dbi-services.com\/blog\/postgresql-17-reset-all-shared-statistics-at-once-with-pg_stat_reset_shared\/\">PostgreSQL 17: Reset shared statistics at once with pg_stat_reset_shared()<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.dbi-services.com\/blog\/postgresql-17-new-catalog-view-pg_stat_checkpointer\/\">PostgreSQL 17: New catalog view pg_stat_checkpointer<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.dbi-services.com\/blog\/postgresql-17-login-event-triggers\/\">PostgreSQL 17: login event triggers<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.dbi-services.com\/blog\/postgresql-17-support-for-at-local\/\" target=\"_blank\" rel=\"noreferrer noopener\">PostgreSQL 17: Support for AT LOCAL<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.dbi-services.com\/blog\/no-more-snapshot-too-old-in-postgresql-17\/\">No more snapshot too old in PostgreSQL 17<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.dbi-services.com\/blog\/postgresql-17-allow-watch-to-stop-based-on-the-number-of-rows-returned\/\">PostgreSQL 17: Allow \u201c\\watch\u201d to stop based on the number of rows returned<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.dbi-services.com\/blog\/postgresql-17-pg_wait_events\/\">PostgreSQL 17: pg_wait_events<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.dbi-services.com\/blog\/postgresql-17-split-and-merge-partitions\/\">PostgreSQL 17: Split and Merge partitions<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.dbi-services.com\/blog\/postgresql-17-convert-a-physical-replica-to-a-logical-replica-using-pg_createsubscriber\/\">PostgreSQL 17: Convert a physical replica to a logical replica using pg_createsubscriber<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.dbi-services.com\/blog\/postgresql-17-add-allow_alter_system-guc\/\">PostgreSQL 17: Add allow_alter_system GUC<\/a><\/li>\n<\/ul>\n\n\n\n<p>Happy testing.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>It is this time of the year when a new PostgreSQL major version beta release is available for testing. PostgreSQL 17 (scheduled to be released later this year) is no exception to that: Last week, the first beta of PostgreSQL 17 was announced. While many people are not really interested in beta releases, they really [&hellip;]<\/p>\n","protected":false},"author":29,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,198],"tags":[77],"type_dbi":[],"class_list":["post-33294","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","category-database-management","tag-postgresql"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Time to test: PostgreSQL 17beta1 is there - dbi Blog<\/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:\/\/www.dbi-services.com\/blog\/time-to-test-postgresql-17beta1-is-there\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Time to test: PostgreSQL 17beta1 is there\" \/>\n<meta property=\"og:description\" content=\"It is this time of the year when a new PostgreSQL major version beta release is available for testing. PostgreSQL 17 (scheduled to be released later this year) is no exception to that: Last week, the first beta of PostgreSQL 17 was announced. While many people are not really interested in beta releases, they really [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/time-to-test-postgresql-17beta1-is-there\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2024-05-27T06:05:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-05-27T06:09:31+00:00\" \/>\n<meta name=\"author\" content=\"Daniel Westermann\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@westermanndanie\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Daniel Westermann\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/time-to-test-postgresql-17beta1-is-there\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/time-to-test-postgresql-17beta1-is-there\/\"},\"author\":{\"name\":\"Daniel Westermann\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66\"},\"headline\":\"Time to test: PostgreSQL 17beta1 is there\",\"datePublished\":\"2024-05-27T06:05:58+00:00\",\"dateModified\":\"2024-05-27T06:09:31+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/time-to-test-postgresql-17beta1-is-there\/\"},\"wordCount\":314,\"commentCount\":0,\"keywords\":[\"PostgreSQL\"],\"articleSection\":[\"Database Administration &amp; Monitoring\",\"Database management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/time-to-test-postgresql-17beta1-is-there\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/time-to-test-postgresql-17beta1-is-there\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/time-to-test-postgresql-17beta1-is-there\/\",\"name\":\"Time to test: PostgreSQL 17beta1 is there - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2024-05-27T06:05:58+00:00\",\"dateModified\":\"2024-05-27T06:09:31+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/time-to-test-postgresql-17beta1-is-there\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/time-to-test-postgresql-17beta1-is-there\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/time-to-test-postgresql-17beta1-is-there\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Time to test: PostgreSQL 17beta1 is there\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66\",\"name\":\"Daniel Westermann\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g\",\"caption\":\"Daniel Westermann\"},\"description\":\"Daniel Westermann is Principal Consultant and Technology Leader Open Infrastructure at dbi services. He has more than 15 years of experience in management, engineering and optimization of databases and infrastructures, especially on Oracle and PostgreSQL. Since the beginning of his career, he has specialized in Oracle Technologies and is Oracle Certified Professional 12c and Oracle Certified Expert RAC\/GridInfra. Over time, Daniel has become increasingly interested in open source technologies, becoming \u201cTechnology Leader Open Infrastructure\u201d and PostgreSQL expert. \u00a0Based on community or EnterpriseDB tools, he develops and installs complex high available solutions with PostgreSQL. He is also a certified PostgreSQL Plus 9.0 Professional and a Postgres Advanced Server 9.4 Professional. He is a regular speaker at PostgreSQL conferences in Switzerland and Europe. Today Daniel is also supporting our customers on AWS services such as AWS RDS, database migrations into the cloud, EC2 and automated infrastructure management with AWS SSM (System Manager). He is a certified AWS Solutions Architect Professional. Prior to dbi services, Daniel was Management System Engineer at LC SYSTEMS-Engineering AG in Basel. Before that, he worked as Oracle Developper &amp;\u00a0Project Manager at Delta Energy Solutions AG in Basel (today Powel AG). Daniel holds a diploma in Business Informatics (DHBW, Germany). His branch-related experience mainly covers the pharma industry, the financial sector, energy, lottery and telecommunications.\",\"sameAs\":[\"https:\/\/x.com\/westermanndanie\"],\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/daniel-westermann\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Time to test: PostgreSQL 17beta1 is there - dbi Blog","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:\/\/www.dbi-services.com\/blog\/time-to-test-postgresql-17beta1-is-there\/","og_locale":"en_US","og_type":"article","og_title":"Time to test: PostgreSQL 17beta1 is there","og_description":"It is this time of the year when a new PostgreSQL major version beta release is available for testing. PostgreSQL 17 (scheduled to be released later this year) is no exception to that: Last week, the first beta of PostgreSQL 17 was announced. While many people are not really interested in beta releases, they really [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/time-to-test-postgresql-17beta1-is-there\/","og_site_name":"dbi Blog","article_published_time":"2024-05-27T06:05:58+00:00","article_modified_time":"2024-05-27T06:09:31+00:00","author":"Daniel Westermann","twitter_card":"summary_large_image","twitter_creator":"@westermanndanie","twitter_misc":{"Written by":"Daniel Westermann","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/time-to-test-postgresql-17beta1-is-there\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/time-to-test-postgresql-17beta1-is-there\/"},"author":{"name":"Daniel Westermann","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66"},"headline":"Time to test: PostgreSQL 17beta1 is there","datePublished":"2024-05-27T06:05:58+00:00","dateModified":"2024-05-27T06:09:31+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/time-to-test-postgresql-17beta1-is-there\/"},"wordCount":314,"commentCount":0,"keywords":["PostgreSQL"],"articleSection":["Database Administration &amp; Monitoring","Database management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/time-to-test-postgresql-17beta1-is-there\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/time-to-test-postgresql-17beta1-is-there\/","url":"https:\/\/www.dbi-services.com\/blog\/time-to-test-postgresql-17beta1-is-there\/","name":"Time to test: PostgreSQL 17beta1 is there - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2024-05-27T06:05:58+00:00","dateModified":"2024-05-27T06:09:31+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/time-to-test-postgresql-17beta1-is-there\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/time-to-test-postgresql-17beta1-is-there\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/time-to-test-postgresql-17beta1-is-there\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Time to test: PostgreSQL 17beta1 is there"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66","name":"Daniel Westermann","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g","caption":"Daniel Westermann"},"description":"Daniel Westermann is Principal Consultant and Technology Leader Open Infrastructure at dbi services. He has more than 15 years of experience in management, engineering and optimization of databases and infrastructures, especially on Oracle and PostgreSQL. Since the beginning of his career, he has specialized in Oracle Technologies and is Oracle Certified Professional 12c and Oracle Certified Expert RAC\/GridInfra. Over time, Daniel has become increasingly interested in open source technologies, becoming \u201cTechnology Leader Open Infrastructure\u201d and PostgreSQL expert. \u00a0Based on community or EnterpriseDB tools, he develops and installs complex high available solutions with PostgreSQL. He is also a certified PostgreSQL Plus 9.0 Professional and a Postgres Advanced Server 9.4 Professional. He is a regular speaker at PostgreSQL conferences in Switzerland and Europe. Today Daniel is also supporting our customers on AWS services such as AWS RDS, database migrations into the cloud, EC2 and automated infrastructure management with AWS SSM (System Manager). He is a certified AWS Solutions Architect Professional. Prior to dbi services, Daniel was Management System Engineer at LC SYSTEMS-Engineering AG in Basel. Before that, he worked as Oracle Developper &amp;\u00a0Project Manager at Delta Energy Solutions AG in Basel (today Powel AG). Daniel holds a diploma in Business Informatics (DHBW, Germany). His branch-related experience mainly covers the pharma industry, the financial sector, energy, lottery and telecommunications.","sameAs":["https:\/\/x.com\/westermanndanie"],"url":"https:\/\/www.dbi-services.com\/blog\/author\/daniel-westermann\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/33294","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/29"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=33294"}],"version-history":[{"count":3,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/33294\/revisions"}],"predecessor-version":[{"id":33298,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/33294\/revisions\/33298"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=33294"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=33294"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=33294"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=33294"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}