Configuring BigSQL Windows installation for oracle_fdw

OpenSCG's PostgreSQL binaries for Windows (called “BigSQL”) come with a batch-script that configures the environment for the PostgreSQL server.

For PostgreSQL 9.6, this file is in a location like F:\PostgreSQL\pg96\pg96-env.bat and looks similar to this:

@echo off
set PGHOME=F:\PostgreSQL\pg96
set PGDATA=G:\PostgreSQL\data\pg96
set PATH=F:\PostgreSQL\pg96\bin;%PATH%
set PGUSER=postgres
set PGDATABASE=postgres
set PGPORT=5432
set PGPASSFILE=C:\Users\cjohnson\AppData\Roaming\postgresql\pgpass.conf
set PYTHONPATH=F:\PostgreSQL\pg96\python\site-packages

As a consequence, PostgreSQL will not pick up any changes you make to the PATH environment variable in the operating system.

So to use oracle_fdw, you'll have to edit that file and add the directory where oci.dll resides to the PATH in that batch file.

Then restart PostgreSQL, and it should be able to access the Oracle client shared library, so that you can use oracle_fdw.