Re: $libdir/mysql_fdw

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