Some prerequisites are not mentioned in README

[mlromramse]

Hi I am trying to compile and install this extension on postgresql 16.

Your prerequisites doesn't mention the need for postgresql.h, gcc, make and git. Although the last three might be implied, maybe a tip on that you need these too to be able to compile mysql_fdw. (There might be non programmers out there that want to use this nice Foreign Data Wrapper :) )

Further more I installed postgresql-server-dev-16 to resolve the postgresql.h issue and managed to compile mysql_fdw. However the installcheck ended up with 9 errors of 9 possible. Does these tests need something more than what is described in your README? I entered all Env vars.

After make and make install as documented it works although the installcheck still reports errors.

Finally libmysqlclient is needed to run the mysql_fdw after compilation. Good to know in case you are preparing a Docker image.

Best regards!

Mikael Larsson

[surajkharage19]

Hi @mlromramse,

Your prerequisites doesn't mention the need for postgresql.h, gcc, make and git. Although the last three might be implied, maybe a tip on that you need these too to be able to compile mysql_fdw. (There might be non programmers out there that want to use this nice Foreign Data Wrapper :) )

I think these are common prerequisites for any postgres extension, however feel free to submit the pull request for the same.

Further more I installed postgresql-server-dev-16 to resolve the postgresql.h issue and managed to compile mysql_fdw. However the installcheck ended up with 9 errors of 9 possible. Does these tests need something more than what is described in your README? I entered all Env vars.

There is a file called mysql_init.sh in the repo and you need to run this so that all required objects get created on MySQL side. Few commands exist in this file in a comment, so you need to manually run those on MySQL for the first time.