tds_fdw >> Install Foreign data Wrapper on EDB Postgres to connect to SQL server database - Mailing list pgsql-general

Installation of Foreign data Wrapper on EDB Postgres to connect to SQL server database is not working.

https://github.com/tds-fdw/tds_fdw/issues/357

Please advise if this has been encountered or a workaround is available.

OS:

NAME="Oracle Linux Server"

VERSION="7.9"

ID="ol"

ID_LIKE="fedora"

VARIANT="Server"

VARIANT_ID="server"

VERSION_ID="7.9"

PRETTY_NAME="Oracle Linux Server 7.9"

ANSI_COLOR="0;31"

CPE_NAME="cpe:/o:oracle:linux:7:9:server"

HOME_URL=https://linux.oracle.com/

BUG_REPORT_URL=https://github.com/oracle/oracle-linux

ORACLE_BUGZILLA_PRODUCT="Oracle Linux 7"

ORACLE_BUGZILLA_PRODUCT_VERSION=7.9

ORACLE_SUPPORT_PRODUCT="Oracle Linux"

ORACLE_SUPPORT_PRODUCT_VERSION=7.9

Version of tds_fdw:

postgres=# \dx

                                  List of installed extensions

       Name       | Version |   Schema   |                     Description

------------------+---------+------------+------------------------------------------------------

 edb_dblink_libpq | 1.0     | pg_catalog | EnterpriseDB Foreign Data Wrapper for PostgreSQL

 edb_dblink_oci   | 1.0     | pg_catalog | EnterpriseDB Foreign Data Wrapper for Oracle

 edbspl           | 1.0     | pg_catalog | EDB-SPL procedural language

 pldbgapi         | 1.1     | pg_catalog | server-side support for debugging PL/pgSQL functions

 plpgsql          | 1.0     | pg_catalog | PL/pgSQL procedural language

(5 rows)

PostgreSQL Version:

postgres=# SELECT version();

                                                                     version

--------------------------------------------------------------------------------------------------------------------------------------------------

 PostgreSQL 13.13 (EnterpriseDB Advanced Server 13.13.19) on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-44), 64-bit

(1 row)

Issue Details:

tds_fdw install steps performed:

yum install install edb-as13-server edb-as13-server-libs edb-as13-server-devel

yum install -y gcc make wget epel-release freetds freetds-devel 

dnf install redhat-rpm-config

subscription-manager repos --enable rhel-7-server-optional-rpms \

    --enable rhel-server-rhscl-7-rpms \

    --enable rhel-7-server-devtools-rpms

yum install llvm-toolset-7-clang-analyzer llvm-toolset-7-clang-tools-extra llvm-toolset-7 llvm-toolset-7-clang llvm-toolset-7-clang-libs  llvm-toolset-7-llvm-libs

export TDS_FDW_VERSION="2.0.3" 

wget https://github.com/tds-fdw/tds_fdw/archive/refs/tags/v2.0.3.tar.gz -O tds_fdw-${TDS_FDW_VERSION}.tar.gz 

tar -xvzf tds_fdw-${TDS_FDW_VERSION}.tar.gz 

cd tds_fdw-${TDS_FDW_VERSION} 

PATH=/usr/edb/as13/bin:$PATH 

make USE_PGXS=1 

PATH=/usr/edb/as13/bin:$PATH 

make USE_PGXS=1 install

Logs:

[root@hostip ~]# yum install install edb-as13-server edb-as13-server-libs edb-as13-server-devel\

Loaded plugins: rhnplugin\

This system is not registered with Spacewalk server.\

You can use rhn_register to register.\

Spacewalk support will be disabled.\

Repository mc-ol7-base-x86_64 is listed more than once in the configuration\

Repository mc-ol7-layered-x86_64 is listed more than once in the configuration\

Repository mc-ol7_tsm-8.1.13_x86_64 is listed more than once in the configuration\

Repository mc-ol7-chef_client_15-x86_64 is listed more than once in the configuration\

No package install available.\

Package edb-as13-server-13.13.19-1.el7.x86_64 already installed and latest version\

Package edb-as13-server-libs-13.13.19-1.el7.x86_64 already installed and latest version\

Package edb-as13-server-devel-13.13.19-1.el7.x86_64 already installed and latest version\

Nothing to do\

[root@hostip ~]#\

[root@hostip ~]# yum install -y gcc make wget epel-release freetds freetds-devel\

Loaded plugins: rhnplugin\

This system is not registered with Spacewalk server.\

You can use rhn_register to register.\

Spacewalk support will be disabled.\

Repository mc-ol7-base-x86_64 is listed more than once in the configuration\

Repository mc-ol7-layered-x86_64 is listed more than once in the configuration\

Repository mc-ol7_tsm-8.1.13_x86_64 is listed more than once in the configuration\

Repository mc-ol7-chef_client_15-x86_64 is listed more than once in the configuration\

Package gcc-4.8.5-44.0.3.el7.x86_64 already installed and latest version\

Package 1:make-3.82-24.el7.x86_64 already installed and latest version\

Package wget-1.14-18.el7_6.1.x86_64 already installed and latest version\

Package epel-release-7-14.noarch already installed and latest version\

Package freetds-1.3.3-1.el7.x86_64 already installed and latest version\

Package freetds-devel-1.3.3-1.el7.x86_64 already installed and latest version\

Nothing to do\

[root@hostip ~]#\

[root@hostip ~]# dnf install redhat-rpm-config\

-bash: dnf: command not found\

[root@hostip ~]#\

[root@hostip ~]# subscription-manager repos --enable rhel-7-server-optional-rpms \ --enable rhel-server-rhscl-7-rpms \ --enable rhel-7-server-devtools-rpms\

-bash: subscription-manager: command not found\

[root@hostip ~]#\

[root@hostip ~]#\

[root@hostip ~]# yum install llvm-toolset-7-clang-analyzer llvm-toolset-7-clang-tools-extra llvm-toolset-7 llvm-toolset-7-clang llvm-toolset-7-clang-libs llvm-toolset-7-llvm-libs\

Loaded plugins: rhnplugin\

This system is not registered with Spacewalk server.\

You can use rhn_register to register.\

Spacewalk support will be disabled.\

Repository mc-ol7-base-x86_64 is listed more than once in the configuration\

Repository mc-ol7-layered-x86_64 is listed more than once in the configuration\

Repository mc-ol7_tsm-8.1.13_x86_64 is listed more than once in the configuration\

Repository mc-ol7-chef_client_15-x86_64 is listed more than once in the configuration\

**No package llvm-toolset-7-clang-analyzer available.\

No package llvm-toolset-7-clang-tools-extra available.\

No package llvm-toolset-7 available.\

No package llvm-toolset-7-clang available.\

No package llvm-toolset-7-clang-libs available.\

No package llvm-toolset-7-llvm-libs available.\**

Error: Nothing to do\

[root@hostip ~]#\

[root@hostip ~]#

[root@hostip ~]#

[root@hostip ~]# export TDS_FDW_VERSION="2.0.3"

[root@hostip ~]# wget https://github.com/tds-fdw/tds_fdw/archive/refs/tags/v2.0.3.tar.gz -O tds_fdw-${TDS_FDW_VERSION}.tar.gz

--2024-05-28 15:44:39--  https://github.com/tds-fdw/tds_fdw/archive/refs/tags/v2.0.3.tar.gz

Resolving github.com (github.com)... 140.82.112.4

Connecting to github.com (github.com)|140.82.112.4|:443... connected.

HTTP request sent, awaiting response... 302 Found

Location: https://codeload.github.com/tds-fdw/tds_fdw/tar.gz/refs/tags/v2.0.3 [following]

--2024-05-28 15:44:39--  https://codeload.github.com/tds-fdw/tds_fdw/tar.gz/refs/tags/v2.0.3

Resolving codeload.github.com (codeload.github.com)... 140.82.113.10

Connecting to codeload.github.com (codeload.github.com)|140.82.113.10|:443... connected.

HTTP request sent, awaiting response... 200 OK

Length: unspecified [application/x-gzip]

Saving to: ‘tds_fdw-2.0.3.tar.gz’

    [ <=>                                                                                                                                                                                                                ] 72,527      --.-K/s   in 0.05s

2024-05-28 15:44:39 (1.50 MB/s) - ‘tds_fdw-2.0.3.tar.gz’ saved [72527]

[root@hostip ~]#

[root@hostip ~]# tar -xvzf tds_fdw-${TDS_FDW_VERSION}.tar.gz

tds_fdw-2.0.3/

tds_fdw-2.0.3/.gitattributes

tds_fdw-2.0.3/.github/

tds_fdw-2.0.3/.github/ISSUE_TEMPLATE.md

tds_fdw-2.0.3/.gitignore

tds_fdw-2.0.3/ForeignSchemaImporting.md

tds_fdw-2.0.3/ForeignServerCreation.md

tds_fdw-2.0.3/ForeignTableCreation.md

tds_fdw-2.0.3/InstallAlpine.md

tds_fdw-2.0.3/InstallDebian.md

tds_fdw-2.0.3/InstallOSX.md

tds_fdw-2.0.3/InstallRHELandClones.md

tds_fdw-2.0.3/InstallUbuntu.md

tds_fdw-2.0.3/InstallopenSUSE.md

tds_fdw-2.0.3/LICENSE

tds_fdw-2.0.3/META.json

tds_fdw-2.0.3/Makefile

tds_fdw-2.0.3/README.md

tds_fdw-2.0.3/UserMappingCreation.md

tds_fdw-2.0.3/Variables.md

tds_fdw-2.0.3/include/

tds_fdw-2.0.3/include/deparse.h

tds_fdw-2.0.3/include/options.h

tds_fdw-2.0.3/include/tds_fdw.h

tds_fdw-2.0.3/include/visibility.h

tds_fdw-2.0.3/logo/

tds_fdw-2.0.3/logo/tds_fdw.svg

tds_fdw-2.0.3/sql/

tds_fdw-2.0.3/sql/tds_fdw.sql

tds_fdw-2.0.3/src/

tds_fdw-2.0.3/src/deparse.c

tds_fdw-2.0.3/src/options.c

tds_fdw-2.0.3/src/tds_fdw.c

tds_fdw-2.0.3/tds_fdw.control

tds_fdw-2.0.3/tests/

tds_fdw-2.0.3/tests/.gitignore

tds_fdw-2.0.3/tests/README.md

tds_fdw-2.0.3/tests/lib/

tds_fdw-2.0.3/tests/lib/__init__.py

tds_fdw-2.0.3/tests/lib/messages.py

tds_fdw-2.0.3/tests/lib/tests.py

tds_fdw-2.0.3/tests/mssql-tests.py

tds_fdw-2.0.3/tests/postgresql-tests.py

tds_fdw-2.0.3/tests/tests/

tds_fdw-2.0.3/tests/tests/mssql/

tds_fdw-2.0.3/tests/tests/mssql/000_create_schema.json

tds_fdw-2.0.3/tests/tests/mssql/000_create_schema.sql

tds_fdw-2.0.3/tests/tests/mssql/001_create_tinyint_min_table.json

tds_fdw-2.0.3/tests/tests/mssql/001_create_tinyint_min_table.sql

tds_fdw-2.0.3/tests/tests/mssql/002_create_tinyint_max_table.json

tds_fdw-2.0.3/tests/tests/mssql/002_create_tinyint_max_table.sql

tds_fdw-2.0.3/tests/tests/mssql/003_create_smallint_min_table.json

tds_fdw-2.0.3/tests/tests/mssql/003_create_smallint_min_table.sql

tds_fdw-2.0.3/tests/tests/mssql/004_create_smallint_max_table.json

tds_fdw-2.0.3/tests/tests/mssql/004_create_smallint_max_table.sql

tds_fdw-2.0.3/tests/tests/mssql/005_create_int_min_table.json

tds_fdw-2.0.3/tests/tests/mssql/005_create_int_min_table.sql

tds_fdw-2.0.3/tests/tests/mssql/006_create_int_max_table.json

tds_fdw-2.0.3/tests/tests/mssql/006_create_int_max_table.sql

tds_fdw-2.0.3/tests/tests/mssql/007_create_bigint_min_table.json

tds_fdw-2.0.3/tests/tests/mssql/007_create_bigint_min_table.sql

tds_fdw-2.0.3/tests/tests/mssql/008_create_bigint_max_table.json

tds_fdw-2.0.3/tests/tests/mssql/008_create_bigint_max_table.sql

tds_fdw-2.0.3/tests/tests/mssql/009_create_decimal_table.json

tds_fdw-2.0.3/tests/tests/mssql/009_create_decimal_table.sql

tds_fdw-2.0.3/tests/tests/mssql/010_create_float4_table.json

tds_fdw-2.0.3/tests/tests/mssql/010_create_float4_table.sql

tds_fdw-2.0.3/tests/tests/mssql/011_create_float8_table.json

tds_fdw-2.0.3/tests/tests/mssql/011_create_float8_table.sql

tds_fdw-2.0.3/tests/tests/mssql/012_create_date_table.json

tds_fdw-2.0.3/tests/tests/mssql/012_create_date_table.sql

tds_fdw-2.0.3/tests/tests/mssql/013_create_time_table.json

