Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sCMoy-0056PI-N4 for pgsql-general@arkaria.postgresql.org; Wed, 29 May 2024 17:10:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sCMox-00G32a-CW for pgsql-general@arkaria.postgresql.org; Wed, 29 May 2024 17:10:39 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sCMow-00G32Q-AX for pgsql-general@lists.postgresql.org; Wed, 29 May 2024 17:10:38 +0000 Received: from safemail1.mastercard.com ([216.119.215.10] helo=stleegwp1.mastercard.com) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sCMor-002Xxm-Sh for pgsql-general@lists.postgresql.org; Wed, 29 May 2024 17:10:36 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=mastercard.com; h=cc : content-type : date : from : in-reply-to : message-id : mime-version : references : subject : to; s=MCVM231; bh=jwjS7F0kyf6BkGu5bk01yYNRj/bWsZ7Njn3KLe53TPg=; b=TTLaIYZicdAPMuBEbg3sYCP+QNrXjdGk2alNtuNhyunOUHWjNouVCUxdNPprjBunUsPC M8ajbzmFUFPOPS9cdtTBsbmN4naa9lTTvsJLHTDb2UdgX6cEf/il9U4t723HwF24MUN9 H5M1c0zu1wrKbdMKcd6XXxjNfEokEZKJeTVty8bmsh4NxWTy5EK3eIaY+0pryFTYNSaY blpHFAtPAJXS/2LlqZlc+vm5GVQzNB7a0i7VSvSdXH1sPz/apDcrwa/+K55AmFug3x4i rrK+tG2vbD8roDmCnCKjvm5DPuvm0dcEh2cF9TvZH2103NpZVZjyvxx791iReQx/zwBU SQ== Received: from smtp.mastercard.com ([172.17.128.22]) by stleegwp1c.corp.mastercard.int (8.17.1.19/8.17.1.19) with ESMTPS id 44THASWb010375 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-SHA384 bits=256 verify=NO); Wed, 29 May 2024 12:10:29 -0500 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=jgAGTlzuKDQrLZk4hgvNME0Lc18x815ZkNcQlxG22dk/oUH44xgCfMETna7hNxKAR/M1NDr50PSeQvF+OK6kUWRVQ8xYGefwmMVsxsZfZyQMZMo1bL66TWj2M5WJy2Np/v3rtSynO1vnIHxeehOoaIdYyoWqVZPjI7rUEKuVf/ma3wozZAhBfZiYf3MJJcOLLyEgjLiYNlqXez9l3pTax1Sqa695A/4r4U7M4QiIKn1kQBs37aBRLpKW1+Y0M+7sG05s64NaeTCGhq+r6A6scyJUYFd/aj2T4rOSvHGBWmJKdw/sGspVazCuZoIHZzLaJJCwhc7ZmCOzfyXTcE2URA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=LgvrAxpT/12TZ2BItxtUu5FtgHOzEuqPseJsDfqEoks=; b=Iz6HG7kogLc5Xc68d2PYuUK9M2xR6lv64Tvr/BdGSIdY428Bf7pknlO5LLIfOdEM04v5CvQbcvAnXiUEbqgeleH6KiCaK5Tvil5XuHptwn8WOk2FUugzsOZG9DFM/INJ1rVm5FyMxiXqPyMTP7d7Wr7jpo03hVVzH8v3KFqGTe041DjEvzqBUd0tzrh3J2rVwhAcVJwVMsyi6YXulHkMpkk2OVfepnW1j0rzwswq5BcwfhXRr5B4uWetlcRxkj+WQXRVToAJ7Iv6UbPO5K37RdPo1yljEUtGsT57s7oBPKmS+I30nBT1O49PvDcKMI3AzoYlEMYzh7Y7ZTWolaebmA== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=mastercard.com; dmarc=pass action=none header.from=mastercard.com; dkim=pass header.d=mastercard.com; arc=none From: Sumit Kochar To: Muhammad Imtiaz , Ian Lawrence Barwick CC: "pgsql-general@lists.postgresql.org" , Kannan Rajesh , Haragopal Avvaru Subject: Re: tds_fdw >> Install Foreign data Wrapper on EDB Postgres to connect to SQL server database Thread-Topic: tds_fdw >> Install Foreign data Wrapper on EDB Postgres to connect to SQL server database Thread-Index: AQHasesYYB71XRX69UatBhN/X7lS+w== Date: Wed, 29 May 2024 17:10:25 +0000 Message-ID: References: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: MSIP_Label_df2f77bf-ac71-4d31-be38-cc6a5f811e56_ActionId=b2bc5213-fa17-4666-9670-ac09fdff37d5;MSIP_Label_df2f77bf-ac71-4d31-be38-cc6a5f811e56_ContentBits=0;MSIP_Label_df2f77bf-ac71-4d31-be38-cc6a5f811e56_Enabled=true;MSIP_Label_df2f77bf-ac71-4d31-be38-cc6a5f811e56_Method=Privileged;MSIP_Label_df2f77bf-ac71-4d31-be38-cc6a5f811e56_Name=Restricted;MSIP_Label_df2f77bf-ac71-4d31-be38-cc6a5f811e56_SetDate=2024-05-29T17:10:24Z;MSIP_Label_df2f77bf-ac71-4d31-be38-cc6a5f811e56_SiteId=f06fa858-824b-4a85-aacb-f372cfdc282e; x-ms-publictraffictype: Email x-ms-traffictypediagnostic: PH7PR14MB5367:EE_|BY5PR14MB3848:EE_ x-ms-office365-filtering-correlation-id: e9aa9c36-4434-4874-f7f0-08dc80023b64 x-disclaimer: Yes x-pptenantcode: ?s\*W[Y]a:S8F8{} x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0;ARA:13230031|366007|1800799015|376005|38070700009; x-microsoft-antispam-message-info: =?utf-8?B?SVFhMGVYQnBQa2p4YTVlU2FpTEE1ZTl4SkFrZXYxTjl3V25VYlk5TzJNVXJw?= =?utf-8?B?c00rbXF5eXJSenFtYWdZT1E2SHRtdG4zZ2Z4Q0ZhMFpnL2xheXY0OXdMZXE3?= =?utf-8?B?TnZFWEFSZU1wbmIvTGoyQWhIbG1CbWxWVGR1VmZNTU1jZi9UNmZrR2hqbnNr?= =?utf-8?B?amhXWWx0V0Y2bjlQTG16VFg3QUZyOWErUksyeGhXbVNLdjVFRTk5Z2dmalRS?= =?utf-8?B?RmNRWk5ZR1kwbzFXQ25mdCtvQUpiQVVwOXMzRzJpd0c3bmJ6bmxEdUkxelds?= =?utf-8?B?TkVodU1qeWhiWS9BN25Cb1lRdVZvNmFEWk5nVXlRejJPSHlWWDBvMUU4dmU0?= =?utf-8?B?Wm01M3ZCWld3MlN4cnFkZEdLdVVWY0hvendJblRhUmtDTFNlZXlDTW5CS2JP?= =?utf-8?B?TzBsM1dIL1hRM2ZzMXkxT21KL0RYMlRHSTRpdDRhcUhCa2h5UXNZSlJwdzJn?= =?utf-8?B?WVVEeFJwOStuNlN6VnlpbjlQeXN2QTlxcUFjb20zYVJxelRhMW5Zd2RUOEsv?= =?utf-8?B?WTN3MlRvTFNqeHp3aXJmM01DcXdSL0NwWUdEbjhXbEx5bDFJOWJ2MCtrRzdH?= =?utf-8?B?NjBidTV6UmtWK0dKdjh5U2xvcDNFQzZNZHdQRWRHeE5ncjBxbmM3c1N5ZjZV?= =?utf-8?B?YU56NG0xWG9PNzVYMjUyNTJQM2hiZ0o4QkNVRW5lNndpVzVmZjRtMkhYZjh1?= =?utf-8?B?RThLK093cTkrS3M3OHJlN0V4dU51NW9NVTEyUVNNcVU4bnVBVlBlRVJGa2Z1?= =?utf-8?B?U0pPN0hYejRMZXorRUtQMloxVExRUTlJVGxQd3VCVHJjT0I1UWZlSjEwbi83?= =?utf-8?B?NmxzN2lhSmJIQzRHSFV1TWQwWk1HbDVhLy9INUljcW5jTDZsc0FrNEtRY0xt?= =?utf-8?B?K242ejZoT2JncjBmWGFHbzV4NndYTE9mS0JQWHE2N0ZCMlhpZ1U3cHVkN3FE?= =?utf-8?B?SXphcnBzS3J4TmlFL3AvbHppQVRLRTVBbDFNYllBZmsveWNua25zQnFndUJx?= =?utf-8?B?aElBV2tNWnh1NUhqNVZ3dFMwSTFGY3h4WjNGR0sxQndNcHcvL21QRmpxUzlp?= =?utf-8?B?Rm9OQzRtK1JnRWxSSmE0ak4wRHNWS1M2VitDOHo5SUM0RTVUaGdBOGtqcWZu?= =?utf-8?B?bWJTODFrS0JaV1hjdkFBWmMzMGVhUktnVmhrbUdKUDZqd3ByN0t2V0U3V1Zx?= =?utf-8?B?NW5TOFVYK05ESDNEOGNDUktqaVRZZVBLeU5zSGN4dThpTVkvTmdMVUd5K0F2?= =?utf-8?B?VHpGcjVNbE9EN0liamw4bnVVblZVb0l3aE5wOWc0bmlMazMrV2NkWHVBdTk0?= =?utf-8?B?MWpaOCtZQUxUTDBSZ3ZxbjNiWWVvYjVHK3dZVHhMb0xCcE1yRHBQRUVIL050?= =?utf-8?B?NGVaK1hOeVM1ektpTklOOHlnZVFOUGNhY0N5M1ZOcHhnV1JjSUhadnY2b2JH?= =?utf-8?B?YUlROGJtdGQvMzdKYjg2VUZSU2d6d1Joai83TnhZNnA4RXJEdzVDcllsOElX?= =?utf-8?B?SG4waHhJVDRxSjJxa2RFbW14VjhsamUydnJuOWRTeHNPWHNvZnRtM2wyQWNo?= =?utf-8?B?TTd4VmdEVVJXRUZMZkFtN2F1UHdraFJ1aDA1VnZxOG40WlNidTJyY0RhKzg4?= =?utf-8?B?Y1d6Uy9MTGRCQllyVjRVRzZuYlMyQVdZKzlJWFJtbEROT0dHVzhOZmZEQ0tH?= =?utf-8?B?MkxneUdHZE9wd3FzME95Q2t3dGF1TDNUOWM5K1FEYmZ5Z3hSbDhDaXVnPT0=?= x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:PH7PR14MB5367.namprd14.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230031)(366007)(1800799015)(376005)(38070700009);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?utf-8?B?Y1g4d0RFY09wWm1rbzBucVlwUVFRL0MwMFJVVXZ6WG5JSHpON1RacUFaRzQ4?= =?utf-8?B?azhJMHR2dTkxcGhlZ3RXc0RKUGZSZVlaSVVxVHhjOERhSCtUbEZlK2RBMTgr?= =?utf-8?B?UWRZYS9ydGpJN3hvZGdscU04M3QrL3A1TGpiWW9malVxaHQ4ZjBlSEhXMGdm?= =?utf-8?B?bmFsYkR5RWJkWGo3Q2hSVk14aTMrVVJwNmlZVE5zSFN0R1ZwZWl6UzVCUnlo?= =?utf-8?B?WkhUczhOKyswZVBjOENveE9DZ05HR0NaTkROSC9sZVhRTDdHazFzcnB1QWVj?= =?utf-8?B?RHM1WllUZVgrbzI2OVgyYXZ3T1dCZC9abHg3eWJuQ0pBdE5OTGZ0ZXlFRzdY?= =?utf-8?B?L01NQmdmRzdhVk9PaUVNUEZQZjJBdFh3OS9NVGZaT2JmZFYrMHU1WnpVVlIz?= =?utf-8?B?cEhFTnV5czVRNVFzTVBmUCsrRk9qcjhPOTVkbTZxeHp3TzRjV0dNZE9obXNt?= =?utf-8?B?RVViM28zUk1TNHFYaW01TzZ6SmhSMnE4MVVvbk5Rb2FDUyt2ZFJrT0JXSVN5?= =?utf-8?B?ZjNKOWlIamJ5U0RlQzIvQTNFVnRUOFpPVDV0RE12Rmh2KzZQOWpaVk1hMncz?= =?utf-8?B?eEQ2b0Evb3FyNUl5K0dKRkI1VlIxUDRoMGIreS9MeVBteEFyd1RtR2VMdmdO?= =?utf-8?B?bVQvMGo3eGhrcTJzbkpDOHpMQk4xTkljdU8zejRBK053bWEyQnR1MmMvbVB2?= =?utf-8?B?c1R2MktjVk4vYmpIVTNHZ0kxZUxIb3FnR0JrYnBSYm42ZmtoNkttME91aFhU?= =?utf-8?B?RzZiYU1VQy9ZOUE4UnBmNWZPN3dCNXhOYmJkd0hZdURMRDV5dG9GbWZrd29v?= =?utf-8?B?V3RtOXhIREw2bFgzVTdtK05VdlpnNWRFSmNMNWRvVVR0TFNLdC91NVJqYTJp?= =?utf-8?B?NnZ4UWlCR2lJc1JQeEJhb1BhL1FOTFN1NWFaa3JMNDhLUmVYWGdmeG5NQ0wv?= =?utf-8?B?bThJejEycXQ4byt2RnVHa0hXVGY2RDlzOG9oZ0RLUWFYY1VwMWNOZEtndzdI?= =?utf-8?B?am94U0F0cGRpczVLK0swUC9vVjhXZ1hBdHp3aWV2MXZUbnVZZmNua2hVcm5U?= =?utf-8?B?WlczS3B3dktYTHllQllmcTU3VVhYRlBWTS9XT0V6QzJwRmdYTVI1bVQyNkY1?= =?utf-8?B?K0RmZWpQd2RvUnNKSTNWUTdkTDIzbG5pZ21CUEgrVVhGMnhkUXpUZkRUMGhq?= =?utf-8?B?OERubEFWNU1PaVFFNCsrQmVBVzFxeUVmblc2enFaNm14bC9JM3gwWlZVbkFZ?= =?utf-8?B?MEZwL0NPK1RYMXZUb2ZEc1ZCUndWeStxa3d1dHAxbHRLcU83VkNEV0diNEhx?= =?utf-8?B?QmtqWm1kMDlvYUlJVCtIc21kZm84N0FxbGwvZzJyS0pKTXBvWTZIdUpFK1U0?= =?utf-8?B?VjBCYVljNm5pVldyZk9KbU5kNDhmRFNESEdFSXdkTG0xdXZ5dTBUVVVHeU9h?= =?utf-8?B?Y0YzVVhQeEROTnhpN0ZPSlhTdi9Vb05nTUFjSnMzVDcrSUVseW5uZFhaZ0tP?= =?utf-8?B?dmdtUVpSNWtDYXhZUm83Z1YxWFhvWVB4eS9ld1Arb0d6QklZQnpIeHNvL3Rs?= =?utf-8?B?Z0RRdTlqNzcxN1NWMlQ4MzRNQ2J6c2JrbUVVdDJNejhpa2srVEE0TTZiMklk?= =?utf-8?B?L2JxTWc2S3J1enNwY1lYQ3RYd2NtZCtGMFBIZVM5bHhqdVJDWDEza2tidlVX?= =?utf-8?B?YnBYYjVnZXRYcHRSMXo5UWpyWG82Yzl0bGJiNDBraEVtQ2owZlE5ajVhOUVJ?= =?utf-8?B?b3lObEtuZVlaejE1V29LQnlyT2ZkWjRHZ0dORGlocUc0cjRDemNsZWhiaUR4?= =?utf-8?B?dTAxZmlmS1NrTnczdVRuelR4ZjRpN3NndWt6a01tQVNWbEFEV3FZaFQ5RzR0?= =?utf-8?B?S3hIZzhEM056R0I0RnV1UkdBSEFuYXFxbElmVVJTK3BqQzZCQmxWeFV5bkNt?= =?utf-8?B?ZUxndmhMSndHTWlXRjRlbEFLYXBKSjdXQzVEWGJwc0krUkRwSkY5cHpIL0tM?= =?utf-8?B?MjVVK3JXSHYwa0pqQUZjOGdvNUNRZUNTbnZDeGhYNWpnTUJjWVA4U3diOTVR?= =?utf-8?B?ZlhDZHJJUnpIZkpoUFNJMEFvWjlHUitDNWdyZ1RQcVdQYmhqMUFhSmsxUDRV?= =?utf-8?B?bkJGM0gzekRXQytWNGtCRjFVcU55b3UrSXB2QW1DaDVFMkVLa2JFbjJNSzZo?= =?utf-8?B?QVE9PQ==?= Content-Type: multipart/alternative; boundary="_000_PH7PR14MB536795E9CED165FB2CB6CCB9F9F22PH7PR14MB5367namp_" MIME-Version: 1.0 X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: PH7PR14MB5367.namprd14.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: e9aa9c36-4434-4874-f7f0-08dc80023b64 X-MS-Exchange-CrossTenant-originalarrivaltime: 29 May 2024 17:10:25.4082 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: f06fa858-824b-4a85-aacb-f372cfdc282e X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: tGht6MKBOvzN7Y4+TkBM4sTX9sp3iXbkGrk1zk1bTnFi95f5tFu7XORBx/6hUMV1tNVYqzy5cSQB5J9qlDOXClqMt1afgusCzjjEDpF9SDc= X-MS-Exchange-Transport-CrossTenantHeadersStamped: BY5PR14MB3848 X-OriginatorOrg: mastercard.com X-CFilter-Loop: Reflected List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_PH7PR14MB536795E9CED165FB2CB6CCB9F9F22PH7PR14MB5367namp_ Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable 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 configurat= ion Repository mc-ol7_tsm-8.1.13_x86_64 is listed more than once in the configu= ration Repository mc-ol7-chef_client_15-x86_64 is listed more than once in the con= figuration [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 configurat= ion Repository mc-ol7_tsm-8.1.13_x86_64 is listed more than once in the configu= ration Repository mc-ol7-chef_client_15-x86_64 is listed more than once in the con= figuration 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 Sent: Tuesday, May 28, 2024 11:43 PM To: Ian Lawrence Barwick Cc: Sumit Kochar ; pgsql-general@lists.postgre= sql.org Subject: {EXTERNAL} Re: tds_fdw >> Install Foreign data Wrapper on EDB Post= gres 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, y= ou can install it using the following command. sudo yum install llvm-toolse= t-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-7 Regards, Muhammad Imtiaz On Wed, 29 May 2024 at 05:27, Ian Lawrence Barwick > wrote: 2024=E5=B9=B45=E6=9C=8829=E6=97=A5(=E6=B0=B4) 6:10 Sumit Kochar >: > > Installation of Foreign data Wrapper on EDB Postgres to connect to SQL se= rver 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-st= rict-aliasing -fwrapv -Wno-unused-command-line-argument -O2 -I./include/ -= fvisibility=3Dhidden -I. -I./ -I/usr/edb/as13/include/server -I/usr/edb/as= 13/include/internal -I/usr/libexec/edb-icu66/include/ -D_GNU_SOURCE -I/usr/= include/libxml2 -I/usr/include -flto=3Dthin -emit-llvm -c -o src/tds_fdw.b= c 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 CONFIDENTIALITY NOTICE This e-mail message and any attachments are only for= the use of the intended recipient and may contain information that is priv= ileged, confidential or exempt from disclosure under applicable law. If you= are not the intended recipient, any disclosure, distribution or other use = of this e-mail message or attachments is prohibited. If you have received t= his e-mail message in error, please delete and notify the sender immediatel= y. Thank you. --_000_PH7PR14MB536795E9CED165FB2CB6CCB9F9F22PH7PR14MB5367namp_ Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: quoted-printable

Hi Muhammad,

 

Tried to install as per step2 mentioned, but got mes= sage - 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 serv= er.

You can use rhn_register to register.<= /i>

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 t= han once in the configuration

Repository mc-ol7_tsm-8.1.13_x86_64 is listed mor= e 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 llv= m-toolset-7

Loaded plugins: rhnplugin

This system is not registered with Spacewalk serv= er.

You can use rhn_register to register.<= /i>

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 t= han once in the configuration

Repository mc-ol7_tsm-8.1.13_x86_64 is listed mor= e 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.ne= t>
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 Wrappe= r on EDB Postgres to connect to SQL server database

 

Hi , You need to install the LLVM toolset. 1)Ch= eck 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,Mu= hammad

Hi ,

You need to install the  LLVM toolset.

1)Check that if it is installed or not :

yum lis=
t installed | grep llvm-toolset
&n=
bsp;
2)If it is =
not installed, you can install it using the following command.<=
/o:p>
sudo yu=
m install llvm-toolset-7
 
Regards,
Muhammad Imti=
az
 
 
 

 

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

2024=E5=B9=B45=E6=9C=8829=E6=97=A5(=E6=B0=B4) 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 availabl= e.
(...)

> [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./in= clude/ -fvisibility=3Dhidden  -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=3Dthin -em= it-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.o= rg/centos/7/sclo/ .

Regards

Ian Barwick

CONFIDENTIALITY NOTICE This e-mail message and any attachments are only for= the use of the intended recipient and may contain information that is priv= ileged, confidential or exempt from disclosure under applicable law. If you= are not the intended recipient, any disclosure, distribution or other use of this e-mail message or attach= ments is prohibited. If you have received this e-mail message in error, ple= ase delete and notify the sender immediately. Thank you. --_000_PH7PR14MB536795E9CED165FB2CB6CCB9F9F22PH7PR14MB5367namp_--