irpas技术客

pg-postgis扩展_huangsu_123_postgis拓展

网络投稿 7261

安装顺序:1.?proj4,,2 geos,3 libxml2,4 gdal安裝,5安装json-c,6 安裝PostGIS

https://proj.org/download.html#

http://download.osgeo.org/geos/

http://xmlsoft.org/sources/old/

https://trac.osgeo.org/gdal/wiki/DownloadSource

https://s3.amazonaws.com/json-c_releases/releases/json-c-0.12.1.tar.gz

http://download.osgeo.org/postgis/source/

1.?创建postgisdata存放postgis插件所需安装包:

mkdir postgisdata

chown -R postgres:postgres /pgsoft/postgisdata/

?

2.解压proj-4.9.2.tar.gz安装包--->进入解压后目录--->配置安装路径--->编译和安装:

tar -xvf /pgsoft/postgisdata/proj-4.9.2.tar.gz

cd /pgsoft/postgisdata/proj-4.9.2

./configure --prefix=/usr/local/proj

make

make install

3.解压geos-3.9.1.tar.bz2安装包--->进入解压后目录--->配置安装路径--->编译和安装:

yum install bzip2

tar -xvf /pgsoft/postgisdata/geos-3.9.1.tar.bz2

cd /pgsoft/postgisdata/geos-3.9.1

yum install gcc gcc-c++

./configure --prefix=/usr/local/geos

make

make install

4.解压libxml2-2.7.1.tar.gz安装包--->进入解压后目录--->配置安装路径--->编译和安装:

tar -xvf /pgsoft/postgisdata/libxml2-2.7.1.tar.gz

cd /pgsoft/postgisdata/libxml2-2.7.1

./configure --prefix=/usr/local/libxml

make

make install

5.解压gdal-1.10.0.tar.gz安装包--->进入解压后目录--->配置安装路径--->编译和安装:

tar -xvf /pgsoft/postgisdata/gdal-1.10.0.tar.gz

cd /pgsoft/postgisdata/gdal-1.10.0

./configure --prefix=/usr/local/gdal

make

make install

6.解压json-c-0.12.1.tar.gz安装包--->进入解压后目录--->配置安装路径--->编译和安装:

tar -xvf /pgsoft/postgisdata/json-c-0.12.1.tar.gz

cd /pgsoft/postgisdata/json-c-0.12.1

./configure --prefix=/usr/local/json

make

?

yum install automake

make clean

make install

7.解压postgis-3.1.0.tar.gz安装包--->进入解压后目录--->配置安装路径--->编译和安装:

tar -xvf /pgsoft/postgisdata/postgis-3.1.0.tar.gz

cd /pgsoft/postgisdata/postgis-3.1.0

./configure --with-pgconfig=/pgsoft/pgsql/bin/pg_config ?--without-protobuf --with-gdalconfig=/usr/local/gdal/bin/gdal-config --prefix=/usr/local/postgis --with-geosconfig=/usr/local/geos/bin/geos-config --with-projdir=/usr/local/proj/

?

上传libxml依赖包或yum install libxml2 和yum install libxml2-devel :

rpm -ivh /pgsoft/postgisdata/libxml-rpm/*

make

make install

8.配置路径,添加内容:

vi /etc/ld.so.conf

/usr/local/gdal/lib/

/usr/local/proj/lib/

/usr/local/geos/lib/

/pgsoft/pgsql/lib/

/usr/local/lib/

9.执行:

ldconfig

10.安装postgis插件:

su postgres

/pgsoft/pgsql/bin/psql

select * from pg_available_extensions where name like 'postgis%';

create extension postgis;

出现以下内容表示安装成功:

?


1.本站遵循行业规范,任何转载的稿件都会明确标注作者和来源;2.本站的原创文章,会注明原创字样,如未注明都非原创,如有侵权请联系删除!;3.作者投稿可能会经我们编辑修改或补充;4.本站不提供任何储存功能只提供收集或者投稿人的网盘链接。

标签: #postgis拓展 #安装顺序1proj4 #2 #geos #3 #libxml2 #4