[added CC to oracle-fdw-general, where this should be] Papiernik Anna-AAP053 wrote: > 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?
It should work, although I admit that I never tested it (I used External Password Store for external authentication). Can you show me the error message? Does it work if you connect as PostgreSQL OS user with "sqlplus /"? If not, you have to fix that first. Yours, Laurenz Albe -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
