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.papier...@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 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
