As stated in last article, I've packaged FDW binaries for PostgreSQL 9.4 windows 32-bit and 64-bit and added in the ogr_fdw one. These we've tested with the standard EDB VS built PostgreSQL windows installs and work fine with those.
FDW binaries for PostgreSQL 9.4
Below are the zip files that contain the binaries and dependency files for our favorite FDWs (that aren't normally available for windows):
If you are using Chrome, Chrome is currently flagging the zip files on this site as possible malware with comment Not commonly Downloaded Warning. If you get such a notice click the drop down option it provides and choose Keep. Alternatively try the 7z versions, which you can extract with 7-zip. These for some reason aren't being flagged.
UPDATE: these have been recompiled with GDAL 2.0 branch (2.0.1) to fix some issues with excel driver, also been recompiled with latest ogr_fdw source to fix some issues like datetime handling. However we took out curl support and added sqlite3 support (so drivers now support SQLite formats like GPKG, but no longer support web formats like Google Fusion/CartoDb). If you need the curl support
and are happy with not having latest ogr fdw/gdal fixes use the old file now renamed - fdw_win32_94_bin_gdal1.11.7z, fdw_win64_94_bin_gdal1.11.7z
file_textarray_fdw - this one is still our favorite because it has no extra depenendencies and handles delimited files (even large ones very fast) and can handle delimited data with varying columns in each row. We've turned a few of our clients that have to deal with third-party flat files onto this one. This is one of those that I really feel should be part of the core PostgreSQL distribution because it's more useful than the packaged file_fdw and fairly trivial to compile.
ogr fdw - A monster of an FDW which has already won my heart. Have some weird data source/file you've never heard of before (especially spatial)? There's a good chance OGR FDW can query it. Note this GDAL build has more drivers than what gets packaged with the PostGIS version. I have also included ODBC, so full set of drivers supported is (read-only since this fdw only supports read at the moment):
Hello, i have a small problem with www_fdw from this package. When i try to create extension, there is a Error message that postgresql cannot load the library www_fdw.dll with error :
ERROR: could not load library "C:/AtlantisIS/deploy/apps/Postgresql 9.4/lib/www_fdw.dll": unknown error 126
My system is Windows 8.1 64bit with binary instalation postgresql 9.4.
I copied all from lib/bin/share to adequate dirs in postgres instalation.
I didn't. However I did do some quick experiments using the curl on the curl download sites (the VC++ compiled ones) and those seemed to work -- though I got a note about getting an ssl cert or something which I didn't investigate so didn't get as far as connecting to an https site. I think I had put in notes in the readme about how to replace the curl I packaged with a curl that has ssl support. Basically just use those (along with the extra ssl.. dlls) and copy the name as libcurl-4.dll (what I have packged). Main reason I'm not including curl with ssl is because with all the ssl this and that going on, I didn't want to distribute something that might change a lot that you can get from other sources or that would be upgraded via EDB other items.