Re: tds_fdw >> Install Foreign data Wrapper on EDB Postgres to connect to SQL server database

From: Ian Lawrence Barwick <barwick(at)gmail(dot)com>
To: Sumit Kochar <Sumit(dot)Kochar(at)mastercard(dot)com>
Cc: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: tds_fdw >> Install Foreign data Wrapper on EDB Postgres to connect to SQL server database
Date: 2024-05-29 00:27:30
Message-ID: CAB8KJ=jpbREGEPVXX0x4X01de8dd3jiOzunc5x3bYxfRTLSdXg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2024年5月29日(水) 6:10 Sumit Kochar <Sumit(dot)Kochar(at)mastercard(dot)com>:
>
> 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.
(...)

> [root(at)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

IIRC you'll need to find and install the SCLO package for Oracle Linux
7, assuming it's
available. For CentOS it's this repository:
http://mirror.centos.org/centos/7/sclo/ .

Regards

Ian Barwick

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2024-05-29 00:53:21 Re: Use of inefficient index in the presence of dead tuples
Previous Message Christian Schröder 2024-05-28 22:59:13 RE: Memory issues with PostgreSQL 15