Issue with jdbc_fdw on Postgres 9.5

I have recently installed Postgres 9.5 on CentOS 7.
I would like to connect this instance to an Hadoop cluster where data is
managed by Phoenix (over hBase).
My idea was to establish a link between Postgres and Phoenix thanks to
jdbc_fdw.

However, when I compiled the jdbc_fdw, it didn't put the things in the right
place.

I realized this when trying to create jdbc_fdw Extension.
Postgres will look for "/usr/pgsql-9.5/share/extension/jdbc_fdw.control"
while the file has been copied into /usr/share/pgsql/extension.
With fixing this, I realized that this file contained
module_pathname=$libdir/jdbc_fdw.so while it had been installed in
$pkglibdir.
After fixing this, I still get an error when trying to create the extension
:

ERROR: invalid macro name in dynamic library path: $pkglibdir/jdbc_fdw
SQL state: 42602

I was wondering if jdbc_fdw was compatible with recent Postgres releases and
it there was another way to address my Phoenix database.

Thanks,
Patrick

--
View this message in context: http://postgresql.nabble.com/Issue-with-jdbc-fdw-on-Postgres-9-5-tp5884217.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.