{"id":7677,"date":"2016-04-28T08:43:37","date_gmt":"2016-04-28T06:43:37","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/connecting-your-postgresql-instance-to-a-mariadbmysql-instance\/"},"modified":"2016-04-28T08:43:37","modified_gmt":"2016-04-28T06:43:37","slug":"connecting-your-postgresql-instance-to-a-mariadbmysql-instance","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/connecting-your-postgresql-instance-to-a-mariadbmysql-instance\/","title":{"rendered":"Connecting your PostgreSQL instance to a MariaDB\/MySQL instance"},"content":{"rendered":"

Some time ago I blogged on how to connect your PostgreSQL instance to an Oracle instance (here<\/a> and here<\/a>). In this post I’ll do the same with a MariaDB\/MySQL instance. <\/p>\n

<\/p>\n

For connecting PostgreSQL to MariaDB\/Mysql we’ll need the foreign data wrapper for MySQL<\/a>. As the foreign data wrapper for MySQL requires the MySQL\/MariaDB client and development libraries lets install these first:<\/p>\n

\npostgres@pgreporting:\/home\/postgres\/ [pg952] sudo yum install -y mariadb-libs mariadb-devel\n<\/pre>\n
Make sure that you have mysql_config as well as pg_config in your PATH:<\/p>\n
\npostgres@pgreporting:\/home\/postgres\/ [pg952] which pg_config\n\/u01\/app\/postgres\/product\/95\/db_2\/bin\/pg_config\npostgres@pgreporting:\/home\/postgres\/ [pg952] which mysql_config\n\/usr\/bin\/mysql_config\n<\/pre>\n
Once you are ready it is straight forward:<\/p>\n
\npostgres@pgreporting:\/var\/tmp\/ [pg952] unzip mysql_fdw-master.zip\npostgres@pgreporting:\/var\/tmp\/mysql_fdw-master\/ [pg952] make USE_PGXS=1\ngcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -O2 -fpic -I\/usr\/include\/mysql -D _MYSQL_LIBNAME=\"libmysqlclient.so\" -I. -I.\/ -I\/u01\/app\/postgres\/product\/95\/db_2\/include\/server -I\/u01\/app\/postgres\/product\/95\/db_2\/include\/internal -D_GNU_SOURCE -I\/usr\/include\/libxml2   -c -o connection.o connection.c\ngcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -O2 -fpic -I\/usr\/include\/mysql -D _MYSQL_LIBNAME=\"libmysqlclient.so\" -I. -I.\/ -I\/u01\/app\/postgres\/product\/95\/db_2\/include\/server -I\/u01\/app\/postgres\/product\/95\/db_2\/include\/internal -D_GNU_SOURCE -I\/usr\/include\/libxml2   -c -o option.o option.c\ngcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -O2 -fpic -I\/usr\/include\/mysql -D _MYSQL_LIBNAME=\"libmysqlclient.so\" -I. -I.\/ -I\/u01\/app\/postgres\/product\/95\/db_2\/include\/server -I\/u01\/app\/postgres\/product\/95\/db_2\/include\/internal -D_GNU_SOURCE -I\/usr\/include\/libxml2   -c -o deparse.o deparse.c\ngcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -O2 -fpic -I\/usr\/include\/mysql -D _MYSQL_LIBNAME=\"libmysqlclient.so\" -I. -I.\/ -I\/u01\/app\/postgres\/product\/95\/db_2\/include\/server -I\/u01\/app\/postgres\/product\/95\/db_2\/include\/internal -D_GNU_SOURCE -I\/usr\/include\/libxml2   -c -o mysql_query.o mysql_query.c\ngcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -O2 -fpic -I\/usr\/include\/mysql -D _MYSQL_LIBNAME=\"libmysqlclient.so\" -I. -I.\/ -I\/u01\/app\/postgres\/product\/95\/db_2\/include\/server -I\/u01\/app\/postgres\/product\/95\/db_2\/include\/internal -D_GNU_SOURCE -I\/usr\/include\/libxml2   -c -o mysql_fdw.o mysql_fdw.c\ngcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -O2 -fpic -shared -o mysql_fdw.so connection.o option.o deparse.o mysql_query.o mysql_fdw.o -L\/u01\/app\/postgres\/product\/95\/db_2\/lib -Wl,--as-needed -Wl,-rpath,'\/u01\/app\/postgres\/product\/95\/db_2\/lib',--enable-new-dtags  \npostgres@pgreporting:\/var\/tmp\/mysql_fdw-master\/ [pg952] make USE_PGXS=1 install\n\/bin\/mkdir -p '\/u01\/app\/postgres\/product\/95\/db_2\/lib'\n\/bin\/mkdir -p '\/u01\/app\/postgres\/product\/95\/db_2\/share\/extension'\n\/bin\/mkdir -p '\/u01\/app\/postgres\/product\/95\/db_2\/share\/extension'\n\/bin\/install -c -m 755  mysql_fdw.so '\/u01\/app\/postgres\/product\/95\/db_2\/lib\/mysql_fdw.so'\n\/bin\/install -c -m 644 .\/\/mysql_fdw.control '\/u01\/app\/postgres\/product\/95\/db_2\/share\/extension\/'\n\/bin\/install -c -m 644 .\/\/mysql_fdw--1.0.sql  '\/u01\/app\/postgres\/product\/95\/db_2\/share\/extension\/'\n<\/pre>\n
From here on it is the usual steps. Create the extension:<\/p>\n
\npostgres= create extension mysql_fdw;\nCREATE EXTENSION\npostgres= dx\n                            List of installed extensions\n   Name    | Version |   Schema   |                   Description                    \n-----------+---------+------------+--------------------------------------------------\n mysql_fdw | 1.0     | public     | Foreign data wrapper for querying a MySQL server\n plpgsql   | 1.0     | pg_catalog | PL\/pgSQL procedural language\n(2 rows)\n\npostgres=\n<\/pre>\n
Make sure you are allowed to connect to your MySQL instance from where your PostgreSQL runs on. In my case I did this in the MariaDB instance:<\/p>\n
\nMariaDB [DS2]> grant all on *.* TO 'web'@'192.168.22.39' identified by \"web\";\nQuery OK, 0 rows affected (0.00 sec)\n\nMariaDB [DS2]> SHOW GLOBAL VARIABLES LIKE 'PORT';\n+---------------+-------+\n| Variable_name | Value |\n+---------------+-------+\n| port          | 3306  |\n+---------------+-------+\n1 row in set (0.00 sec)\n\n<\/pre>\n
Once this is ready we can proceed on the PostgreSQL instance:<\/p>\n
\nCREATE SERVER mysql_server FOREIGN DATA WRAPPER mysql_fdw  OPTIONS (host '192.168.22.41', port '3306');\nCREATE USER MAPPING FOR postgres SERVER mysql_server OPTIONS (username 'web', password 'web');\nCREATE schema mysql;\nCREATE FOREIGN TABLE mysql.customer(\n CUSTOMERID           bigint\n,FIRSTNAME            varchar(50)\n,LASTNAME             varchar(50)\n,ADDRESS1             varchar(50)\n,ADDRESS2             varchar(50)\n,CITY                 varchar(50)\n,STATE                varchar(50)\n,ZIP                  bigint\n,COUNTRY              varchar(50)\n,REGION               int\n,EMAIL                varchar(50)\n,PHONE                varchar(50)\n,CREDITCARDTYPE       bigint   \n,CREDITCARD           varchar(50)\n,CREDITCARDEXPIRATION varchar(50)\n,USERNAME             varchar(50)\n,PASSWORD             varchar(50)\n,AGE                  int\n,INCOME               bigint\n,GENDER               varchar(1)\n)\nSERVER mysql_server\n     OPTIONS (dbname 'DS2', table_name 'CUSTOMERS');\n\npostgres= select count(*) from mysql.customer;\n count  \n--------\n 200000\n(1 row)\n\npostgres=# \n<\/pre>\n
If you wonder where the remote table comes from then have a look at the previous post<\/a> where the schema is setup in the MariaDB\/MySQL instance.<\/p>\n
Even better, as with the oracle_fdw (if you are on PostgreSQL 9.5+), you can import the foreign schema:<\/p>\n
\npostgres= import foreign schema \"DS2\" from server mysql_server into mysql;\nIMPORT FOREIGN SCHEMA\npostgres= show search_path;\n   search_path   \n-----------------\n \"$user\", public\n(1 row)\npostgres= set search_path= 'mysql';\nSET\npostgres= d\n               List of relations\n Schema |    Name    |     Type      |  Owner   \n--------+------------+---------------+----------\n mysql  | CATEGORIES | foreign table | postgres\n mysql  | CUSTOMERS  | foreign table | postgres\n mysql  | CUST_HIST  | foreign table | postgres\n mysql  | INVENTORY  | foreign table | postgres\n mysql  | ORDERLINES | foreign table | postgres\n mysql  | ORDERS     | foreign table | postgres\n mysql  | PRODUCTS   | foreign table | postgres\n mysql  | REORDER    | foreign table | postgres\n mysql  | customer   | foreign table | postgres\n(9 rows)\n\npostgres=# select count(*) from \"ORDERS\";\nINFO:  Successfully connected to MySQL database DS2 at server 192.168.22.41 via TCP\/IP with cipher  (server version: 5.5.47-MariaDB, protocol version: 10) \n count  \n--------\n 120000\n(1 row)\n<\/pre>\n
One command and everything is there \ud83d\ude42<\/p>\n","protected":false},"excerpt":{"rendered":"
Some time ago I blogged on how to connect your PostgreSQL instance to an Oracle instance (here and here). In this post I’ll do the same with a MariaDB\/MySQL instance.<\/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-7677","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","tag-postgresql"],"acf":[],"yoast_head":"\nConnecting your PostgreSQL instance to a MariaDB\/MySQL instance - 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\/connecting-your-postgresql-instance-to-a-mariadbmysql-instance\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Connecting your PostgreSQL instance to a MariaDB\/MySQL instance\" \/>\n<meta property=\"og:description\" content=\"Some time ago I blogged on how to connect your PostgreSQL instance to an Oracle instance (here and here). In this post I’ll do the same with a MariaDB\/MySQL instance.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/connecting-your-postgresql-instance-to-a-mariadbmysql-instance\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2016-04-28T06:43:37+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\/connecting-your-postgresql-instance-to-a-mariadbmysql-instance\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/connecting-your-postgresql-instance-to-a-mariadbmysql-instance\/\"},\"author\":{\"name\":\"Daniel Westermann\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66\"},\"headline\":\"Connecting your PostgreSQL instance to a MariaDB\/MySQL instance\",\"datePublished\":\"2016-04-28T06:43:37+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/connecting-your-postgresql-instance-to-a-mariadbmysql-instance\/\"},\"wordCount\":198,\"commentCount\":0,\"keywords\":[\"PostgreSQL\"],\"articleSection\":[\"Database Administration & Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/connecting-your-postgresql-instance-to-a-mariadbmysql-instance\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/connecting-your-postgresql-instance-to-a-mariadbmysql-instance\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/connecting-your-postgresql-instance-to-a-mariadbmysql-instance\/\",\"name\":\"Connecting your PostgreSQL instance to a MariaDB\/MySQL instance - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2016-04-28T06:43:37+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/connecting-your-postgresql-instance-to-a-mariadbmysql-instance\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/connecting-your-postgresql-instance-to-a-mariadbmysql-instance\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/connecting-your-postgresql-instance-to-a-mariadbmysql-instance\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Connecting your PostgreSQL instance to a MariaDB\/MySQL instance\"}]},{\"@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":"Connecting your PostgreSQL instance to a MariaDB\/MySQL instance - 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\/connecting-your-postgresql-instance-to-a-mariadbmysql-instance\/","og_locale":"en_US","og_type":"article","og_title":"Connecting your PostgreSQL instance to a MariaDB\/MySQL instance","og_description":"Some time ago I blogged on how to connect your PostgreSQL instance to an Oracle instance (here and here). In this post I’ll do the same with a MariaDB\/MySQL instance.","og_url":"https:\/\/www.dbi-services.com\/blog\/connecting-your-postgresql-instance-to-a-mariadbmysql-instance\/","og_site_name":"dbi Blog","article_published_time":"2016-04-28T06:43:37+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\/connecting-your-postgresql-instance-to-a-mariadbmysql-instance\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/connecting-your-postgresql-instance-to-a-mariadbmysql-instance\/"},"author":{"name":"Daniel Westermann","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66"},"headline":"Connecting your PostgreSQL instance to a MariaDB\/MySQL instance","datePublished":"2016-04-28T06:43:37+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/connecting-your-postgresql-instance-to-a-mariadbmysql-instance\/"},"wordCount":198,"commentCount":0,"keywords":["PostgreSQL"],"articleSection":["Database Administration & Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/connecting-your-postgresql-instance-to-a-mariadbmysql-instance\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/connecting-your-postgresql-instance-to-a-mariadbmysql-instance\/","url":"https:\/\/www.dbi-services.com\/blog\/connecting-your-postgresql-instance-to-a-mariadbmysql-instance\/","name":"Connecting your PostgreSQL instance to a MariaDB\/MySQL instance - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2016-04-28T06:43:37+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/connecting-your-postgresql-instance-to-a-mariadbmysql-instance\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/connecting-your-postgresql-instance-to-a-mariadbmysql-instance\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/connecting-your-postgresql-instance-to-a-mariadbmysql-instance\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Connecting your PostgreSQL instance to a MariaDB\/MySQL instance"}]},{"@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\/7677","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=7677"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/7677\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=7677"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=7677"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=7677"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=7677"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}