编译安装mysql_fdw_greenplum 6.7编译安装插件mysql_fdw

wget https://codeload.github.com/gaos1/mysql_fdw/zip/master

mv master mysql_fdw-master.zip

unzip mysql_fdw-master.zip

cd /opt/gpdb-6.7.0/contrib/

mv /opt/mysql_fdw-master .

cd /opt/gpdb-6.7.0/contrib/mysql_fdw-master

To build on POSIX-compliant systems you need to ensure the pg_config executable is in your path when you run make. This executable is typically in your PostgreSQL installation's bin directory. For example:

$ export PATH=/usr/local/greenplum-db-6.7.0/bin/:$PATH

The mysql_config must also be in the path, it resides in the MySQL bin directory.

$ export PATH=/usr/local/mysql/bin/:$PATH

Compile the code using make.

$ make USE_PGXS=1

Finally install the foreign data wrapper.

$ make USE_PGXS=1 install

[root@node1 mysql_fdw-master]# make USE_PGXS=1 install

/usr/bin/mkdir -p '/usr/local/greenplum-db-6.7.0/lib/postgresql'

/usr/bin/mkdir -p '/usr/local/greenplum-db-6.7.0/share/postgresql/extension'

/usr/bin/mkdir -p '/usr/local/greenplum-db-6.7.0/share/postgresql/extension'

/usr/bin/install -c -m 755 mysql_fdw.so '/usr/local/greenplum-db-6.7.0/lib/postgresql/mysql_fdw.so'

/usr/bin/install -c -m 644 mysql_fdw.control '/usr/local/greenplum-db-6.7.0/share/postgresql/extension/'

/usr/bin/install -c -m 644 mysql_fdw--1.0.sql mysql_fdw--1.1.sql mysql_fdw--1.0--1.1.sql '/usr/local/greenplum-db-6.7.0/share/postgresql/extension/'