public inbox for [email protected]
help / color / mirror / Atom feedForeign Data Wrapper from Oracle to Postgres 16
3+ messages / 3 participants
[nested] [flat]
* Foreign Data Wrapper from Oracle to Postgres 16
@ 2025-07-02 18:28 Santhosh S <[email protected]>
2025-07-03 06:50 ` Re: Foreign Data Wrapper from Oracle to Postgres 16 Laurenz Albe <[email protected]>
0 siblings, 1 reply; 3+ messages in thread
From: Santhosh S @ 2025-07-02 18:28 UTC (permalink / raw)
To: [email protected]; pgsql-novice
Hi team,
I am working on a project along with my peers on developing an Foreign Data
Wrapper to transfer data from Oracle to Postgres 16. We followed the below
steps in order:
1. Developed the Foreign Data Wrapper (64-bit) using Microsoft Visual
Studio to transfer from Oracle to Postgres 16
2. Installed Oracle Instant Client 64-bit versionand InstantClient Path has
been set in the environment variables
3. Have Postgres 16 64-bit version installed
4. Placed all the files from each folder of the downloaded ORACLE_FDW
package should be copied into the respective folders of PostgreSQL
Installation directory
5. “oci.dll” from the Oracle Instant Client Installation directory to
PostgreSQL Installation directory
6. Visual C++ redistributable is installed
After the above steps when we try to execute the below statement in
Postgres 16
CREATE EXTENSION IF NOT EXISTS oracle_fdw
SCHEMA public
VERSION "1.2"
we get the error "SQL Error [58P01]: ERROR: could not load library
"C:/Program Files/PostgreSQL/16/lib/oracle_fdw.dll": The specified module
could not be found.
Error position"
But we are able to execute the above command successfully in Postgres 13
and successfully transfer data from Oracle to Postgres 13.
Any help or direction would be greatly helpful.
Regards
Santhosh S
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Foreign Data Wrapper from Oracle to Postgres 16
2025-07-02 18:28 Foreign Data Wrapper from Oracle to Postgres 16 Santhosh S <[email protected]>
@ 2025-07-03 06:50 ` Laurenz Albe <[email protected]>
2025-07-04 13:44 ` Re: Foreign Data Wrapper from Oracle to Postgres 16 DINESH NAIR <[email protected]>
0 siblings, 1 reply; 3+ messages in thread
From: Laurenz Albe @ 2025-07-03 06:50 UTC (permalink / raw)
To: Santhosh S <[email protected]>; [email protected]; pgsql-novice
On Wed, 2025-07-02 at 23:58 +0530, Santhosh S wrote:
> I am working on a project along with my peers on developing an Foreign Data Wrapper
> to transfer data from Oracle to Postgres 16. We followed the below steps in order:
>
> 1. Developed the Foreign Data Wrapper (64-bit) using Microsoft Visual Studio to transfer from Oracle to Postgres 16
> 2. Installed Oracle Instant Client 64-bit versionand InstantClient Path has been set in the environment variables
> 3. Have Postgres 16 64-bit version installed
> 4. Placed all the files from each folder of the downloaded ORACLE_FDW package should
> be copied into the respective folders of PostgreSQL Installation directory
> 5. “oci.dll” from the Oracle Instant Client Installation directory to PostgreSQL Installation directory
> 6. Visual C++ redistributable is installed
>
> After the above steps when we try to execute the below statement in Postgres 16
>
> CREATE EXTENSION IF NOT EXISTS oracle_fdw
> SCHEMA public
> VERSION "1.2"
>
> we get the error "SQL Error [58P01]: ERROR: could not load library "C:/Program Files/PostgreSQL/16/lib/oracle_fdw.dll": The specified module could not be found.
> Error position"
>
> But we are able to execute the above command successfully in Postgres 13 and successfully transfer data from Oracle to Postgres 13.
>
> Any help or direction would be greatly helpful.
This is better tracked here: https://github.com/laurenz/oracle_fdw/issues/754
By the way, I took a double take when I read your report.
For me "developing" a FDW means writing the code, whereas you are clearly
talking about what I would call "building", "compiling" or "instaling"
the FDW. No problem, I just want to avoid confusion.
Yours,
Laurenz Albe
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Foreign Data Wrapper from Oracle to Postgres 16
2025-07-02 18:28 Foreign Data Wrapper from Oracle to Postgres 16 Santhosh S <[email protected]>
2025-07-03 06:50 ` Re: Foreign Data Wrapper from Oracle to Postgres 16 Laurenz Albe <[email protected]>
@ 2025-07-04 13:44 ` DINESH NAIR <[email protected]>
0 siblings, 0 replies; 3+ messages in thread
From: DINESH NAIR @ 2025-07-04 13:44 UTC (permalink / raw)
To: Laurenz Albe <[email protected]>; Santhosh S <[email protected]>; [email protected] <[email protected]>; pgsql-novice
Hi,
We found a link that may help resolve the issue you encountered while creating the oracle_fdw extension on windows machine.
laurenz/oracle_fdw: PostgreSQL Foreign Data Wrapper for Oracle<https://github.com/laurenz/oracle_fdw?tab=readme-ov-file#6-installation;
[https://opengraph.githubassets.com/5ddf3cfa010c4132953bb148ce5b719f099b54771a4898555db8946528da016a/...]<https://github.com/laurenz/oracle_fdw?tab=readme-ov-file#6-installation;
GitHub - laurenz/oracle_fdw: PostgreSQL Foreign Data Wrapper for Oracle<https://github.com/laurenz/oracle_fdw?tab=readme-ov-file#6-installation;
PostgreSQL Foreign Data Wrapper for Oracle. Contribute to laurenz/oracle_fdw development by creating an account on GitHub.
github.com
Thanks
Dinesh Nair
________________________________
From: Laurenz Albe <[email protected]>
Sent: Thursday, July 3, 2025 12:20 PM
To: Santhosh S <[email protected]>; [email protected] <[email protected]>; [email protected] <[email protected]>
Subject: Re: Foreign Data Wrapper from Oracle to Postgres 16
Caution: This email was sent from an external source. Please verify the sender’s identity before clicking links or opening attachments.
On Wed, 2025-07-02 at 23:58 +0530, Santhosh S wrote:
> I am working on a project along with my peers on developing an Foreign Data Wrapper
> to transfer data from Oracle to Postgres 16. We followed the below steps in order:
>
> 1. Developed the Foreign Data Wrapper (64-bit) using Microsoft Visual Studio to transfer from Oracle to Postgres 16
> 2. Installed Oracle Instant Client 64-bit versionand InstantClient Path has been set in the environment variables
> 3. Have Postgres 16 64-bit version installed
> 4. Placed all the files from each folder of the downloaded ORACLE_FDW package should
> be copied into the respective folders of PostgreSQL Installation directory
> 5. “oci.dll” from the Oracle Instant Client Installation directory to PostgreSQL Installation directory
> 6. Visual C++ redistributable is installed
>
> After the above steps when we try to execute the below statement in Postgres 16
>
> CREATE EXTENSION IF NOT EXISTS oracle_fdw
> SCHEMA public
> VERSION "1.2"
>
> we get the error "SQL Error [58P01]: ERROR: could not load library "C:/Program Files/PostgreSQL/16/lib/oracle_fdw.dll": The specified module could not be found.
> Error position"
>
> But we are able to execute the above command successfully in Postgres 13 and successfully transfer data from Oracle to Postgres 13.
>
> Any help or direction would be greatly helpful.
This is better tracked here: https://ind01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Flaurenz%2Foracle_fdw%...;
By the way, I took a double take when I read your report.
For me "developing" a FDW means writing the code, whereas you are clearly
talking about what I would call "building", "compiling" or "instaling"
the FDW. No problem, I just want to avoid confusion.
Yours,
Laurenz Albe
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2025-07-04 13:44 UTC | newest]
Thread overview: 3+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-07-02 18:28 Foreign Data Wrapper from Oracle to Postgres 16 Santhosh S <[email protected]>
2025-07-03 06:50 ` Laurenz Albe <[email protected]>
2025-07-04 13:44 ` DINESH NAIR <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox