{"id":6943,"date":"2016-01-22T08:50:09","date_gmt":"2016-01-22T07:50:09","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/using-the-official-postgresql-yum-repositories\/"},"modified":"2016-01-22T08:50:09","modified_gmt":"2016-01-22T07:50:09","slug":"using-the-official-postgresql-yum-repositories","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/using-the-official-postgresql-yum-repositories\/","title":{"rendered":"Using the official PostgreSQL yum repositories"},"content":{"rendered":"<p>Usually I advice to build PostgreSQL from source as it gives the most flexibility. Another option is to use the <a href=\"http:\/\/yum.postgresql.org\/\" target=\"_blank\" rel=\"noopener\">official yum repositories<\/a>. There is one repository for each <a href=\"http:\/\/www.postgresql.org\/support\/versioning\/\" target=\"_blank\" rel=\"noopener\">supported release of PostgreSQL<\/a> and most of the common RedHat based Linux distributions are listed: CentOS, Oracle Linux, RedHat, Fedora, Scientific Linux and even Amazon Linux.<\/p>\n<p>Currently PostgreSQL 9.6 is in active development and new features get <a href=\"http:\/\/commitfest.postgresql.org\/\" target=\"_blank\" rel=\"noopener\">developed and committed<\/a>. So lets try to add to the <a href=\"http:\/\/yum.postgresql.org\/repopackages.php#pg96\" target=\"_blank\" rel=\"noopener\">PostgreSQL 9.6 repository<\/a>. I assume I do not need to say that the 9.6 version is not for anything else than testing at the moment. <\/p>\n<p>As I am only Oracle Linux 7 with my VM I downloaded the <a href=\"http:\/\/yum.postgresql.org\/9.6\/redhat\/rhel-7-x86_64\/pgdg-oraclelinux96-9.6-1.noarch.rpm\" target=\"_blank\" rel=\"noopener\">repository rpm for this version<\/a>. Once this is transferred to the VM installation is easy:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">\nroot@oel7 tmp] yum localinstall pgdg-oraclelinux96-9.6-1.noarch.rpm\nLoaded plugins: ulninfo\nExamining pgdg-oraclelinux96-9.6-1.noarch.rpm: pgdg-oraclelinux96-9.6-1.noarch\nMarking pgdg-oraclelinux96-9.6-1.noarch.rpm to be installed\nResolving Dependencies\n--&gt; Running transaction check\n---&gt; Package pgdg-oraclelinux96.noarch 0:9.6-1 will be installed\n--&gt; Finished Dependency Resolution\n\nDependencies Resolved\n\n========================================================================================================================================================\n Package                                Arch                       Version                   Repository                                            Size\n========================================================================================================================================================\nInstalling:\n pgdg-oraclelinux96                     noarch                     9.6-1                     \/pgdg-oraclelinux96-9.6-1.noarch                     2.2 k\n\nTransaction Summary\n========================================================================================================================================================\nInstall  1 Package\n\nTotal size: 2.2 k\nInstalled size: 2.2 k\nIs this ok [y\/d\/N]: y\nDownloading packages:\nRunning transaction check\nRunning transaction test\nTransaction test succeeded\nRunning transaction\n  Installing : pgdg-oraclelinux96-9.6-1.noarch                                                                                                      1\/1 \n  Verifying  : pgdg-oraclelinux96-9.6-1.noarch                                                                                                      1\/1 \n\nInstalled:\n  pgdg-oraclelinux96.noarch 0:9.6-1                                                                                                                     \n\nComplete!\n<\/pre>\n<p>Lets see what is available:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">\n[root@oel7 tmp] yum search postgresql96\nLoaded plugins: ulninfo\n============================================================== N\/S matched: postgresql96 ===============================================================\npostgresql96-debuginfo.x86_64 : Debug information for package postgresql96\npostgresql96.x86_64 : PostgreSQL client programs and libraries\npostgresql96-contrib.x86_64 : Contributed source and binaries distributed with PostgreSQL\npostgresql96-devel.x86_64 : PostgreSQL development header files and libraries\npostgresql96-docs.x86_64 : Extra documentation for PostgreSQL\npostgresql96-libs.x86_64 : The shared libraries required for any PostgreSQL clients\npostgresql96-plperl.x86_64 : The Perl procedural language for PostgreSQL\npostgresql96-plpython.x86_64 : The Python procedural language for PostgreSQL\npostgresql96-pltcl.x86_64 : The Tcl procedural language for PostgreSQL\npostgresql96-server.x86_64 : The programs needed to create and run a PostgreSQL server\n<\/pre>\n<p>Not as much as in the PostgreSQL 9.5 repo (e.g. all the utilities like pg_top) but it is perfect for testing new features. So lets install PostgreSQL 9.6:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">\n[root@oel7 tmp] yum install postgresql96-server.x86_64\nLoaded plugins: ulninfo\nResolving Dependencies\n--&gt; Running transaction check\n---&gt; Package postgresql96-server.x86_64 0:9.6-git20160121_1PGDG.rhel7 will be installed\n--&gt; Processing Dependency: postgresql96-libs(x86-64) = 9.6-git20160121_1PGDG.rhel7 for package: postgresql96-server-9.6-git20160121_1PGDG.rhel7.x86_64\n--&gt; Processing Dependency: postgresql96(x86-64) = 9.6-git20160121_1PGDG.rhel7 for package: postgresql96-server-9.6-git20160121_1PGDG.rhel7.x86_64\n--&gt; Processing Dependency: postgresql96 = 9.6-git20160121_1PGDG.rhel7 for package: postgresql96-server-9.6-git20160121_1PGDG.rhel7.x86_64\n--&gt; Running transaction check\n---&gt; Package postgresql96.x86_64 0:9.6-git20160121_1PGDG.rhel7 will be installed\n---&gt; Package postgresql96-libs.x86_64 0:9.6-git20160121_1PGDG.rhel7 will be installed\n--&gt; Finished Dependency Resolution\n\nDependencies Resolved\n\n========================================================================================================================================================\n Package                                 Arch                       Version                                            Repository                  Size\n========================================================================================================================================================\nInstalling:\n postgresql96-server                     x86_64                     9.6-git20160121_1PGDG.rhel7                        pgdg96                     4.4 M\nInstalling for dependencies:\n postgresql96                            x86_64                     9.6-git20160121_1PGDG.rhel7                        pgdg96                     1.2 M\n postgresql96-libs                       x86_64                     9.6-git20160121_1PGDG.rhel7                        pgdg96                     204 k\n\nTransaction Summary\n========================================================================================================================================================\nInstall  1 Package (+2 Dependent packages)\n\nTotal download size: 5.8 M\nInstalled size: 24 M\nIs this ok [y\/d\/N]: y\nDownloading packages:\n(1\/3): postgresql96-9.6-git20160121_1PGDG.rhel7.x86_64.rpm                                                                       | 1.2 MB  00:00:00     \n(2\/3): postgresql96-libs-9.6-git20160121_1PGDG.rhel7.x86_64.rpm                                                                  | 204 kB  00:00:01     \n(3\/3): postgresql96-server-9.6-git20160121_1PGDG.rhel7.x86_64.rpm                                                                | 4.4 MB  00:00:01     \n--------------------------------------------------------------------------------------------------------------------------------------------------------\nTotal                                                                                                                   2.5 MB\/s | 5.8 MB  00:00:02     \nRunning transaction check\nRunning transaction test\nTransaction test succeeded\nRunning transaction\n  Installing : postgresql96-libs-9.6-git20160121_1PGDG.rhel7.x86_64                                                                                 1\/3 \n  Installing : postgresql96-9.6-git20160121_1PGDG.rhel7.x86_64                                                                                      2\/3 \n  Installing : postgresql96-server-9.6-git20160121_1PGDG.rhel7.x86_64                                                                               3\/3 \n  Verifying  : postgresql96-9.6-git20160121_1PGDG.rhel7.x86_64                                                                                      1\/3 \n  Verifying  : postgresql96-server-9.6-git20160121_1PGDG.rhel7.x86_64                                                                               2\/3 \n  Verifying  : postgresql96-libs-9.6-git20160121_1PGDG.rhel7.x86_64                                                                                 3\/3 \n\nInstalled:\n  postgresql96-server.x86_64 0:9.6-git20160121_1PGDG.rhel7                                                                                              \n\nDependency Installed:\n  postgresql96.x86_64 0:9.6-git20160121_1PGDG.rhel7                        postgresql96-libs.x86_64 0:9.6-git20160121_1PGDG.rhel7                       \n\nComplete!\n<\/pre>\n<p>When you install from the official repositories all will be installed here:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">\n[root@oel7 tmp] ls \/usr\/pgsql-9.6\/\nbin  lib  share\n[root@oel7 tmp] ls \/usr\/pgsql-9.6\/bin\/\nclusterdb   dropdb    pg_archivecleanup  pg_controldata  pg_isready      pg_rewind       pg_xlogdump                postmaster\ncreatedb    droplang  pg_basebackup      pg_ctl          pg_receivexlog  pg_test_fsync   postgres                   psql\ncreatelang  dropuser  pgbench            pg_dump         pg_resetxlog    pg_test_timing  postgresql96-check-db-dir  reindexdb\ncreateuser  initdb    pg_config          pg_dumpall      pg_restore      pg_upgrade      postgresql96-setup         vacuumdb\n<\/pre>\n<p>Creating, starting and connecting to a new PostgreSQL 9.6 instance is straight forward from now on:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">\n[root@oel7 tmp] su - postgres\nLast login: Fri Jan 22 09:37:34 CET 2016 on pts\/1\npostgres@oel7:\/home\/postgres\/ [dummy] mkdir data\npostgres@oel7:\/home\/postgres\/ [dummy] \/usr\/pgsql-9.6\/bin\/initdb -D data\/\nThe files belonging to this database system will be owned by user \"postgres\".\nThis user must also own the server process.\n\nThe database cluster will be initialized with locale \"en_US.UTF-8\".\nThe default database encoding has accordingly been set to \"UTF8\".\nThe default text search configuration will be set to \"english\".\n\nData page checksums are disabled.\n\nfixing permissions on existing directory data ... ok\ncreating subdirectories ... ok\nselecting default max_connections ... 100\nselecting default shared_buffers ... 128MB\nselecting dynamic shared memory implementation ... posix\ncreating configuration files ... ok\nrunning bootstrap script ... ok\nperforming post-bootstrap initialization ... ok\nsyncing data to disk ... ok\n\nWARNING: enabling \"trust\" authentication for local connections\nYou can change this by editing pg_hba.conf or using the option -A, or\n--auth-local and --auth-host, the next time you run initdb.\n\nSuccess. You can now start the database server using:\n\n    \/usr\/pgsql-9.6\/bin\/pg_ctl -D data\/ -l logfile start\n\npostgres@oel7:\/home\/postgres\/ [dummy] \/usr\/pgsql-9.6\/bin\/pg_ctl -D data\/ -l \/var\/tmp\/pg96.log start\nserver starting\n\npostgres@oel7:\/home\/postgres\/ [dummy] psql postgres\nNull display is \"NULL\".\nTiming is on.\npsql (9.6devel)\nType \"help\" for help.\n<\/pre>\n<p>Here we go.<\/p>\n<p>Btw: There are <a href=\"http:\/\/wiki.postgresql.org\/wiki\/Apt\" target=\"_blank\" rel=\"noopener\">apt repositories<\/a> as well, if you are on a <a href=\"http:\/\/www.debian.org\/\" target=\"_blank\" rel=\"noopener\">debian<\/a> based distribution.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Usually I advice to build PostgreSQL from source as it gives the most flexibility. Another option is to use the official yum repositories. There is one repository for each supported release of PostgreSQL and most of the common RedHat based Linux distributions are listed: CentOS, Oracle Linux, RedHat, Fedora, Scientific Linux and even Amazon Linux. [&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":[77],"type_dbi":[],"class_list":["post-6943","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","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>Using the official PostgreSQL yum repositories - 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\/using-the-official-postgresql-yum-repositories\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Using the official PostgreSQL yum repositories\" \/>\n<meta property=\"og:description\" content=\"Usually I advice to build PostgreSQL from source as it gives the most flexibility. Another option is to use the official yum repositories. There is one repository for each supported release of PostgreSQL and most of the common RedHat based Linux distributions are listed: CentOS, Oracle Linux, RedHat, Fedora, Scientific Linux and even Amazon Linux. [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/using-the-official-postgresql-yum-repositories\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2016-01-22T07:50:09+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=\"5 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\/using-the-official-postgresql-yum-repositories\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/using-the-official-postgresql-yum-repositories\/\"},\"author\":{\"name\":\"Daniel Westermann\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66\"},\"headline\":\"Using the official PostgreSQL yum repositories\",\"datePublished\":\"2016-01-22T07:50:09+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/using-the-official-postgresql-yum-repositories\/\"},\"wordCount\":209,\"commentCount\":0,\"keywords\":[\"PostgreSQL\"],\"articleSection\":[\"Database Administration &amp; Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/using-the-official-postgresql-yum-repositories\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/using-the-official-postgresql-yum-repositories\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/using-the-official-postgresql-yum-repositories\/\",\"name\":\"Using the official PostgreSQL yum repositories - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2016-01-22T07:50:09+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/using-the-official-postgresql-yum-repositories\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/using-the-official-postgresql-yum-repositories\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/using-the-official-postgresql-yum-repositories\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Using the official PostgreSQL yum repositories\"}]},{\"@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":"Using the official PostgreSQL yum repositories - 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\/using-the-official-postgresql-yum-repositories\/","og_locale":"en_US","og_type":"article","og_title":"Using the official PostgreSQL yum repositories","og_description":"Usually I advice to build PostgreSQL from source as it gives the most flexibility. Another option is to use the official yum repositories. There is one repository for each supported release of PostgreSQL and most of the common RedHat based Linux distributions are listed: CentOS, Oracle Linux, RedHat, Fedora, Scientific Linux and even Amazon Linux. [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/using-the-official-postgresql-yum-repositories\/","og_site_name":"dbi Blog","article_published_time":"2016-01-22T07:50:09+00:00","author":"Daniel Westermann","twitter_card":"summary_large_image","twitter_creator":"@westermanndanie","twitter_misc":{"Written by":"Daniel Westermann","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/using-the-official-postgresql-yum-repositories\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/using-the-official-postgresql-yum-repositories\/"},"author":{"name":"Daniel Westermann","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66"},"headline":"Using the official PostgreSQL yum repositories","datePublished":"2016-01-22T07:50:09+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/using-the-official-postgresql-yum-repositories\/"},"wordCount":209,"commentCount":0,"keywords":["PostgreSQL"],"articleSection":["Database Administration &amp; Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/using-the-official-postgresql-yum-repositories\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/using-the-official-postgresql-yum-repositories\/","url":"https:\/\/www.dbi-services.com\/blog\/using-the-official-postgresql-yum-repositories\/","name":"Using the official PostgreSQL yum repositories - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2016-01-22T07:50:09+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/using-the-official-postgresql-yum-repositories\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/using-the-official-postgresql-yum-repositories\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/using-the-official-postgresql-yum-repositories\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Using the official PostgreSQL yum repositories"}]},{"@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\/6943","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=6943"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/6943\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=6943"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=6943"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=6943"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=6943"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}