Subject: Re: [GENERAL] $libdir/mysql_fdw
To: Ryan King - NOAA Affiliate <ryan.king@noaa.gov>,
 pgsql-general@postgresql.org, pgsql-admin@postgresql.org
References: 
 <CAJAJqWEZhd59brB4P28GQt7V-KsXLsRUnSuAGWD=COLqUS3=jg@mail.gmail.com>
From: Adrian Klaver <adrian.klaver@aklaver.com>
Message-ID: <55DF5607.5020704@aklaver.com>
Date: Thu, 27 Aug 2015 11:25:11 -0700
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101
 Thunderbird/38.2.0
MIME-Version: 1.0
In-Reply-To: 
 <CAJAJqWEZhd59brB4P28GQt7V-KsXLsRUnSuAGWD=COLqUS3=jg@mail.gmail.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

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


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin