MIME-Version: 1.0
References: <PH7PR14MB53674648EB083CD246900B65F9F12@PH7PR14MB5367.namprd14.prod.outlook.com>
 <CAB8KJ=jpbREGEPVXX0x4X01de8dd3jiOzunc5x3bYxfRTLSdXg@mail.gmail.com>
In-Reply-To: <CAB8KJ=jpbREGEPVXX0x4X01de8dd3jiOzunc5x3bYxfRTLSdXg@mail.gmail.com>
From: Muhammad Imtiaz <imtiaz.m@bitnine.net>
Date: Wed, 29 May 2024 08:43:11 +0500
Message-ID: <CANwR1OSUOOjvRF9QiV+qRYceVMndYGHNOjayWroKBHUn9FBROQ@mail.gmail.com>
Subject: Re: tds_fdw >> Install Foreign data Wrapper on EDB Postgres to
 connect to SQL server database
To: Ian Lawrence Barwick <barwick@gmail.com>
Cc: Sumit Kochar <Sumit.Kochar@mastercard.com>, 
	"pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000062f39006198f8d29"
Archived-At: <https://www.postgresql.org/message-id/CANwR1OSUOOjvRF9QiV%2BqRYceVMndYGHNOjayWroKBHUn9FBROQ%40mail.gmail.com>
Precedence: bulk

--00000000000062f39006198f8d29
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi ,

You need to install the  LLVM toolset.

1)Check that if it is installed or not :

yum list installed | grep llvm-toolset

2)If it is not installed, you can install it using the following command.
sudo yum install llvm-toolset-7

Regards,
Muhammad Imtiaz


On Wed, 29 May 2024 at 05:27, Ian Lawrence Barwick <barwick@gmail.com>
wrote:

> 2024=E5=B9=B45=E6=9C=8829=E6=97=A5(=E6=B0=B4) 6:10 Sumit Kochar <Sumit.Ko=
char@mastercard.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@hostip tds_fdw-2.0.3]# make USE_PGXS=3D1 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=3Dhidden  -I. -I./ -I/usr/edb/as13/include/serv=
er
> -I/usr/edb/as13/include/internal -I/usr/libexec/edb-icu66/include/
> -D_GNU_SOURCE -I/usr/include/libxml2  -I/usr/include -flto=3Dthin -emit-l=
lvm
> -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
>
>
>

--00000000000062f39006198f8d29
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><font face=3D"arial, sans-serif">Hi ,<br><br>You need to i=
nstall the=C2=A0

LLVM toolset.<br><br>1)Check that if it is installed or not :<br></font><pr=
e><div class=3D"gmail-dark gmail-bg-gray-950 gmail-rounded-md gmail-border-=
[0.5px] gmail-border-token-border-medium"><div class=3D"gmail-overflow-y-au=
to gmail-p-4 gmail-text-left gmail-undefined" dir=3D"ltr"><code class=3D"gm=
ail-!whitespace-pre gmail-hljs gmail-language-bash"><font face=3D"arial, sa=
ns-serif">yum list installed | grep llvm-toolset

2)</font></code><span style=3D"font-family:Arial,Helvetica,sans-serif">If i=
t is not installed, you can install it using the following command.</span><=
/div><div class=3D"gmail-overflow-y-auto gmail-p-4 gmail-text-left gmail-un=
defined" dir=3D"ltr"><code class=3D"gmail-!whitespace-pre gmail-hljs gmail-=
language-bash"><font face=3D"arial, sans-serif">sudo yum install llvm-tools=
et-7</font></code></div><div class=3D"gmail-overflow-y-auto gmail-p-4 gmail=
-text-left gmail-undefined" dir=3D"ltr"><font face=3D"arial, sans-serif"><b=
r></font></div><div class=3D"gmail-overflow-y-auto gmail-p-4 gmail-text-lef=
t gmail-undefined"><font face=3D"arial, sans-serif">Regards,</font></div><d=
iv class=3D"gmail-overflow-y-auto gmail-p-4 gmail-text-left gmail-undefined=
"><font face=3D"arial, sans-serif">Muhammad Imtiaz<br></font><code class=3D=
"gmail-!whitespace-pre gmail-hljs gmail-language-bash"><h3></h3>


</code></div></div></pre><p></p></div><br><div class=3D"gmail_quote"><div d=
ir=3D"ltr" class=3D"gmail_attr">On Wed, 29 May 2024 at 05:27, Ian Lawrence =
Barwick &lt;<a href=3D"mailto:barwick@gmail.com">barwick@gmail.com</a>&gt; =
wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0=
px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">2024=E5=
=B9=B45=E6=9C=8829=E6=97=A5(=E6=B0=B4) 6:10 Sumit Kochar &lt;<a href=3D"mai=
lto:Sumit.Kochar@mastercard.com" target=3D"_blank">Sumit.Kochar@mastercard.=
com</a>&gt;:<br>
&gt;<br>
&gt; Installation of Foreign data Wrapper on EDB Postgres to connect to SQL=
 server database is not working.<br>
&gt;<br>
&gt;<br>
&gt;<br>
&gt; <a href=3D"https://github.com/tds-fdw/tds_fdw/issues/357" rel=3D"noref=
errer" target=3D"_blank">https://github.com/tds-fdw/tds_fdw/issues/357</a><=
br>
&gt;<br>
&gt;<br>
&gt;<br>
&gt; Please advise if this has been encountered or a workaround is availabl=
e.<br>
(...)<br>
<br>
&gt; [root@hostip tds_fdw-2.0.3]# make USE_PGXS=3D1 install<br>
&gt;<br>
&gt; /opt/rh/llvm-toolset-7/root/usr/bin/clang -Wno-ignored-attributes -fno=
-strict-aliasing -fwrapv -Wno-unused-command-line-argument -O2=C2=A0 -I./in=
clude/ -fvisibility=3Dhidden=C2=A0 -I. -I./ -I/usr/edb/as13/include/server =
-I/usr/edb/as13/include/internal -I/usr/libexec/edb-icu66/include/ -D_GNU_S=
OURCE -I/usr/include/libxml2=C2=A0 -I/usr/include -flto=3Dthin -emit-llvm -=
c -o src/tds_fdw.bc src/tds_fdw.c<br>
&gt;<br>
&gt; make: /opt/rh/llvm-toolset-7/root/usr/bin/clang: Command not found<br>
<br>
IIRC you&#39;ll need to find and install the SCLO package for Oracle Linux<=
br>
7, assuming it&#39;s<br>
available. For CentOS it&#39;s this repository:<br>
<a href=3D"http://mirror.centos.org/centos/7/sclo/" rel=3D"noreferrer" targ=
et=3D"_blank">http://mirror.centos.org/centos/7/sclo/</a> .<br>
<br>
Regards<br>
<br>
Ian Barwick<br>
<br>
<br>
</blockquote></div>

--00000000000062f39006198f8d29--