Обсуждение: attempting to install tds_fw-master on redhat
The following postgresql rpm is installed ..
rpm -qil postgresql-server-9.2.13-1.el7_1.x86_64
on redhat 7
Red Hat Enterprise Linux Server release 7.1 (Maipo)
Currently following the instructions at the following link in attempt to create the extension:
https://github.com/GeoffMontee/tds_fdw/blob/master/InstallCentOS.md
[root@scsblnx-994457 tds_fdw-master]# echo $PATH
/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin
[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'..
[root@scsblnx-994457 tds_fdw-master]#
Any ideas?
On 11/10/2015 12:53 PM, 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 > > Red Hat Enterprise Linux Server release 7.1 (Maipo) > > Currently following the instructions at the following link in attempt to > create the extension: > > https://github.com/GeoffMontee/tds_fdw/blob/master/InstallCentOS.md Look at the section in the above that says: Install PostgreSQL I would suggest following the instructions to get packages from the PGDG(PostgreSQL Global Development Group) repos as then you can run later versions of Postgres. > > [root@scsblnx-994457 tds_fdw-master]# echo $PATH > > /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin > > [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'.. > > [root@scsblnx-994457 tds_fdw-master]# > > Any ideas? > -- Adrian Klaver adrian.klaver@aklaver.com
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
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?
-----Original Message-----
From: Albe Laurenz [mailto:laurenz.albe@wien.gv.at]
Sent: Wednesday, November 11, 2015 3:53 AM
To: Mammarelli, Joanne T; pgsql-general@postgresql.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@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
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 Looks like you are using a PostgreSQL version older than 9.3. Did you check the README for the supported PostgreSQL versions? Yours, Laurenz Albe
On 11/11/2015 05:06 AM, Albe Laurenz wrote: > 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 Well the command in the instructions is: PATH=/usr/pgsql-9.4/bin:$PATH make USE_PGXS=1 substitute your Postgres version for the one above. My guess is it is looking for pg_config. You can test before building by trying from the command line: pg_config --help and if that does not work then: PATH=/usr/pgsql<version>/bin:$PATH pg_config --help >> 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 > > Looks like you are using a PostgreSQL version older than 9.3. > > Did you check the README for the supported PostgreSQL versions? Well the site: https://github.com/GeoffMontee/tds_fdw says 'This should support PostgreSQL 9.1+'. > > Yours, > Laurenz Albe > -- Adrian Klaver adrian.klaver@aklaver.com
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@wien.gv.at] > Sent: Wednesday, November 11, 2015 3:53 AM > To: Mammarelli, Joanne T; pgsql-general@postgresql.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@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@aklaver.com
On 11/11/2015 05:06 AM, Albe Laurenz wrote: > 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 > > Looks like you are using a PostgreSQL version older than 9.3. > > Did you check the README for the supported PostgreSQL versions? FYI, I filed an issue on this: https://github.com/GeoffMontee/tds_fdw/issues/43 > > Yours, > Laurenz Albe > -- Adrian Klaver adrian.klaver@aklaver.com
Hi Joanne, On Wed, Nov 11, 2015 at 4:53 AM, Mammarelli, Joanne T <joanne.t.mammarelli@verizon.com> 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? > I believe that I just committed a fix for this to tds_fdw. Can you please pull the latest commit from the tds_fdw repo and then try compiling again? Thanks, Geoff
On 11/11/2015 10:55 AM, Geoff Montee wrote: > Hi Joanne, > > On Wed, Nov 11, 2015 at 4:53 AM, Mammarelli, Joanne T > <joanne.t.mammarelli@verizon.com> 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? >> > > I believe that I just committed a fix for this to tds_fdw. Can you > please pull the latest commit from the tds_fdw repo and then try > compiling again? I can confirm it works for me on 9.2.14. psql (9.2.14) Type "help" for help. postgres@postgres=# CREATE EXTENSION tds_fdw; CREATE EXTENSION > > Thanks, > > Geoff > > -- Adrian Klaver adrian.klaver@aklaver.com