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@xxxxxxxxxxx -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
