mysql_fdw for postgresql version 16

From: Sri Mrudula Attili <sri(at)ebi(dot)ac(dot)uk>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: mysql_fdw for postgresql version 16
Date: 2025-02-27 15:54:06
Message-ID: d7705704-1e7b-46a5-b1d2-80edb9581547@ebi.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Benoit Lobréau 2025-02-27 16:00:05 Re: Commit with wait event on advisory lock!
Previous Message Mauricio Fernandez 2025-02-27 11:23:08 Virtuals IP running simultaneously