tds_fdw-2.0.3/tests/tests/mssql/013_create_time_table.sql

tds_fdw-2.0.3/tests/tests/mssql/014_create_datetime_table.json

tds_fdw-2.0.3/tests/tests/mssql/014_create_datetime_table.sql

tds_fdw-2.0.3/tests/tests/mssql/015_create_datetime2_table.json

tds_fdw-2.0.3/tests/tests/mssql/015_create_datetime2_table.sql

tds_fdw-2.0.3/tests/tests/mssql/016_create_datetimeoffset_table.json

tds_fdw-2.0.3/tests/tests/mssql/016_create_datetimeoffset_table.sql

tds_fdw-2.0.3/tests/tests/mssql/017_create_char_table.json

tds_fdw-2.0.3/tests/tests/mssql/017_create_char_table.sql

tds_fdw-2.0.3/tests/tests/mssql/018_create_varchar_table.json

tds_fdw-2.0.3/tests/tests/mssql/018_create_varchar_table.sql

tds_fdw-2.0.3/tests/tests/mssql/019_create_varcharmax_table.json

tds_fdw-2.0.3/tests/tests/mssql/019_create_varcharmax_table.sql

tds_fdw-2.0.3/tests/tests/mssql/020_create_binary4_table.json

tds_fdw-2.0.3/tests/tests/mssql/020_create_binary4_table.sql

tds_fdw-2.0.3/tests/tests/mssql/021_create_varbinary4_table.json

tds_fdw-2.0.3/tests/tests/mssql/021_create_varbinary4_table.sql

tds_fdw-2.0.3/tests/tests/mssql/022_create_varbinarymax_table.json

tds_fdw-2.0.3/tests/tests/mssql/022_create_varbinarymax_table.sql

tds_fdw-2.0.3/tests/tests/mssql/023_create_null_datetime_table.json

tds_fdw-2.0.3/tests/tests/mssql/023_create_null_datetime_table.sql

tds_fdw-2.0.3/tests/tests/mssql/024_create_null_datetime2_table.json

tds_fdw-2.0.3/tests/tests/mssql/024_create_null_datetime2_table.sql

tds_fdw-2.0.3/tests/tests/mssql/025_create_match_column_table.json

tds_fdw-2.0.3/tests/tests/mssql/025_create_match_column_table.sql

tds_fdw-2.0.3/tests/tests/mssql/026_create_column_name_table.json

tds_fdw-2.0.3/tests/tests/mssql/026_create_column_name_table.sql

tds_fdw-2.0.3/tests/tests/mssql/027_create_query_option_table.json

tds_fdw-2.0.3/tests/tests/mssql/027_create_query_option_table.sql

tds_fdw-2.0.3/tests/tests/mssql/028_create_view_simple_prerequisites.json

tds_fdw-2.0.3/tests/tests/mssql/028_create_view_simple_prerequisites.sql

tds_fdw-2.0.3/tests/tests/mssql/029_create_view_simple.json

tds_fdw-2.0.3/tests/tests/mssql/029_create_view_simple.sql

tds_fdw-2.0.3/tests/tests/postgresql/

tds_fdw-2.0.3/tests/tests/postgresql/000_create_schema.json

tds_fdw-2.0.3/tests/tests/postgresql/000_create_schema.sql

tds_fdw-2.0.3/tests/tests/postgresql/001_create_server.json

tds_fdw-2.0.3/tests/tests/postgresql/001_create_server.sql

tds_fdw-2.0.3/tests/tests/postgresql/002_create_user_mapping.json

tds_fdw-2.0.3/tests/tests/postgresql/002_create_user_mapping.sql

tds_fdw-2.0.3/tests/tests/postgresql/003_import_schema.json

tds_fdw-2.0.3/tests/tests/postgresql/003_import_schema.sql

tds_fdw-2.0.3/tests/tests/postgresql/004_tinyintmin.json

tds_fdw-2.0.3/tests/tests/postgresql/004_tinyintmin.sql

tds_fdw-2.0.3/tests/tests/postgresql/005_tinyintmax.json

tds_fdw-2.0.3/tests/tests/postgresql/005_tinyintmax.sql

tds_fdw-2.0.3/tests/tests/postgresql/006_smallintmin.json

tds_fdw-2.0.3/tests/tests/postgresql/006_smallintmin.sql

tds_fdw-2.0.3/tests/tests/postgresql/007_smallintmax.json

tds_fdw-2.0.3/tests/tests/postgresql/007_smallintmax.sql

