在线时间:8:00-16:00
迪恩网络APP
随时随地掌握行业动态
扫描二维码
关注迪恩网络微信公众号
开源软件名称:CloverHealth/homebrew-tap开源软件地址:https://github.com/CloverHealth/homebrew-tap开源编程语言:Ruby 100.0%开源软件介绍:homebrew-tapThis is Clover Health's Homebrew Tap, which features formulas to help pin Postgres to 9.6 and Postgis to 2.5. Homebrew will pull in the latest version of formulas when they are upgraded, meaning that users can inadvertently be upgraded to Postgresql 10. The postgresql.rb formula here ensures that 9.6.10 is installed, and the postgis.rb formulate ensures that 2.5.2 is installed. Installing Postgres 9.6 and Postgis 2.5First ensure you have upgraded to the latest homebrew: brew update It's recommended to go ahead and clear any existing Postgres and Postgis installations: brew uninstall postgis --force
brew uninstall postgresql --force
brew cleanup
brew services stop postgresql After this, install Clover's custom brew tap: brew tap cloverhealth/homebrew-tap Then install the latest version of Postgres and unlink it. This is done first so that we can explicitly switch to an earlier version before installing Postgis: brew install postgresql
brew unlink postgresql The previous install of postgresql runs rm -rf /usr/local/var/postgres Now install Postgres from this tap with: brew install cloverhealth/tap/postgresql # yes, without the homebrew- Now you will have both 9.6.10 and the latest version of Postgres installed. Switch to 9.6.10 with: brew switch postgresql 9.6.10 Postgis 2.5 can be installed with: brew install cloverhealth/tap/postgis Try running and accessing Postgres with the following: brew services start postgresql
psql postgres # It should show 9.6.10 as the version on the prompt After running drop extension postgis; -- This might fail if it wasn't previously installed
create extension postgis; -- This should pass
select ST_Distance(
ST_GeometryFromText('POINT(-118.4079 33.9434)', 4326), -- Los Angeles (LAX)
ST_GeometryFromText('POINT(2.5559 49.0083)', 4326) -- Paris (CDG)
); -- This should print a row with 121.898285970107 as a value |
2023-10-27
2022-08-15
2022-08-17
2022-09-23
2022-08-13
请发表评论