{"id":9991,"date":"2017-05-07T09:32:07","date_gmt":"2017-05-07T07:32:07","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/testing-new-postgresql-features-before-alphabetarc-releases\/"},"modified":"2017-05-07T09:32:07","modified_gmt":"2017-05-07T07:32:07","slug":"testing-new-postgresql-features-before-alphabetarc-releases","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/testing-new-postgresql-features-before-alphabetarc-releases\/","title":{"rendered":"Testing new PostgreSQL features before alpha\/beta\/rc releases"},"content":{"rendered":"

A long time ago I blogged on how you can use the PostgreSQL development snapshots to test new PostgreSQL features<\/a> before alpha\/beta\/rc releases are officially released. Another way to do this is to use git<\/a> to get the latest sources and build PostgreSQL from there. Everything which was committed<\/a> will be available to test. Btw: A great way to stay up to date is to subscribe to the mailing list just referenced. You’ll get a mail for each commit that happened, maybe one of those is getting your attention?<\/p>\n

<\/p>\n

To start you’ll obviously need git. For distributions using yum<\/a> this is just a matter of:<\/p>\n

\npostgres@pgbox:\/home\/postgres\/ [pg960final] sudo yum install git\n<\/pre>\n
For systems using apt<\/a> use:<\/p>\n
\npostgres@pgbox:\/home\/postgres\/ [pg960final] sudo apt-get install git\n<\/pre>\n
Depending on how you want to configure PostgreSQL you’ll need some development packages as well. For yum based systems this is a good starting point:<\/p>\n
\npostgres@pgbox:\/home\/postgres\/ [pg960final] sudo yum install -y gcc openldap-devel python-devel readline-devel redhat-lsb bison flex perl-ExtUtils-Embed zlib-devel crypto-utils openssl-devel pam-devel libxml2-devel libxslt-devel tcl tcl-devel openssh-clients bzip2 net-tools wget screen ksh unzip\n<\/pre>\n
For apt based systems you might want to start with this:<\/p>\n
\npostgres@pgbox:\/home\/postgres\/ [pg960final] sudo apt-get install libldap2-dev libpython-dev libreadline-dev libssl-dev bison flex libghc-zlib-dev libcrypto++-dev libxml2-dev libxslt1-dev tcl tclcl-dev bzip2 wget screen ksh libpam0g-dev libperl-dev make unzip libpam0g-dev tcl-dev python\n<\/pre>\n
Not all of those packages are required, they just reflect what we usually install before building PostgreSQL from source. Of course you should adjust this and remove packages that are not required for what you plan to do.<\/p>\n
How do you then get the latest PostgreSQL sources? Quite easy, it is documented in the PostgreSQL wiki<\/a>:<\/p>\n
\npostgres@pgbox:\/home\/postgres\/ [pg960final] mkdir IwantToTest\npostgres@pgbox:\/home\/postgres\/ [pg960final] cd IwantToTest\/\npostgres@pgbox:\/home\/postgres\/IwantToTest\/ [pg960final] git clone git:\/\/git.postgresql.org\/git\/postgresql.git\n<\/pre>\n
The result should look similar to this:<\/p>\n
\nCloning into 'postgresql'...\nremote: Counting objects: 629074, done.\nremote: Compressing objects: 100% (95148\/95148), done.\nremote: Total 629074 (delta 534080), reused 626282 (delta 531478)\nReceiving objects: 100% (629074\/629074), 184.31 MiB | 26.40 MiB\/s, done.\nResolving deltas: 100% (534080\/534080), done.\n<\/pre>\n
From now on you have the complete PostgreSQL sources locally available. <\/p>\n
\npostgres@pgbox:\/home\/postgres\/IwantToTest\/ [pg960final] cd postgresql\/; ls\naclocal.m4  config  configure  configure.in  contrib  COPYRIGHT  doc  GNUmakefile.in  HISTORY  Makefile  README  README.git  src\n<\/pre>\n
Ready to test? Yes, but what? One possible way to start is asking git for what was committed recently:<\/p>\n
\npostgres@pgbox:\/home\/postgres\/IwantToTest\/postgresql\/ [pg960final] git log\ncommit 0de791ed760614991e7cb8a78fddd6874ea6919d\nAuthor: Peter Eisentraut peter_e@gmx.net\nDate:   Wed May 3 21:25:01 2017 -0400\n\n    Fix cursor_to_xml in tableforest false mode\n    \n    It only produced  elements but no wrapping table element.\n    \n    By contrast, cursor_to_xmlschema produced a schema that is now correct\n    but did not previously match the XML data produced by cursor_to_xml.\n    \n    In passing, also fix a minor misunderstanding about moving cursors in\n    the tests related to this.\n    \n    Reported-by: filip@jirsak.org\n    Based-on-patch-by: Thomas Munro thomas.munro@enterprisedb.com\n...\n<\/pre>\n
Usually you can find a link to the discussion in the commit message so can you read through the history of a specific commit. Another way is to read the development documentation<\/a> or the upcoming release notes<\/a> once available. <\/p>\n
All you need to do then is to build PostgreSQL:<\/p>\n
\npostgres@pgbox:\/home\/postgres\/IwantToTest\/postgresql\/ [pg960final] .\/configure\npostgres@pgbox:\/home\/postgres\/IwantToTest\/postgresql\/ [pg960final] make all\npostgres@pgbox:\/home\/postgres\/IwantToTest\/postgresql\/ [pg960final] sudo make install\npostgres@pgbox:\/home\/postgres\/IwantToTest\/postgresql\/ [pg960final] cd contrib\npostgres@pgbox:\/home\/postgres\/IwantToTest\/postgresql\/contrib\/ [pg960final] make all\npostgres@pgbox:\/home\/postgres\/IwantToTest\/postgresql\/contrib\/ [pg960final] sudo make install\npostgres@pgbox:\/home\/postgres\/IwantToTest\/postgresql\/contrib\/ [pg960final] \/usr\/local\/pgsql\/bin\/initdb -D \/var\/tmp\/test\npostgres@pgbox:\/home\/postgres\/IwantToTest\/postgresql\/contrib\/ [pg960final] \/usr\/local\/pgsql\/bin\/pg_ctl -D \/var\/tmp\/test start\npostgres@pgbox:\/home\/postgres\/IwantToTest\/postgresql\/contrib\/ [pg960final] \/usr\/local\/pgsql\/bin\/psql postgres\npsql (10devel)\nType \"help\" for help.\n\npgbox\/postgres MASTER (postgres@5432) # \n<\/pre>\n
Happy testing …<\/p>\n","protected":false},"excerpt":{"rendered":"
A long time ago I blogged on how you can use the PostgreSQL development snapshots to test new PostgreSQL features before alpha\/beta\/rc releases are officially released. Another way to do this is to use git to get the latest sources and build PostgreSQL from there. Everything which was committed will be available to test. Btw: […]<\/p>\n","protected":false},"author":29,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[77],"type_dbi":[],"class_list":["post-9991","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","tag-postgresql"],"acf":[],"yoast_head":"\nTesting new PostgreSQL features before alpha\/beta\/rc releases - 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\/testing-new-postgresql-features-before-alphabetarc-releases\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Testing new PostgreSQL features before alpha\/beta\/rc releases\" \/>\n<meta property=\"og:description\" content=\"A long time ago I blogged on how you can use the PostgreSQL development snapshots to test new PostgreSQL features before alpha\/beta\/rc releases are officially released. Another way to do this is to use git to get the latest sources and build PostgreSQL from there. Everything which was committed will be available to test. Btw: […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/testing-new-postgresql-features-before-alphabetarc-releases\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2017-05-07T07:32:07+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=\"3 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\/testing-new-postgresql-features-before-alphabetarc-releases\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/testing-new-postgresql-features-before-alphabetarc-releases\/\"},\"author\":{\"name\":\"Daniel Westermann\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66\"},\"headline\":\"Testing new PostgreSQL features before alpha\/beta\/rc releases\",\"datePublished\":\"2017-05-07T07:32:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/testing-new-postgresql-features-before-alphabetarc-releases\/\"},\"wordCount\":304,\"commentCount\":0,\"keywords\":[\"PostgreSQL\"],\"articleSection\":[\"Database Administration & Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/testing-new-postgresql-features-before-alphabetarc-releases\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/testing-new-postgresql-features-before-alphabetarc-releases\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/testing-new-postgresql-features-before-alphabetarc-releases\/\",\"name\":\"Testing new PostgreSQL features before alpha\/beta\/rc releases - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2017-05-07T07:32:07+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/testing-new-postgresql-features-before-alphabetarc-releases\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/testing-new-postgresql-features-before-alphabetarc-releases\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/testing-new-postgresql-features-before-alphabetarc-releases\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Testing new PostgreSQL features before alpha\/beta\/rc releases\"}]},{\"@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 &\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":"Testing new PostgreSQL features before alpha\/beta\/rc releases - 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\/testing-new-postgresql-features-before-alphabetarc-releases\/","og_locale":"en_US","og_type":"article","og_title":"Testing new PostgreSQL features before alpha\/beta\/rc releases","og_description":"A long time ago I blogged on how you can use the PostgreSQL development snapshots to test new PostgreSQL features before alpha\/beta\/rc releases are officially released. Another way to do this is to use git to get the latest sources and build PostgreSQL from there. Everything which was committed will be available to test. Btw: […]","og_url":"https:\/\/www.dbi-services.com\/blog\/testing-new-postgresql-features-before-alphabetarc-releases\/","og_site_name":"dbi Blog","article_published_time":"2017-05-07T07:32:07+00:00","author":"Daniel Westermann","twitter_card":"summary_large_image","twitter_creator":"@westermanndanie","twitter_misc":{"Written by":"Daniel Westermann","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/testing-new-postgresql-features-before-alphabetarc-releases\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/testing-new-postgresql-features-before-alphabetarc-releases\/"},"author":{"name":"Daniel Westermann","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66"},"headline":"Testing new PostgreSQL features before alpha\/beta\/rc releases","datePublished":"2017-05-07T07:32:07+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/testing-new-postgresql-features-before-alphabetarc-releases\/"},"wordCount":304,"commentCount":0,"keywords":["PostgreSQL"],"articleSection":["Database Administration & Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/testing-new-postgresql-features-before-alphabetarc-releases\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/testing-new-postgresql-features-before-alphabetarc-releases\/","url":"https:\/\/www.dbi-services.com\/blog\/testing-new-postgresql-features-before-alphabetarc-releases\/","name":"Testing new PostgreSQL features before alpha\/beta\/rc releases - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2017-05-07T07:32:07+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/testing-new-postgresql-features-before-alphabetarc-releases\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/testing-new-postgresql-features-before-alphabetarc-releases\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/testing-new-postgresql-features-before-alphabetarc-releases\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Testing new PostgreSQL features before alpha\/beta\/rc releases"}]},{"@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 &\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\/9991","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=9991"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/9991\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=9991"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=9991"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=9991"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=9991"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}