Could not create the mysql_fdw extension in postgres in centos 8.

[surajmachamasi]

getting this issue, when creating the mysql_fdw extension.

ERROR:  could not open extension control file "/usr/pgsql-12/share/extension/mysql_fdw.control": No such file or directory
dbs=# 
dbs=# 
dbs=# create extension mysql_fdw;
ERROR:  could not open extension control file "/usr/pgsql-12/share/extension/mysql_fdw.control": No such file or directory

mysql_fdw does exists on that location.

SO file status

[surajkharage19]

Hi,

From the details, it is not clear the location of mysql_fdw.control file. Can you please make sure that mysql_fdw.control file exists at location "/usr/pgsql-12/share/extension/" with proper permissions. Also, it would be good if you could share the exact steps followed at your end to setup mysql_fdw.

[surajmachamasi]

yes it does exists in that location.

[surajmachamasi]

[surajmachamasi]

i copied the mysql_fdw.so file and mysql_fdw.control and mysql_fdw--1.1.sql file to required location and created the docker image.

[surajkharage19]

Can you please try installing mysql_fdw using source code or RPM and check if you are still getting the same issue? The steps for source code installation are mentioned in below link: https://github.com/EnterpriseDB/mysql_fdw

[surajkharage19]

Hi @surajmachamasi,

Are you still facing this issue at your end? We can help you if the issue is still there. If not then can you please close the case from your end?