{"id":5164,"date":"2015-07-03T12:52:07","date_gmt":"2015-07-03T10:52:07","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/testing-the-just-released-postgresql-9-5-alpha-in-a-docker-container\/"},"modified":"2015-07-03T12:52:07","modified_gmt":"2015-07-03T10:52:07","slug":"testing-the-just-released-postgresql-9-5-alpha-in-a-docker-container","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/testing-the-just-released-postgresql-9-5-alpha-in-a-docker-container\/","title":{"rendered":"Testing the just released PostgreSQL 9.5 Alpha in a docker container"},"content":{"rendered":"<p>On the 2cnd of July the PostgreSQL Global Development Group released an <a href=\"http:\/\/www.postgresql.org\/about\/news\/1595\/\" target=\"_blank\">alpha version of the upcoming PostgreSQL 9.5<\/a>. The same day, Josh Berkus, another of those <a href=\"http:\/\/www.postgresql.org\/community\/contributors\/\" target=\"_blank\">PostgreSQL core team members<\/a> released a docker image for testing this alpha release. It&#8217;s never been that easy to get started with PostgreSQL or testing new features.<br \/>\n<img decoding=\"async\" id=\"system-readmore\" class=\"mceItemReadMore\" title=\"Read More\" src=\"http:\/\/wwwold.dbi-services.com\/plugins\/editors\/jce\/tiny_mce\/plugins\/article\/img\/trans.gif\" alt=\"Read More\" \/><br \/>\nIf you are on Linux the docker packages should be available for your distribution. For Oracle Linux 7.1 make sure that the addons yum repository is enabled<\/p>\n<pre class=\"brush: java; gutter: true; first-line: 1\">cat \/etc\/yum.repos.d\/public-yum-ol7.repo | grep -A 3 addon\n [ol7_addons]\n name=Oracle Linux $releasever Add ons ($basearch)\n baseurl=http:\/\/public-yum.oracle.com\/repo\/OracleLinux\/OL7\/addons\/$basearch\/\n gpgkey=file:\/\/\/etc\/pki\/rpm-gpg\/RPM-GPG-KEY-oracle\n gpgcheck=1\n enabled=1<\/pre>\n<p>Installing docker is just:<\/p>\n<pre class=\"brush: java; gutter: true; first-line: 1\">\nyum install -y docker\nsystemctl start docker.service\n<\/pre>\n<p>Once docker is running we can search the docker registry:<\/p>\n<pre class=\"brush: java; gutter: true; first-line: 1\">\ndocker search postgres\nNAME                    DESCRIPTION                                     STARS     OFFICIAL   AUTOMATED\npostgres                The PostgreSQL object-relational database ...   809       [OK]       \nabevoelker\/postgres     Postgres 9.3 + WAL-E + PL\/V8 and PL\/Python...   7                    [OK]\nlinuxkonsult\/postgres   A Postgres trusted build installed with Chef.   5                    [OK]\nmacadmins\/postgres      Postgres that accepts remote connections b...   5                    [OK]\njamesbrink\/postgres     Highly configurable PostgreSQL container.       2                    [OK]\nkampka\/postgres         A postgresql image build on top of an arch...   2                    [OK]\nazukiapp\/postgres       Docker image to run PostgreSQL by Azuki - ...   2                    [OK]\nclkao\/postgres-plv8     Docker image for running PLV8 1.4 on Postg...   1                    [OK]\neeacms\/postgres         Docker image for PostgreSQL (RelStorage re...   0                    [OK]\nbantl23\/postgres        postgres development                            0                    [OK]\n<\/pre>\n<p>Get the PostgreSQL 9.5 alpha container and run it:<\/p>\n<pre class=\"brush: java; gutter: true; first-line: 1\">mkdir -p \/var\/tmp\/docker\/postgres\ndocker run -it --volume \"\/var\/tmp\/docker\/postgres:\/tests\" jberkus\/postgres95-test:alpha\nUnable to find image 'jberkus\/postgres95-test:alpha' locally\nalpha: Pulling from jberkus\/postgres95-test\n39bb80489af7: Pull complete \ndf2a0347c9d0: Pull complete \n65c152b01d5d: Pull complete \n22e16a33eefa: Pull complete \nb7003ab928a5: Pull complete \nb9ad663e6550: Pull complete \n712b208afbdf: Pull complete \n6db70337094f: Pull complete \n94dc52568254: Pull complete \naf3497b0915c: Pull complete \n203e588497fa: Pull complete \n35133c09fcd4: Already exists \nDigest: sha256:cd722ecdcfb68467d077f1edddf9cfcf1faabb954f544098a854bd8d83b61871\nStatus: Downloaded newer image for jberkus\/postgres95-test:alpha\n<\/pre>\n<p>Looks good so we should be able to use it:<\/p>\n<pre class=\"brush: java; gutter: true; first-line: 1\">root@5e74f2e32422:\/# su - postgres\npostgres@5e74f2e32422:~$ pg_ctl start\nserver starting\npostgres@5e74f2e32422:~$ [ @  @ 2015-07-03 06:57:09.840 GMT]:LOG:  redirecting log output to logging collector process\n[ @  @ 2015-07-03 06:57:09.840 GMT]:HINT:  Future log output will appear in directory \"pg_log\".\n \npostgres@5e74f2e32422:~$ psql\npsql (9.5alpha1)\nType \"help\" for help.\n\npostgres=# \\l\n                             List of databases\n   Name    |  Owner   | Encoding | Collate | Ctype |   Access privileges   \n-----------+----------+----------+---------+-------+-----------------------\n libdata   | libdata  | UTF8     | C       | C     | \n postgres  | postgres | UTF8     | C       | C     | \n template0 | postgres | UTF8     | C       | C     | =c\/postgres          +\n           |          |          |         |       | postgres=CTc\/postgres\n template1 | postgres | UTF8     | C       | C     | =c\/postgres          +\n           |          |          |         |       | postgres=CTc\/postgres\n(4 rows)\n\n<\/pre>\n<p>Cool. Minimal effort to get a test infrastructure with docker. (Please notice that I did everything as root. It is always better to setup proper sudo permissions)<\/p>\n","protected":false},"excerpt":{"rendered":"<p>On the 2cnd of July the PostgreSQL Global Development Group released an alpha version of the upcoming PostgreSQL 9.5. The same day, Josh Berkus, another of those PostgreSQL core team members released a docker image for testing this alpha release. It&#8217;s never been that easy to get started with PostgreSQL or testing new features. If [&hellip;]<\/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":[601,77],"type_dbi":[],"class_list":["post-5164","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","tag-docker","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>Testing the just released PostgreSQL 9.5 Alpha in a docker container - 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-the-just-released-postgresql-9-5-alpha-in-a-docker-container\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Testing the just released PostgreSQL 9.5 Alpha in a docker container\" \/>\n<meta property=\"og:description\" content=\"On the 2cnd of July the PostgreSQL Global Development Group released an alpha version of the upcoming PostgreSQL 9.5. The same day, Josh Berkus, another of those PostgreSQL core team members released a docker image for testing this alpha release. It&#8217;s never been that easy to get started with PostgreSQL or testing new features. If [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/testing-the-just-released-postgresql-9-5-alpha-in-a-docker-container\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2015-07-03T10:52:07+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/wwwold.dbi-services.com\/plugins\/editors\/jce\/tiny_mce\/plugins\/article\/img\/trans.gif\" \/>\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\/testing-the-just-released-postgresql-9-5-alpha-in-a-docker-container\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/testing-the-just-released-postgresql-9-5-alpha-in-a-docker-container\/\"},\"author\":{\"name\":\"Daniel Westermann\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66\"},\"headline\":\"Testing the just released PostgreSQL 9.5 Alpha in a docker container\",\"datePublished\":\"2015-07-03T10:52:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/testing-the-just-released-postgresql-9-5-alpha-in-a-docker-container\/\"},\"wordCount\":149,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/testing-the-just-released-postgresql-9-5-alpha-in-a-docker-container\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/wwwold.dbi-services.com\/plugins\/editors\/jce\/tiny_mce\/plugins\/article\/img\/trans.gif\",\"keywords\":[\"Docker\",\"PostgreSQL\"],\"articleSection\":[\"Database Administration &amp; Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/testing-the-just-released-postgresql-9-5-alpha-in-a-docker-container\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/testing-the-just-released-postgresql-9-5-alpha-in-a-docker-container\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/testing-the-just-released-postgresql-9-5-alpha-in-a-docker-container\/\",\"name\":\"Testing the just released PostgreSQL 9.5 Alpha in a docker container - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/testing-the-just-released-postgresql-9-5-alpha-in-a-docker-container\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/testing-the-just-released-postgresql-9-5-alpha-in-a-docker-container\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/wwwold.dbi-services.com\/plugins\/editors\/jce\/tiny_mce\/plugins\/article\/img\/trans.gif\",\"datePublished\":\"2015-07-03T10:52:07+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/testing-the-just-released-postgresql-9-5-alpha-in-a-docker-container\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/testing-the-just-released-postgresql-9-5-alpha-in-a-docker-container\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/testing-the-just-released-postgresql-9-5-alpha-in-a-docker-container\/#primaryimage\",\"url\":\"http:\/\/wwwold.dbi-services.com\/plugins\/editors\/jce\/tiny_mce\/plugins\/article\/img\/trans.gif\",\"contentUrl\":\"http:\/\/wwwold.dbi-services.com\/plugins\/editors\/jce\/tiny_mce\/plugins\/article\/img\/trans.gif\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/testing-the-just-released-postgresql-9-5-alpha-in-a-docker-container\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Testing the just released PostgreSQL 9.5 Alpha in a docker container\"}]},{\"@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":"Testing the just released PostgreSQL 9.5 Alpha in a docker container - 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-the-just-released-postgresql-9-5-alpha-in-a-docker-container\/","og_locale":"en_US","og_type":"article","og_title":"Testing the just released PostgreSQL 9.5 Alpha in a docker container","og_description":"On the 2cnd of July the PostgreSQL Global Development Group released an alpha version of the upcoming PostgreSQL 9.5. The same day, Josh Berkus, another of those PostgreSQL core team members released a docker image for testing this alpha release. It&#8217;s never been that easy to get started with PostgreSQL or testing new features. If [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/testing-the-just-released-postgresql-9-5-alpha-in-a-docker-container\/","og_site_name":"dbi Blog","article_published_time":"2015-07-03T10:52:07+00:00","og_image":[{"url":"http:\/\/wwwold.dbi-services.com\/plugins\/editors\/jce\/tiny_mce\/plugins\/article\/img\/trans.gif","type":"","width":"","height":""}],"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\/testing-the-just-released-postgresql-9-5-alpha-in-a-docker-container\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/testing-the-just-released-postgresql-9-5-alpha-in-a-docker-container\/"},"author":{"name":"Daniel Westermann","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66"},"headline":"Testing the just released PostgreSQL 9.5 Alpha in a docker container","datePublished":"2015-07-03T10:52:07+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/testing-the-just-released-postgresql-9-5-alpha-in-a-docker-container\/"},"wordCount":149,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/testing-the-just-released-postgresql-9-5-alpha-in-a-docker-container\/#primaryimage"},"thumbnailUrl":"http:\/\/wwwold.dbi-services.com\/plugins\/editors\/jce\/tiny_mce\/plugins\/article\/img\/trans.gif","keywords":["Docker","PostgreSQL"],"articleSection":["Database Administration &amp; Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/testing-the-just-released-postgresql-9-5-alpha-in-a-docker-container\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/testing-the-just-released-postgresql-9-5-alpha-in-a-docker-container\/","url":"https:\/\/www.dbi-services.com\/blog\/testing-the-just-released-postgresql-9-5-alpha-in-a-docker-container\/","name":"Testing the just released PostgreSQL 9.5 Alpha in a docker container - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/testing-the-just-released-postgresql-9-5-alpha-in-a-docker-container\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/testing-the-just-released-postgresql-9-5-alpha-in-a-docker-container\/#primaryimage"},"thumbnailUrl":"http:\/\/wwwold.dbi-services.com\/plugins\/editors\/jce\/tiny_mce\/plugins\/article\/img\/trans.gif","datePublished":"2015-07-03T10:52:07+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/testing-the-just-released-postgresql-9-5-alpha-in-a-docker-container\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/testing-the-just-released-postgresql-9-5-alpha-in-a-docker-container\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/testing-the-just-released-postgresql-9-5-alpha-in-a-docker-container\/#primaryimage","url":"http:\/\/wwwold.dbi-services.com\/plugins\/editors\/jce\/tiny_mce\/plugins\/article\/img\/trans.gif","contentUrl":"http:\/\/wwwold.dbi-services.com\/plugins\/editors\/jce\/tiny_mce\/plugins\/article\/img\/trans.gif"},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/testing-the-just-released-postgresql-9-5-alpha-in-a-docker-container\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Testing the just released PostgreSQL 9.5 Alpha in a docker container"}]},{"@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\/5164","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=5164"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/5164\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=5164"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=5164"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=5164"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=5164"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}