MAC安装postgresql和postgis

若疆赤云online

于 2024-07-25 21:50:54 发布

阅读量146

点赞数 3

文章标签： macos postgresql 数据库

本文链接：https://blog.csdn.net/now19930616/article/details/140700877

版权

# 版本基于 postgresql@14 和 postgis 3.4.2_2

brew install postgresql@14
brew install postgis

sudo cp -rf /usr/local/Cellar/postgis/3.4.2_2/share/postgresql@14/extension/postgis.control /usr/local/share/postgresql@14/extension
sudo cp -rf /usr/local/Cellar/postgis/3.4.2_2/share/postgresql@14/extension/postgis--3.4.2.sql /usr/local/share/postgresql@14/extension/

sudo cp -rf /usr/local/Cellar/postgis/3.4.2_2/lib/postgresql@14/address_standardizer-3.so /usr/local/Cellar/postgis/3.4.2_2/lib
sudo cp -rf /usr/local/Cellar/postgis/3.4.2_2/lib/postgresql@14/postgis-3.so /usr/local/Cellar/postgis/3.4.2_2/lib
sudo cp -rf /usr/local/Cellar/postgis/3.4.2_2/lib/postgresql@14/postgis_raster-3.so /usr/local/Cellar/postgis/3.4.2_2/lib
sudo cp -rf /usr/local/Cellar/postgis/3.4.2_2/lib/postgresql@14/postgis_sfcgal-3.so /usr/local/Cellar/postgis/3.4.2_2/lib
sudo cp -rf /usr/local/Cellar/postgis/3.4.2_2/lib/postgresql@14/postgis_topology-3.so /usr/local/Cellar/postgis/3.4.2_2/lib


brew services start postgresql@14

psql -d postgres

create extension postgis;

SELECT PostGIS_Version();