Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1aWPHM-0002Ho-BA for pgsql-admin@arkaria.postgresql.org; Thu, 18 Feb 2016 14:10:00 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1aWPHL-0005QT-Q5 for pgsql-admin@arkaria.postgresql.org; Thu, 18 Feb 2016 14:09:59 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1aWPFg-0003YW-74 for pgsql-admin@postgresql.org; Thu, 18 Feb 2016 14:08:16 +0000 Received: from imx6.etecsa.cu ([200.55.152.141]) by magus.postgresql.org with esmtp (Exim 4.84) (envelope-from ) id 1aWPFX-0007d1-Bk for pgsql-admin@postgresql.org; Thu, 18 Feb 2016 14:08:15 +0000 Received: from mn3.etecsa.cu (unknown [192.168.91.45]) by imx6.etecsa.cu (Postfix) with ESMTP id 7BADA13C for ; Thu, 18 Feb 2016 09:08:02 -0500 (CST) Received: (qmail 6305 invoked by uid 11185); 18 Feb 2016 14:06:51 -0000 Received: from 192.168.91.6 by mn3.etecsa.cu (envelope-from , uid 502) with qmail-scanner-2.08 (spamassassin: 3.2.5. Clear:RC:1(192.168.91.6):. Processed in 0.059858 secs); 18 Feb 2016 14:06:51 -0000 Received: from unknown (HELO webmail.etecsa.cu) ([192.168.91.6]) (envelope-sender ) by mn2.etecsa.cu (qmail-ldap-1.03) with SMTP for ; 18 Feb 2016 14:06:51 -0000 Received: from 192.168.207.54 (SquirrelMail authenticated user gilberto.castillo) by webmail.etecsa.cu with HTTP; Thu, 18 Feb 2016 09:08:02 -0500 (GMT+5) Message-ID: <47091.192.168.207.54.1455804482.squirrel@webmail.etecsa.cu> In-Reply-To: References: <56C486C2.9080702@vt.edu> Date: Thu, 18 Feb 2016 09:08:02 -0500 (GMT+5) Subject: Re: [MASSMAIL]Re: oracle db reads from postgresql From: "Gilberto Castillo" To: "Shreeyansh Dba" Cc: "Ray Stell" , "pgsql-admin@postgresql.org" Reply-To: gilberto.castillo@etecsa.cu User-Agent: SquirrelMail/1.4.8-5.el5_4.10 MIME-Version: 1.0 Content-Type: text/plain;charset=utf-8 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) Importance: Normal X-KLMS-Rule-ID: 1 X-KLMS-Message-Action: clean X-KLMS-AntiSpam-Lua-Profiles: 91508 [Feb 18 2016] X-KLMS-AntiSpam-Version: 5.5.9.33 X-KLMS-AntiSpam-Envelope-From: gilberto.castillo@etecsa.cu X-KLMS-AntiSpam-Rate: 0 X-KLMS-AntiSpam-Status: not_detected X-KLMS-AntiSpam-Method: none X-KLMS-AntiSpam-Moebius-Timestamps: 3969599, 3969780, 3969585 X-KLMS-AntiSpam-Info: LuaCore: 414 414 652141367f63b6038f5642fa97308d3a9d2edb46, Auth:dkim=none X-KLMS-AntiSpam-Interceptor-Info: scan successful X-KLMS-AntiPhishing: Clean, 2016/02/17 15:51:37 X-KLMS-AntiVirus: Kaspersky Security 8.0 for Linux Mail Server, version 8.0.1.721, bases: 2016/02/18 06:46:00 #7187240 X-KLMS-AntiVirus-Status: Clean, skipped X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org > On Wed, Feb 17, 2016 at 8:12 PM, Ray Stell wrote: > >> I've dreaded this task coming my way for years. An Oracle developer >> wants >> to read postgresql data from his Oracle db. Is there a current, >> successful >> path to making this work or is it fools errand? I find this description: >> https://dbaspot.wordpress.com/2013/05/29/how-to-access-postgresql-from-oracle-database/ >> which is 3 yrs old. I see they want me to load an v8 rpm for the odbc >> driver so I tried to compile the latest and failed out of the gate. >> Just >> wondering if anyone has it working or not? Is there a more current >> howto? Use HS module in Oracle, but is better to join Postgres to Oracle to otherwise. -- Saludos, Gilberto Castillo ETECSA, La Habana, Cuba -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin