Installing Oracle Instant Client on OS X

Download client (currently at http://www.oracle.com/technetwork/topics/intel-macsoft-096467.html but you might want to google for Oracle Instant Client Mac instead).

You can download the basic client or the basic lite client. You must also download the SDK.

Unzip the files to the same directory. By default, OS X will unzip the second one you open to a different directory; just make sure that you move the sdk directory from the sdk unzip into the main install client directory.

To build the source, you will need to set ORACLE_HOME to the location of the client library.

To create the extension, you will need to include the location of the client library in DYLD_LIBRARY_PATH when you start Postgres.

Assuming you download the main library first, something like this should work:

cd ~/Downloads mv 'instantclient_11_2 2/sdk' instantclient_11_2 cd /git/oracle_fdw export ORACLE_HOME=/Downloads/instantclient_11_2 make install export DYLD_LIBRARY_PATH=$DYLD_LIBRARY_PATH:$ORACLE_HOME pg_ctl restart

Note that if you're using sudo for any of this, you'll want to include the -E option.

Obviously all of this is an enormous ugly hack...