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:34:51 |
Message-ID: | B794E447AC4E4244B93D1DEC296590703E37D120@BL2PRD0410MB385.namprd04.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi
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
From | Date | Subject | |
---|---|---|---|
Next Message | Nikolas Everett | 2012-10-23 13:41:20 | Re: 9.1 to 9.2 requires a dump/reload? |
Previous Message | Papiernik Anna-AAP053 | 2012-10-23 10:07:33 | oracle_fdw with oracle os authentication |