attempting to install tds_fw-master on redhat

Started by Mammarelli, Joanne Tover 10 years ago10 messagesgeneral

Jump to latest

Mammarelli, Joanne T

joanne.t.mammarelli@verizon.com

over 10 years ago

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?

Adrian Klaver

adrian.klaver@aklaver.com

over 10 years ago

In reply to: Mammarelli, Joanne T (#1)

Re: attempting to install tds_fw-master on redhat

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Laurenz Albe

laurenz.albe@cybertec.at

over 10 years ago

In reply to: Mammarelli, Joanne T (#1)

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Mammarelli, Joanne T

joanne.t.mammarelli@verizon.com

over 10 years ago

In reply to: Laurenz Albe (#3)

Re: attempting to install tds_fw-master on redhat

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Laurenz Albe

laurenz.albe@cybertec.at

over 10 years ago

In reply to: Mammarelli, Joanne T (#4)

Re: attempting to install tds_fw-master on redhat

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Adrian Klaver

adrian.klaver@aklaver.com

over 10 years ago

In reply to: Laurenz Albe (#5)

Re: attempting to install tds_fw-master on redhat

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Adrian Klaver

adrian.klaver@aklaver.com

over 10 years ago

In reply to: Mammarelli, Joanne T (#4)

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@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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Adrian Klaver

adrian.klaver@aklaver.com

over 10 years ago

In reply to: Laurenz Albe (#5)

Re: attempting to install tds_fw-master on redhat

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Geoff Montee

geoff.montee@gmail.com

over 10 years ago

In reply to: Mammarelli, Joanne T (#4)

Re: attempting to install tds_fw-master on redhat

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

#10

Adrian Klaver

adrian.klaver@aklaver.com

over 10 years ago

In reply to: Geoff Montee (#9)

Re: attempting to install tds_fw-master on redhat

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general