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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
