search

pramsey / pgsql-ogr-fdw

PostgreSQL foreign data wrapper for OGR
MIT License
237 stars 34 forks source link

OSX binary distribution of ogr_fdw #170

Closed robe2 closed 3 years ago

robe2 commented 5 years ago

I'm not sure how to word this since I don't have a Mac.

But I notice OSGeo bottle carries ogr_fdw in binary form as well:

https://bottle.download.osgeo.org/

osgeo-pgsql-ogr-fdw-1.0.7.high_sierra.bottle.ta..> 228K 2019-Apr-03 02:43
osgeo-pgsql-ogr-fdw-1.0.7.mojave.bottle.tar.gz 228K 2019-Apr-03 02:43
osgeo-pgsql-ogr-fdw-1.0.7.sierra.bottle.tar.gz 228K 2019-Apr-03 02:43
osgeo-pgsql-ogr-fdw-1.0.8.high_sierra.bottle.1...> 229K 2019-May-21 15:36
osgeo-pgsql-ogr-fdw-1.0.8.mojave.bottle.1.tar.gz 229K 2019-May-21 15:36

osgeo-pgsql-ogr-fdw-1.0.8.sierra.bottle.1.tar.gz

It's my understanding people install these via Home Brew and bottle is some sort of binary format if you don't want to run homebrew scripts to build your own.

pramsey commented 5 years ago

Are you suggesting I get into the packaging business?

robe2 commented 5 years ago

No of course not. Just saying if there is a package you should mention it. Of course I can't test cause I don't have a Mac. Mac is the only system I think at this point I can't test.

kristfal commented 4 years ago

To help those on Mac OS who may have issues installing this (feel free to add to readme):

1) Remove all previously installed instances of postgres, postgis, gdal and derived dependencies using brew uninstall postgis gdal and remove the linked dependencies as well 2) brew tap osgeo/osgeo4mac 3) brew install osgeo/osgeo4mac/osgeo-pgsql-ogr-fdw 4) Work around the version issues by within osgeo by:

brew uninstall osgeo-gdal osgeo-proj osgeo-libspatialite osgeo-gdal-python osgeo-ogr-fdw --ignore-dependencies --force
brew install https://raw.githubusercontent.com/OSGeo/homebrew-osgeo4mac/b37f82142e347c293cf0b7992f6187d40116b2ca/Formula/osgeo-proj.rb &&
brew install https://raw.githubusercontent.com/OSGeo/homebrew-osgeo4mac/27f4ac2bc4056750307cee1b7a6abb9e33c846dd/Formula/osgeo-libspatialite.rb &&
brew install https://raw.githubusercontent.com/OSGeo/homebrew-osgeo4mac/de5db18027bc37cd3bb0d4be07f59fdc8fe55df9/Formula/osgeo-gdal-python.rb &&
brew install https://raw.githubusercontent.com/OSGeo/homebrew-osgeo4mac/f6e7b27c7485afbdc5a8d9844231fd2e64f02659/Formula/osgeo-gdal.rb &&
brew install https://raw.githubusercontent.com/OSGeo/homebrew-osgeo4mac/732bc64d7dbe5e2e2381873aa209c2269b7f491d/Formula/osgeo-pgsql-ogr-fdw.rb

Another update:

After this, create extension ogr_fdw will work, but create extension postgis may or may not work. The quickest and dirtiest way to fix this is to simply copy the mismatched .dylibs (ex libproj.13.dylib -> copy and rename in same folder -> libproj.11.dylib). It is not pretty, but it will work.

robe2 commented 3 years ago

@kristfal I think these instructions might need a dedicated page.

@pramsey What diya think - Perhaps a dedicated MacOS page linked off from the main README?

pramsey commented 3 years ago

Ew. Wouldn't fixing the HomeBrew be a better thing to do?

robe2 commented 3 years ago

Ew. Wouldn't fixing the HomeBrew be a better thing to do?

How doable is that? If its doable well of course that is a better solution. I just thought such alternatives were not an option.

salahelfarissi commented 2 weeks ago

Hi I'm looking into how to install on Mac. Is there a solution for how to do that.