tds_fdw-2.0.3/tests/tests/postgresql/008_intmin.json

tds_fdw-2.0.3/tests/tests/postgresql/008_intmin.sql

tds_fdw-2.0.3/tests/tests/postgresql/009_intmax.json

tds_fdw-2.0.3/tests/tests/postgresql/009_intmax.sql

tds_fdw-2.0.3/tests/tests/postgresql/010_bigintmin.json

tds_fdw-2.0.3/tests/tests/postgresql/010_bigintmin.sql

tds_fdw-2.0.3/tests/tests/postgresql/011_bigintmax.json

tds_fdw-2.0.3/tests/tests/postgresql/011_bigintmax.sql

tds_fdw-2.0.3/tests/tests/postgresql/012_decimal.json

tds_fdw-2.0.3/tests/tests/postgresql/012_decimal.sql

tds_fdw-2.0.3/tests/tests/postgresql/013_float4.json

tds_fdw-2.0.3/tests/tests/postgresql/013_float4.sql

tds_fdw-2.0.3/tests/tests/postgresql/014_float8.json

tds_fdw-2.0.3/tests/tests/postgresql/014_float8.sql

tds_fdw-2.0.3/tests/tests/postgresql/015_date.json

tds_fdw-2.0.3/tests/tests/postgresql/015_date.sql

tds_fdw-2.0.3/tests/tests/postgresql/016_time.json

tds_fdw-2.0.3/tests/tests/postgresql/016_time.sql

tds_fdw-2.0.3/tests/tests/postgresql/017_datetime.json

tds_fdw-2.0.3/tests/tests/postgresql/017_datetime.sql

tds_fdw-2.0.3/tests/tests/postgresql/018_datetime2.json

tds_fdw-2.0.3/tests/tests/postgresql/018_datetime2.sql

tds_fdw-2.0.3/tests/tests/postgresql/019_datetimeoffset.json

tds_fdw-2.0.3/tests/tests/postgresql/019_datetimeoffset.sql

tds_fdw-2.0.3/tests/tests/postgresql/020_char.json

tds_fdw-2.0.3/tests/tests/postgresql/020_char.sql

tds_fdw-2.0.3/tests/tests/postgresql/021_varchar.json

tds_fdw-2.0.3/tests/tests/postgresql/021_varchar.sql

tds_fdw-2.0.3/tests/tests/postgresql/022_varcharmax.json

tds_fdw-2.0.3/tests/tests/postgresql/022_varcharmax.sql

tds_fdw-2.0.3/tests/tests/postgresql/023_binary4.json

tds_fdw-2.0.3/tests/tests/postgresql/023_binary4.sql

tds_fdw-2.0.3/tests/tests/postgresql/024_varbinary4.json

tds_fdw-2.0.3/tests/tests/postgresql/024_varbinary4.sql

tds_fdw-2.0.3/tests/tests/postgresql/025_varbinarymax.json

tds_fdw-2.0.3/tests/tests/postgresql/025_varbinarymax.sql

tds_fdw-2.0.3/tests/tests/postgresql/026_null_datetime.json

tds_fdw-2.0.3/tests/tests/postgresql/026_null_datetime.sql

tds_fdw-2.0.3/tests/tests/postgresql/027_null_datetime2.json

tds_fdw-2.0.3/tests/tests/postgresql/027_null_datetime2.sql

tds_fdw-2.0.3/tests/tests/postgresql/028_column_match_enabled.json

tds_fdw-2.0.3/tests/tests/postgresql/028_column_match_enabled.sql

tds_fdw-2.0.3/tests/tests/postgresql/029_column_match_disabled.json

tds_fdw-2.0.3/tests/tests/postgresql/029_column_match_disabled.sql

tds_fdw-2.0.3/tests/tests/postgresql/030_column_name.json

tds_fdw-2.0.3/tests/tests/postgresql/030_column_name.sql

tds_fdw-2.0.3/tests/tests/postgresql/031_query_option_column_match_enabled.json

tds_fdw-2.0.3/tests/tests/postgresql/031_query_option_column_match_enabled.sql

tds_fdw-2.0.3/tests/tests/postgresql/032_query_option_column_match_disabled.json

tds_fdw-2.0.3/tests/tests/postgresql/032_query_option_column_match_disabled.sql

tds_fdw-2.0.3/tests/tests/postgresql/033_view_simple.json

tds_fdw-2.0.3/tests/tests/postgresql/033_view_simple.sql

