From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Ryan King - NOAA Affiliate <ryan(dot)king(at)noaa(dot)gov>, pgsql-general(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: [GENERAL] $libdir/mysql_fdw |
Date: | 2015-08-27 18:25:11 |
Message-ID: | 55DF5607.5020704@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
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(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Nima Azizzadeh | 2015-08-28 14:29:25 | Define two factor authentication for Postgresql Server |
Previous Message | Ryan King - NOAA Affiliate | 2015-08-27 17:46:26 | $libdir/mysql_fdw |
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2015-08-27 20:30:15 | Unusual psql behavior |
Previous Message | Jerry Sievers | 2015-08-27 18:21:20 | Re: UPDATE an updatable view |