search

EnterpriseDB / mysql_fdw

PostgreSQL foreign data wrapper for MySQL
Other
523 stars 161 forks source link

Postgres 11 support #169

Closed SteelBlueVision closed 5 years ago

SteelBlueVision commented 5 years ago

I am using PG 11 Beta 2. Does the MySQL FDW work with PG 11?

df7cb commented 5 years ago

At the moment it does not:

postgresql-mysql-fdw/Makefile:52: *** PostgreSQL 9.3, 9.4, 9.5, 9.6 or 10beta is required to compile this extension.

Is this extension still maintained? It seems pretty neglected.

robertmhaas commented 5 years ago

This issue was just resolved by mithuncy.

slava-pagerduty commented 5 years ago

it still installs under /usr/share/postgresql/10/ even though I have pg 11. I don't have postgres 10. using ubuntu 18.04

df7cb commented 5 years ago

@slava-pagerduty: if you are compiling from source, you need PG11's pg_config. Run pg_config to check. Otherwise, install the package for PG11, postgresql-11-mysql-fdw on Debian.

slava-pagerduty commented 5 years ago

Thank you @ChristophBerg , that indeed was an issue. I have re-installed postgresql-server-dev-11 and mysql_fdw compiled just fine. The debian package always worked, but I need my source code patch to resolve issue (https://github.com/EnterpriseDB/mysql_fdw/issues/154), so had to compile source. Thanks again for your help and hope issue for binary type will get into repo at some point.