建议网站的方案,电商外贸有什么平台,做填写信息的超链接用什么网站,我想做个旅游网站怎么做前一段时间记录了下如何在centos7中离线安装postgresql#xff0c;因为工作需要#xff0c;我不仅要安装postgresql#xff0c;还需要安装postgis插件#xff0c;这篇文章记录下postgis插件的安装过程。
1. 安装前的参考 如下的链接都是官网上的链接#xff0c;对你安装p… 前一段时间记录了下如何在centos7中离线安装postgresql因为工作需要我不仅要安装postgresql还需要安装postgis插件这篇文章记录下postgis插件的安装过程。
1. 安装前的参考 如下的链接都是官网上的链接对你安装postgis 应该会有很大的帮助安装前可以先仔细看看
https://trac.osgeo.org/postgis/wiki/UsersWikiPostgreSQLPostGIS 最新版依赖及下载地址 https://trac.osgeo.org/postgis/wiki/PostGISObsoleteVersionsMatrix 版本依赖说明 https://trac.osgeo.org/postgis/wiki/UsersWikiInstall 安装指引 https://trac.osgeo.org/postgis/wiki
2. 我安装的版本 由于工作需要我安装的版本与我们线上保持一致pg安装的是11.11postgis安装的是2.5其它详细信息如下
软件依赖版本postgresql11.11postgis2.5 godal2.2.3 proj4.8.0 geos3.5.1 json-c0.10 protobuf2.6.1 protobuf-c1.2.1 LibXML22.7.7
3.安装依赖 安装postgis共分成两步第一步是安装依赖第二步是安装postgis本身因为postgis需要的依赖比较多一个一个安装需要有点儿耐心。 注意如下目录需要修改成你自己使用的目录
3.1 安装gdal
tar -zxvf gdal-2.2.3.tar.gz
cd gdal-2.2.3
./configure --prefix/app/address/postgre/postgis_dep/gdal
make
make install3.2 安装proj
tar -zxvf proj-4.8.0.tar.gz
cd proj-4.8.0
./configure --prefix/app/address/postgre/postgis_dep/proj
make
make install3.3 安装geos
tar -jxvf geos-3.5.1.tar.bz2
cd geos-3.5.1
./configure --prefix/app/address/postgre/postgis_dep/geos
make
make install3.4 安装 json-c
tar -zxvf json-c-0.10.tar.gz
cd json-c-0.10
./configure --prefix/app/address/postgre/postgis_dep/json-c
make
make install3.5 安装protobuf
tar -zxvf protobuf-2.6.1.tar.gz
cd protobuf-2.6.1
./configure --prefix/app/address/postgre/postgis_dep/protobuf
make
make install3.6 安装 protobuf-c
tar -zxvf protobuf-c-1.2.1.tar.gz
cd protobuf-c-1.2.1
./configure --prefix/app/address/postgre/postgis_dep/protobuf-c
make
make install3.7 安装LibXML2
下载地址 http://xmlsoft.org/sources/
tar -zxvf libxml2-2.7.7.tar.gz
cd libxml2-2.7.7
./configure --prefix/app/address/postgre/postgis_dep/libxml2
make
make install3.8 编辑 ld.so.conf
增加如下配置
/app/address/postgre/postgis_dep/geos/lib
/app/address/postgre/postgis_dep/gdal/lib
/app/address/postgre/postgis_dep/proj/lib
/app/address/postgre/postgis_dep/json-c/lib
/app/address/postgre/postgis_dep/protobuf/lib
/app/address/postgre/postgis_dep/protobuf-c/lib
/app/address/postgre/postgis_dep/libxml2/lib执行sudo ldconfig 使生效3.9 修改环境配置文件
修改 vi ~/.bashrc 增加如下配置
export PKG_CONFIG_PATH/app/address/postgre/postgis_dep/protobuf/lib/pkgconfigexport LD_LIBRARY_PATH$LD_LIBRARY_PATH:/app/address/postgre/postgis_dep/geos/lib:/app/address/postgre/postgis_dep/gdal/lib:/app/address/postgre/postgis_dep/proj/lib:/app/address/postgre/postgis_dep/json-c/lib:/app/address/postgre/postgis_dep/protobuf/lib:/app/address/postgre/postgis_dep/protobuf-c/lib:/app/address/postgre/postgis_dep/libxml2/libsource ~/.bashrc 使生效
4. 安装postgis
4.1 安装postgis
tar -zxvf postgis-2.5.0.tar.gz
cd postgis-2.5.0
./configure --with-geosconfig/app/address/postgre/postgis_dep/geos/bin/geos-config --with-projdir/app/address/postgre/postgis_dep/proj --with-gdalconfig/app/address/postgre/postgis_dep/gdal/bin/gdal-config --with-jsondir/app/address/postgre/postgis_dep/json-c --with-pgconfig/app/address/postgre/pginstall/bin//pg_config --with-xml2config/app/address/postgre/postgis_dep/libxml2/bin/xml2-config
make
make install4.2 登录数据库创建扩展
psql postgres
创建扩展
create extension postgis;
create extension postgis_topology;4.3 测试
select postgis_full_version(); SELECT ST_SetSRID(ST_Point(-87.71,43.741),4326),ST_GeomFromText(‘POINT(-87.71 43.741)’,4326);
5. 错误解决 fatal error: json_object_iterator.h: No such file or director 解决yum install json-c-devel error: #pragma GCC diagnostic not allowed inside functions 使用高版本gcc4.4.7不行我用的是4.8版本
6. 参考 postgis相关下载 postgis下载 https://postgis.net/2019/03/PostGIS-2.5.2-2.4.7-2.3.9-Released/geos下载 https://libgeos.org/usage/download/libxml2 下载 http://xmlsoft.org/sources/ postgis安装参考 https://blog.csdn.net/dbdeep/article/details/123643043 postgis 安装https://blog.csdn.net/weixin_47308871/article/details/122152508https://blog.csdn.net/dbdeep/article/details/123643043 当然在安装postgis之前需要安装postgresql如果你还没有安装可以参考我另一篇记录: centos7 离线安装postgresql
