Postgres Pro
Downloads
Home   >   mailing lists

Re: oracle_fdw with oracle os authentication - Mailing list pgsql-general

From Xiong He
Subject Re: oracle_fdw with oracle os authentication
Date
Msg-id tencent_7C28669C0CC3D15D3BD9B89C@qq.com
Whole thread Raw
In response to oracle_fdw with oracle os authentication  (Papiernik Anna-AAP053 <anna.papiernik@motorolasolutions.com>)
List pgsql-general
Tree view
Not sure. But you can always avoid the OS authentication with empty user and password to access Oracle.
You can use other authentication mode to access oracle instead.

------------------
Thanks&Regards,
Xiong He

 


------------------ Original ------------------
From:  "Papiernik Anna-AAP053"<anna.papiernik@motorolasolutions.com>;
Date:  Tue, Oct 23, 2012 06:07 PM
To:  "pgsql-general@postgresql.org"<pgsql-general@postgresql.org>;
Subject:  [GENERAL] oracle_fdw with oracle os authentication

<!-- @font-face{font-family:"Cambria Math";panose-1:2 4 5 3 5 4 6 3 2 4;} @font-face{font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} @font-face{font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;} p.MsoNormal, li.MsoNormal, div.MsoNormal{margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:"Calibri","sans-serif";} p.MsoAcetate, li.MsoAcetate, div.MsoAcetate{mso-style-priority:99;mso-style-link:"Balloon Text Char";margin:0in;margin-bottom:.0001pt;font-size:8.0pt;font-family:"Tahoma","sans-serif";} span.EmailStyle17{mso-style-type:personal-compose;font-family:"Calibri","sans-serif";color:windowtext;} span.BalloonTextChar{mso-style-name:"Balloon Text Char";mso-style-priority:99;mso-style-link:"Balloon Text";font-family:"Tahoma","sans-serif";} .MsoChpDefault{mso-style-type:export-only;} @page WordSection1{size:8.5in 11.0in;margin:1.0in 1.0in 1.0in 1.0in;} div.WordSection1{page:WordSection1;} -->

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: "Enke, Dr., Michael"
Date:
Subject: Q: ecpg and UPDATE/DELETE ... RETURNING ... for multiple returned rows
Next
From: Vishalakshi Navaneethakrishnan
Date:
Subject: Re: Postgres Login Users Details