oracle_fdw with oracle os authentication - Mailing list pgsql-general

From Papiernik Anna-AAP053
Subject oracle_fdw with oracle os authentication
Date
Msg-id B794E447AC4E4244B93D1DEC296590703E37D0EB@BL2PRD0410MB385.namprd04.prod.outlook.com
Whole thread Raw
Responses Re: oracle_fdw with oracle os authentication  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
List 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

pgsql-general by date:

Previous
From: Papiernik Anna-AAP053
Date:
Subject: oracle_fdw with oracle os authentication
Next
From: Ben Chobot
Date:
Subject: Re: Streaming replication failed to start scenarios