tds_fdw-2.0.3/tests/tests/postgresql/034_explain.json

tds_fdw-2.0.3/tests/tests/postgresql/034_explain.sql

tds_fdw-2.0.3/tests/tests/postgresql/035_rescan.json

tds_fdw-2.0.3/tests/tests/postgresql/035_rescan.sql

tds_fdw-2.0.3/tests/validate-test-json

[root@hostip ~]#

[root@hostip ~]# cd tds_fdw-${TDS_FDW_VERSION}

[root@hostip tds_fdw-2.0.3]#

[root@hostip tds_fdw-2.0.3]# PATH=/usr/edb/as13/bin:$PATH

[root@hostip tds_fdw-2.0.3]#

[root@hostip tds_fdw-2.0.3]# make USE_PGXS=1

gcc -std=gnu99 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -I/usr/libexec/edb-icu66/include/ -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches   -m64 -mtune=generic -fPIC -I./include/ -fvisibility=hidden  -I. -I./ -I/usr/edb/as13/include/server -I/usr/edb/as13/include/internal -I/usr/libexec/edb-icu66/include/ -D_GNU_SOURCE -I/usr/include/libxml2  -I/usr/include  -c -o src/tds_fdw.o src/tds_fdw.c

gcc -std=gnu99 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -I/usr/libexec/edb-icu66/include/ -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches   -m64 -mtune=generic -fPIC -I./include/ -fvisibility=hidden  -I. -I./ -I/usr/edb/as13/include/server -I/usr/edb/as13/include/internal -I/usr/libexec/edb-icu66/include/ -D_GNU_SOURCE -I/usr/include/libxml2  -I/usr/include  -c -o src/options.o src/options.c

gcc -std=gnu99 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -I/usr/libexec/edb-icu66/include/ -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches   -m64 -mtune=generic -fPIC -I./include/ -fvisibility=hidden  -I. -I./ -I/usr/edb/as13/include/server -I/usr/edb/as13/include/internal -I/usr/libexec/edb-icu66/include/ -D_GNU_SOURCE -I/usr/include/libxml2  -I/usr/include  -c -o src/deparse.o src/deparse.c

gcc -std=gnu99 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -I/usr/libexec/edb-icu66/include/ -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches   -m64 -mtune=generic -fPIC -shared -o tds_fdw.so src/tds_fdw.o src/options.o src/deparse.o -L/usr/edb/as13/lib  -L/usr/libexec/edb-icu66/lib/  -L/usr/lib64/llvm5.0/lib  -L/usr/lib64 -Wl,--as-needed -Wl,-rpath,'/usr/edb/as13/lib',--enable-new-dtags  -lsybdb

cp sql/tds_fdw.sql sql/tds_fdw--2.0.3.sql

cp README.md README.tds_fdw.md

/opt/rh/llvm-toolset-7/root/usr/bin/clang -Wno-ignored-attributes -fno-strict-aliasing -fwrapv -Wno-unused-command-line-argument -O2  -I./include/ -fvisibility=hidden  -I. -I./ -I/usr/edb/as13/include/server -I/usr/edb/as13/include/internal -I/usr/libexec/edb-icu66/include/ -D_GNU_SOURCE -I/usr/include/libxml2  -I/usr/include -flto=thin -emit-llvm -c -o src/tds_fdw.bc src/tds_fdw.c

make: /opt/rh/llvm-toolset-7/root/usr/bin/clang: Command not found

make: *** [src/tds_fdw.bc] Error 127

[root@hostip tds_fdw-2.0.3]#

[root@hostip tds_fdw-2.0.3]#

[root@hostip tds_fdw-2.0.3]# PATH=/usr/edb/as13/bin:$PATH

[root@hostip tds_fdw-2.0.3]# make USE_PGXS=1 install

/opt/rh/llvm-toolset-7/root/usr/bin/clang -Wno-ignored-attributes -fno-strict-aliasing -fwrapv -Wno-unused-command-line-argument -O2  -I./include/ -fvisibility=hidden  -I. -I./ -I/usr/edb/as13/include/server -I/usr/edb/as13/include/internal -I/usr/libexec/edb-icu66/include/ -D_GNU_SOURCE -I/usr/include/libxml2  -I/usr/include -flto=thin -emit-llvm -c -o src/tds_fdw.bc src/tds_fdw.c

make: /opt/rh/llvm-toolset-7/root/usr/bin/clang: Command not found

make: *** [src/tds_fdw.bc] Error 127

[root@hostip tds_fdw-2.0.3]#