CODEWITHSUNDEEP
postgresqloracle-fdwora2pg
Diana Mihutescu
Diana Mihutescu

Reputation: 21

ora2pg could not open extension control file PostgreSQL/11/share/extension/oracle_fdw.control

I m trying to migrate an oracle db to postgres using ora2pg, with schema already created in postgres, using COPY directive. The export seems done, but when trying to connect to postgres I get the following:

DBD::Pg::db do failed: ERROR: could not open extension control file "C:/Program Files/PostgreSQL/11/share/extension/oracle_fdw.control": No such file or directory at C:/Strawberry/perl/site/lib/Ora2Pg.pm line 21943. FATAL: ERROR: could not open extension control file "C:/Program Files/PostgreSQL/11/share/extension/oracle_fdw.control": No such file or directory Aborting export...

I'm not using instaclient, I have a full installation of oracle 12 locally.

Edit: the file is not present in postgres installation, but from what I see Perl is trying to create it and fails.

Upvotes: 0

Views: 1002

Answers (1)

Vitaliy
Vitaliy

Reputation: 11

I make comment out FDW_SERVER orcl in ora2pg.conf, like this:

# FDW_SERVER    orcl

That helped!

Upvotes: 1

Related Questions