Re: attempting to install tds_fw-master on redhat

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(at)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(at)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(at)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(at)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(dot)albe(at)wien(dot)gv(dot)at]
> Sent: Wednesday, November 11, 2015 3:53 AM
> To: Mammarelli, Joanne T; pgsql-general(at)postgresql(dot)org
> 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(at)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(dot)klaver(at)aklaver(dot)com