{"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":"<p>Some time ago I blogged on how to connect your PostgreSQL instance to an Oracle instance (<a href=\"http:\/\/dbi-services.com\/blog\/connecting-your-postgresql-instance-to-an-oracle-database-the-postgresql-9-5-way\/\" target=\"_blank\" rel=\"noopener\">here<\/a> and <a href=\"http:\/\/dbi-services.com\/blog\/connecting-your-postgresql-instance-to-an-oracle-database\/\" target=\"_blank\" rel=\"noopener\">here<\/a>). In this post I&#8217;ll do the same with a MariaDB\/MySQL instance. <\/p>\n<p>For connecting PostgreSQL to MariaDB\/Mysql we&#8217;ll need <a href=\"https:\/\/github.com\/EnterpriseDB\/mysql_fdw\" target=\"_blank\" rel=\"noopener\">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<pre class=\"brush: bash; gutter: true; first-line: 1\">\npostgres@pgreporting:\/home\/postgres\/ [pg952] sudo yum install -y mariadb-libs mariadb-devel\n<\/pre>\n<p>Make sure that you have mysql_config as well as pg_config in your PATH:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">\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<p>Once you are ready it is straight forward:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">\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<p>From here on it is the usual steps. Create the extension:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">\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<p>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<pre class=\"brush: bash; gutter: true; first-line: 1\">\nMariaDB [DS2]&gt; grant all on *.* TO 'web'@'192.168.22.39' identified by \"web\";\nQuery OK, 0 rows affected (0.00 sec)\n\nMariaDB [DS2]&gt; 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<p>Once this is ready we can proceed on the PostgreSQL instance:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\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<p>If you wonder where the remote table comes from then have a look at the <a href=\"http:\/\/dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-3-mysqlmariadb\/\" target=\"_blank\" rel=\"noopener\">previous post<\/a> where the schema is setup in the MariaDB\/MySQL instance.<\/p>\n<p>Even better, as with the oracle_fdw (if you are on PostgreSQL 9.5+), you can import the foreign schema:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\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<p>One command and everything is there \ud83d\ude42<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Some time ago I blogged on how to connect your PostgreSQL instance to an Oracle instance (here and here). In this post I&#8217;ll do the same with a MariaDB\/MySQL instance. For connecting PostgreSQL to MariaDB\/Mysql we&#8217;ll need the foreign data wrapper for MySQL. As the foreign data wrapper for MySQL requires the MySQL\/MariaDB client and&hellip;&nbsp;<\/p>\n","protected":false},"author":28,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","neve_meta_reading_time":"","_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[4133],"tags":[],"class_list":["post-7677","post","type-post","status-publish","format-standard","category-database"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.8 (Yoast SEO v28.8) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Connecting your PostgreSQL instance to a MariaDB\/MySQL instance - dbi services 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&#8217;ll do the same with a MariaDB\/MySQL instance. For connecting PostgreSQL to MariaDB\/Mysql we&#8217;ll need the foreign data wrapper for MySQL. As the foreign data wrapper for MySQL requires the MySQL\/MariaDB client and&hellip;&nbsp;\" \/>\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 services Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dbiservices\/\" \/>\n<meta property=\"article:published_time\" content=\"2016-04-28T06:43:37+00:00\" \/>\n<meta name=\"author\" content=\"Open source Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:site\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Open source Team\" \/>\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\":\"Open source Team\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/0b4548362cac3eeff8b3eaf329e3530a\"},\"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,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\"},\"articleSection\":[\"Database\"],\"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 services Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"datePublished\":\"2016-04-28T06:43:37+00:00\",\"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\":\"Home\",\"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 services Blog\",\"description\":\"#BeSharing\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\"},\"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\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\",\"name\":\"dbi services\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"width\":512,\"height\":512,\"caption\":\"dbi services\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/dbiservices\\\/\",\"https:\\\/\\\/x.com\\\/dbiservices\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dbi-services\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/dbiservices\"],\"description\":\"Swiss IT consulting and services company specialized in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.\",\"email\":\"info@dbi-services.com\",\"telephone\":\"+41 32 422 96 00\",\"legalName\":\"dbi services SA\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/0b4548362cac3eeff8b3eaf329e3530a\",\"name\":\"Open source Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/open-source-author.png\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/open-source-author.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/open-source-author.png\",\"caption\":\"Open source Team\"},\"description\":\"Posts published under the Open source Team account are collective contributions by the dbi services open infrastructure consultants. The practice covers open-source databases and platforms, PostgreSQL first of all, along with MySQL, MariaDB, and Linux, from architecture, replication, and high availability to performance tuning and operations under service level agreements, and contributes actively to the PostgreSQL community.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/open-source-team\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Connecting your PostgreSQL instance to a MariaDB\/MySQL instance - dbi services 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&#8217;ll do the same with a MariaDB\/MySQL instance. For connecting PostgreSQL to MariaDB\/Mysql we&#8217;ll need the foreign data wrapper for MySQL. As the foreign data wrapper for MySQL requires the MySQL\/MariaDB client and&hellip;&nbsp;","og_url":"https:\/\/www.dbi-services.com\/blog\/connecting-your-postgresql-instance-to-a-mariadbmysql-instance\/","og_site_name":"dbi services Blog","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","article_published_time":"2016-04-28T06:43:37+00:00","author":"Open source Team","twitter_card":"summary_large_image","twitter_creator":"@dbiservices","twitter_site":"@dbiservices","twitter_misc":{"Written by":"Open source Team","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":"Open source Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0b4548362cac3eeff8b3eaf329e3530a"},"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,"publisher":{"@id":"https:\/\/www.dbi-services.com\/#organization"},"articleSection":["Database"],"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 services Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2016-04-28T06:43:37+00:00","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":"Home","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 services Blog","description":"#BeSharing","publisher":{"@id":"https:\/\/www.dbi-services.com\/#organization"},"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":"Organization","@id":"https:\/\/www.dbi-services.com\/#organization","name":"dbi services","url":"https:\/\/www.dbi-services.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","width":512,"height":512,"caption":"dbi services"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dbiservices\/","https:\/\/x.com\/dbiservices","https:\/\/www.linkedin.com\/company\/dbi-services\/","https:\/\/www.youtube.com\/user\/dbiservices"],"description":"Swiss IT consulting and services company specialized in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.","email":"info@dbi-services.com","telephone":"+41 32 422 96 00","legalName":"dbi services SA"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0b4548362cac3eeff8b3eaf329e3530a","name":"Open source Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/05\/open-source-author.png","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/05\/open-source-author.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/05\/open-source-author.png","caption":"Open source Team"},"description":"Posts published under the Open source Team account are collective contributions by the dbi services open infrastructure consultants. The practice covers open-source databases and platforms, PostgreSQL first of all, along with MySQL, MariaDB, and Linux, from architecture, replication, and high availability to performance tuning and operations under service level agreements, and contributes actively to the PostgreSQL community.","url":"https:\/\/www.dbi-services.com\/blog\/author\/open-source-team\/"}]}},"_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\/28"}],"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"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}