We discussed this extension at our last meeting. @tbussmann mentioned that the windows version of PostGIS includes this extension, so it might be a good idea to bundle it as well.

It looks like the extension is pretty simple to build because Postgres.app already comes with GDAL.

The process is the same as building most extensions:

1. Install command line tools on your Mac using this command:

   xcode-select --install
   

2. Make sure pg_config is on your $PATH:

   which pg_config
   

   Expected output: `/Applications/Postgres.app/Contents/Versions/latest/bin/pg_config

3. download the extension

   git clone git@github.com:pramsey/pgsql-ogr-fdw.git
   

4. build and install the extension:

   cd pgsql-ogr-fdw
   make
   make install
   

5. Restart PostgreSQL server and you should be able to install it with CREATE EXTENSION ogr_fdw;