Re: tds_fdw >> Install Foreign data Wrapper on EDB Postgres to connect to SQL server database
| От | Sumit Kochar |
|---|---|
| Тема | Re: tds_fdw >> Install Foreign data Wrapper on EDB Postgres to connect to SQL server database |
| Дата | |
| Msg-id | PH7PR14MB536795E9CED165FB2CB6CCB9F9F22@PH7PR14MB5367.namprd14.prod.outlook.com обсуждение исходный текст |
| Ответ на | Re: tds_fdw >> Install Foreign data Wrapper on EDB Postgres to connect to SQL server database (Muhammad Imtiaz <imtiaz.m@bitnine.net>) |
| Ответы |
Re: tds_fdw >> Install Foreign data Wrapper on EDB Postgres to connect to SQL server database
|
| Список | pgsql-general |
Hi Muhammad,
Tried to install as per step2 mentioned, but got message - No package llvm-toolset-7 available.
Log reference below:
[root@hostip tds_fdw-2.0.3]# yum list installed | grep llvm-toolset
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
[root@hostip tds_fdw-2.0.3]#
[root@hostip tds_fdw-2.0.3]#
[root@hostip tds_fdw-2.0.3]# sudo yum install llvm-toolset-7
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 available.
Error: Nothing to do
[root@hostip tds_fdw-2.0.3]#
[root@hostip tds_fdw-2.0.3]#
From: Muhammad Imtiaz <imtiaz.m@bitnine.net>
Sent: Tuesday, May 28, 2024 11:43 PM
To: Ian Lawrence Barwick <barwick@gmail.com>
Cc: Sumit Kochar <Sumit.Kochar@mastercard.com>; pgsql-general@lists.postgresql.org
Subject: {EXTERNAL} Re: tds_fdw >> Install Foreign data Wrapper on EDB Postgres to connect to SQL server database
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
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-7Regards,Muhammad Imtiaz
On Wed, 29 May 2024 at 05:27, Ian Lawrence Barwick <barwick@gmail.com> wrote:
2024年5月29日(水) 6:10 Sumit Kochar <Sumit.Kochar@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=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
В списке pgsql-general по дате отправления:
Предыдущее
От: Laurenz AlbeДата:
Сообщение: Re: Use of inefficient index in the presence of dead tuples