On 08/27/2015 10:46 AM, Ryan King - NOAA Affiliate wrote:
> When attempting to create the required functions and extensions for the
> MySQL FDW, I get the following errors:
>
> dbname=# CREATE FUNCTION mysql_fdw_handler()
> RETURNS fdw_handler
> AS '$libdir/mysql_fdw'
> LANGUAGE C STRICT;
>
> ERROR: could not access file "$libdir/mysql_fdw": No such file or directory
>
> dbname=# CREATE EXTENSION mysql_fdw;
>
> ERROR: could not open extension control file
> "/usr/pgsql-9.4/share/extension/mysql_fdw.control": No such file or
> directory
>
> What needs to be installed for this to work?
>
How did you install Postgres and/or mysql_fdw?
If from source I would say your are missing the make install step:
https://github.com/EnterpriseDB/mysql_fdw
http://pgxn.org/dist/mysql_fdw/
>
--
Adrian Klaver
adrian.klaver@aklaver.com