From: Adrian Klaver <adrian.klaver@aklaver.com>
To: Ryan King - NOAA Affiliate <ryan.king@noaa.gov>
To: pgsql-general@postgresql.org
To: pgsql-admin@postgresql.org
Subject: Re: [GENERAL] $libdir/mysql_fdw
Date: Thu, 27 Aug 2015 11:25:11 -0700
Message-ID: <55DF5607.5020704@aklaver.com> (raw)
In-Reply-To: <CAJAJqWEZhd59brB4P28GQt7V-KsXLsRUnSuAGWD=COLqUS3=jg@mail.gmail.com>
References: <CAJAJqWEZhd59brB4P28GQt7V-KsXLsRUnSuAGWD=COLqUS3=jg@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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_fdwhttp://pgxn.org/dist/mysql_fdw/>
--
Adrian Klaver
adrian.klaver@aklaver.com
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: adrian.klaver@aklaver.com, ryan.king@noaa.gov, pgsql-general@postgresql.org
Subject: Re: [GENERAL] $libdir/mysql_fdw
In-Reply-To: <55DF5607.5020704@aklaver.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox