Hi Devrim, I have already installed that: "Package mysql_fdw_94-2.0.1-1.rhel6.x86_64 already installed and latest version..." We're looking into some other options though. Thanks though.
Ryan King Internet Dissemination Group, Kansas City Shared Infrastructure Services Branch National Weather Service Contractor / Ace Info Solutions, Inc. On Wed, Oct 21, 2015 at 6:04 AM, Devrim GÜNDÜZ <dev...@gunduz.org> wrote: > > Hi, > > On Thu, 2015-08-27 at 12:46 -0500, Ryan King - NOAA Affiliate wrote: > > 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? > > Looks like you installed PostgreSQL using the community RPMs -- so make > sure that you used the RPM of mysql_fdw: > > yum install mysql_fdw_94 > > would do the trick. > > Regards, > -- > Devrim GÜNDÜZ > Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com > PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer > Twitter: @DevrimGunduz , @DevrimGunduzTR > > >