Re: newbie tries to get oracle db to select from postgresql

On 02/18/2016 05:56 AM, Ray Stell wrote:
> Forgive me if this is a misplaced post.
>
> I've been requested to get an Oracle 11g db to be able to select from a
> postgresql 9.4 db and I've never gone here before.  I was reading from
> here:
> https://dbaspot.wordpress.com/2013/05/29/how-to-access-postgresql-from-oracle-database/
>
> and it says to install odbc rpm on the oracle server:  # yum install
> postgresql91-odbc  on the oracle server.
>
> The one available is older:
>  > yum info postgresql-odbc.x86_64
> Loaded plugins: priorities, ulninfo
> Available Packages
> Name        : postgresql-odbc
> Arch        : x86_64
> Version     : 08.04.0200
> Release     : 1.el6
> Size        : 267 k
> Repo        : ol6_latest
> Summary     : PostgreSQL ODBC driver
> URL         : http://psqlodbc.projects.postgresql.org/
> License     : LGPLv2+
> Description : This package includes the driver needed for applications
> to access a
>              : PostgreSQL system via ODBC (Open Database Connectivity).

I am going to guess you are using Oracle Linux 6, is that correct?

If not what distribution are you using?

Where did you install Postgres from?

>
> Is this ok to use with postgresql 9x?  If not do I need to install
> postgresql server components in order to build psqlodbc-09.05.0100?
>
> Is there a better, detailed howto on this topic?
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com