Re: oracle_fdw with oracle os authentication

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(dot)papiernik(at)motorolasolutions(dot)com>;
Date: Tue, Oct 23, 2012 06:07 PM
To: "pgsql-general(at)postgresql(dot)org"<pgsql-general(at)postgresql(dot)org>;

Subject: [GENERAL] oracle_fdw with oracle os authentication

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