Search Postgresql Archives

oracle_fdw with oracle os authentication

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux