| 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:07:33 |
| Message-ID: | B794E447AC4E4244B93D1DEC296590703E37D0EB@BL2PRD0410MB385.namprd04.prod.outlook.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Papiernik Anna-AAP053 | 2012-10-23 10:34:51 | oracle_fdw with oracle os authentication |
| Previous Message | chinnaobi | 2012-10-23 10:01:59 | Re: Streaming replication failed to start scenarios |