。

但PostGIS2.4的版本已经在yum中找不到了#xff0c;安装只能通过本地编译的方式。

这里介绍一下如何在Centos7的系统上#xff0c;编译部署PostGIS2.4…PostGIS的最新版本已经到3.5但是还有一些国产数据库内核使用的旧版本的PostgreSQL支持PostGIS2.4。

但PostGIS2.4的版本已经在yum中找不到了安装只能通过本地编译的方式。

这里介绍一下如何在Centos7的系统上编译部署PostGIS2.4。

安装Proj4

http://download.osgeo.org/proj/proj-4.9.3.tar.gz

tar

--prefix/usr/local/pgsql/plugin/proj

make

/usr/local/pgsql/plugin/proj/lib

/etc/ld.so.conf.d/proj-4.9.3.conf

ldconfig安装GEOS

http://download.osgeo.org/geos/geos-3.6.2.tar.bz2

tar

--prefix/usr/local/pgsql/plugin/geos

make

/usr/local/pgsql/plugin/geos/lib

/etc/ld.so.conf.d/geos-3.6.2.conf

ldconfig安装libxml2

ftp://xmlsoft.org/libxml2/libxml2-2.7.1.tar.gz

tar

--prefix/usr/local/pgsql/plugin/libxml2

make

/usr/local/pgsql/plugin/geos/lib

/etc/ld.so.conf.d/geos-3.6.1.conf

ldconfig安装GDAL

http://download.osgeo.org/gdal/2.1.2/gdal-2.1.2.tar.gz

tar

--prefix/usr/local/pgsql/plugin/gdal

make

/usr/local/pgsql/plugin/gdal/lib

/etc/ld.so.conf.d/gdal-2.1.2.conf

ldconfig安装JSON-C

https://github.com/json-c/json-c/archive/refs/tags/json-c-0.12.1-20160607.tar.gz

tar

--prefix/usr/local/pgsql/plugin/json

make

http://download.osgeo.org/postgis/source/postgis-2.4.9.tar.gz

tar

--prefix/usr/local/pgsql/plugin/postgis

--with-pgconfig/usr/local/pgsql/bin/pg_config

--with-geosconfig/usr/local/pgsql/plugin/geos/bin/geos-config

--with-gdalconfig/usr/local/pgsql/plugin/gdal/bin/gdal-config

--with-projdir/usr/local/pgsql/plugin/proj

make

ST_AsText(ST_GeomFromGeoJSON({type:Point,coordinates:[-48.23456,20.12345]}))

wkt;