oracle_fdw with oracle os authentication

From: Papiernik Anna-AAP053 <anna(dot)papiernik(at)motorolasolutions(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: oracle_fdw with oracle os authentication
Date: 2012-10-23 10:07:33
Message-ID: B794E447AC4E4244B93D1DEC296590703E37D0EB@BL2PRD0410MB385.namprd04.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have Oracle with OS authentication.
And I have installed PostgreSQL and I want to migrate data from Oracle to PostgreSQL database.

I have performed steps:
CREATE EXTENSION oracle_fdw;
CREATE SERVER oradb FOREIGN DATA WRAPPER oracle_fdw OPTIONS (dbserver '');
GRANT USAGE ON FOREIGN SERVER oradb TO postgres;
CREATE USER MAPPING FOR postgres SERVER oradb OPTIONS (user '', password '');

Then I have created foreign table and I want to select from it.
Unfortunatelly, oracle_fdw is unable to connect using OS authentication and it doesn't work.

Is it possible to use oracle_fdw to have OS authentication?

Regards,
Anna

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Papiernik Anna-AAP053 2012-10-23 10:34:51 oracle_fdw with oracle os authentication
Previous Message chinnaobi 2012-10-23 10:01:59 Re: Streaming replication failed to start scenarios