Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1aW3JE-00073s-93 for pgsql-admin@arkaria.postgresql.org; Wed, 17 Feb 2016 14:42:28 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1aW3JD-0004SC-SG for pgsql-admin@arkaria.postgresql.org; Wed, 17 Feb 2016 14:42:27 +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 1aW3JD-0004RA-9q for pgsql-admin@postgresql.org; Wed, 17 Feb 2016 14:42:27 +0000 Received: from omr1.cc.ipv6.vt.edu ([2607:b400:92:8300:0:c6:2117:b0e] helo=omr1.cc.vt.edu) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1aW3J6-0003dd-D5 for pgsql-admin@postgresql.org; Wed, 17 Feb 2016 14:42:26 +0000 Received: from mr6.cc.vt.edu (mr6.cc.ipv6.vt.edu [IPv6:2001:468:c80:2105:0:250:3bcb:5b17]) by omr1.cc.vt.edu (8.14.4/8.14.4) with ESMTP id u1HEgHYY016520 for ; Wed, 17 Feb 2016 09:42:17 -0500 Received: from mail-qk0-f179.google.com (mail-qk0-f179.google.com [209.85.220.179]) by mr6.cc.vt.edu (8.14.4/8.14.4) with ESMTP id u1HEgBLh031916 for ; Wed, 17 Feb 2016 09:42:17 -0500 Received: by mail-qk0-f179.google.com with SMTP id x1so6493989qkc.1 for ; Wed, 17 Feb 2016 06:42:17 -0800 (PST) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:to:from:subject:message-id:date:user-agent :mime-version:content-type:content-transfer-encoding; bh=4mlonIGHhdcV7GbpGBLb+jkuHeo0kag0tKaPUMbz0yU=; b=FFpJ6nd+cUcW05EMsfdlFKpNBORIsnT8hYps087tG47jtU2CmdaJanMbzDBMOXQaXG 1mxFVxn205ZpHfZPgourHj8IZGr639grfl44lxLamkrs2CdOR8wSQA0eXHB8fD+PRlM2 Dh+vfxZvYjev0ryt6v7X4RD+jWKpvP8u5NeHkhGPZoO0h9Vck0MYSaM5VV1M4YVL4opF vAL0Wj9d9QtVRNL9M57gkaaOagPEgnpKMegxYHmkpNQZ9AFCWIkZ1fvtbF2GDVKqMHhO rtfY2BmY8vxiAx1oIHoM2r064psnCZJi26rY/nb+J8nDpoO2SZp3U5xVv6j9mLLKS1Tg En8Q== X-Gm-Message-State: AG10YOTZjRMtvE3RaHTAcYK5ZcgDz/nPF2l4A+IWZUgMqczm8Npd7sFU69OoFrtgFmxUKo7wShcahqznVzEP5J1aPP0YM0Q1dFsDtezfOjEWUvof272TFAjCq58k8W6Y1rQ6Pp2o3/1D3xNNl8PbhY3I9bkBxST8pTSSny2yE1JATNU9wTx9ZZeMSmMB7++4pmsg6Uw= X-Received: by 10.55.77.202 with SMTP id a193mr2339354qkb.48.1455720131899; Wed, 17 Feb 2016 06:42:11 -0800 (PST) X-Received: by 10.55.77.202 with SMTP id a193mr2339329qkb.48.1455720131689; Wed, 17 Feb 2016 06:42:11 -0800 (PST) Received: from stell.cns.vt.edu ([2001:468:c80:2102:1d96:8f09:ef01:8a98]) by smtp.gmail.com with ESMTPSA id d65sm15404718qgf.30.2016.02.17.06.42.11 for (version=TLSv1/SSLv3 cipher=OTHER); Wed, 17 Feb 2016 06:42:11 -0800 (PST) To: "pgsql-admin@postgresql.org" From: Ray Stell Subject: oracle db reads from postgresql Message-ID: <56C486C2.9080702@vt.edu> Date: Wed, 17 Feb 2016 09:42:10 -0500 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:38.0) Gecko/20100101 Thunderbird/38.5.1 MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit X-Spam-Status: No, score=-0.7 required=5.0 tests=RCVD_IN_DNSWL_LOW autolearn=disabled version=3.3.1 X-Spam-Checker-Version: SpamAssassin 3.3.1 (2010-03-16) on mr6.cc.vt.edu 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 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? -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin