mysql_fdw for postgresql version 16 - Mailing list pgsql-admin

From Sri Mrudula Attili
Subject mysql_fdw for postgresql version 16
Date
Msg-id d7705704-1e7b-46a5-b1d2-80edb9581547@ebi.ac.uk
Whole thread Raw
Responses Re: mysql_fdw for postgresql version 16
List pgsql-admin

Hello All,


 I am looking for a mysql foreign data wrapper in our postgresql v16 environment.

 We have a mysql database and postgresql database that needs to read and write data to.

 So while going through the reliable mysql_fdw I came across the below


https://docs.opengauss.org/en/docs/5.0.0-lite/docs/DatabaseAdministrationGuide/mysql_fdw.html

https://github.com/EnterpriseDB/mysql_fdw


I wanted to go ahead with the EDB provided extension, but while reading the guide it says "supported database versions - EPAS 16"

Does that mean it can only be used with the EDB provided postgresql versions and not the standard PGDG ones?


Where as the opengauss one says "To compile and use mysql_fdw, the MariaDB development packages must be included in the environment. "

We are not using MariaDB so I am confused to go with which one, please advise.


Thanks,

Sri Attili

pgsql-admin by date:

Previous
From: Mauricio Fernandez
Date:
Subject: Virtuals IP running simultaneously
Next
From: Benoit Lobréau
Date:
Subject: Re: Commit with wait event on advisory lock!