On 11/11/2015 04:53 AM, Mammarelli, Joanne T wrote:
Installed postgresql-devel .. getting closer ..
Installed Packages
postgresql.x86_64 9.2.13-1.el7_1 @rhel7-x86_64-2015-07
postgresql-devel.x86_64 9.2.13-1.el7_1 @rhel-x86_64-server-7
postgresql-libs.x86_64 9.2.13-1.el7_1 @rhel7-x86_64-2015-07
postgresql-server.x86_64 9.2.13-1.el7_1 @rhel-x86_64-server-7
Installed Packages
freetds.x86_64 0.91-12.git0a42888.el7 @rhel-x86_64-server-7-epel
freetds-devel.x86_64 0.91-12.git0a42888.el7 @rhel-x86_64-server-7-epel
[root@scsblnx-994457 tds_fdw-master]# make USE_PGXS=1
gcc -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-sc
src/tds_fdw.c:30:33: fatal error: access/htup_details.h: No such file or directy
#include "access/htup_details.h"
^
compilation terminated.
make: *** [src/tds_fdw.o] Error 1
[root@scsblnx-994457 tds_fdw-master]#
Any ideas?
The above was built from a clone of the git repo, correct?
I just confirmed what Albe said, that version requires 9.3+.
If you build from the last released version 1.0.2(not 1.0.6 which is
what you get by cloning) it works on 9.2:
wget https://github.com/GeoffMontee/tds_fdw/archive/v1.0.2.tar.gz
tar -xvzf tds_fdw-1.0.2.tar.gz
cd tds_fdw-1.0.2
aklaver@panda:~/test/tds_fdw-1.0.2> PATH=/usr/local/pgsql92/bin:$PATH
make USE_PGXS=1
cp sql/tds_fdw.sql sql/tds_fdw--1.0.2.sql
cp README.md README.tds_fdw.md
gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith
-Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute
-Wformat-security -fno-strict-aliasing -fwrapv
-fexcess-precision=standard -fpic -I. -I.
-I/usr/local/pgsql92/include/server
-I/usr/local/pgsql92/include/internal -D_GNU_SOURCE -c -o
src/tds_fdw.o src/tds_fdw.c
gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith
-Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute
-Wformat-security -fno-strict-aliasing -fwrapv
-fexcess-precision=standard -fpic -shared -o tds_fdw.so src/tds_fdw.o
-L/usr/local/pgsql92/lib -Wl,--as-needed
-Wl,-rpath,'/usr/local/pgsql92/lib',--enable-new-dtags -lsybdb
aklaver@panda:~/test/tds_fdw-1.0.2> sudo
PATH=/usr/local/pgsql92/bin:$PATH make USE_PGXS=1 make install
psql (9.2.3)
Type "help" for help.
postgres=# CREATE EXTENSION tds_fdw;
CREATE EXTENSION
-----Original Message-----
From: Albe Laurenz [mailto:laurenz.albe@xxxxxxxxxx]
Sent: Wednesday, November 11, 2015 3:53 AM
To: Mammarelli, Joanne T; pgsql-general@xxxxxxxxxxxxxx
Subject: RE: attempting to install tds_fw-master on redhat
Mammarelli, Joanne T wrote:
The following postgresql rpm is installed ..
rpm -qil postgresql-server-9.2.13-1.el7_1.x86_64
on redhat 7
[root@scsblnx-994457 tds_fdw-master]# make USE_PXGS=1 install
Makefile:53: /usr/lib64/pgsql/pgxs/src/makefiles/pgxs.mk: No such file or direcy
make: *** No rule to make target `/usr/lib64/pgsql/pgxs/src/makefiles/pgxs.mk'..
Install the postgresql-devel package.
Yours,
Laurenz Albe
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
