安装PostGIS之前必须先安装proj,geos,gdal.
安装依赖包
[root
@hgdb ~]# yum install -y
python-devel perl-ExtUtils-Embed
python-devel gcc-c++ openssl-devel readline readline-devel zlib zlib-devel openssl openssl-devel pam pam-devel libxml2 libxml2-devel libxslt libxslt-devel openldap openldap-devel libgeos-dev libproj-dev libgdal-dev xsltproc docbook-xsl docbook-xml imagemagick libmagickcore-dev dblatex tcl tcl-devel unixODBC unixODBC-devel libpng12 libpng12-devel
安装proj
[highgo
@hgdb ~]$ cd proj-
4.9.3/
[highgo
@hgdb proj-
4.9.3]$ ./configure --prefix=/data/highgo/
4.3.2/plugin/proj
[highgo
@hgdb proj-
4.9.3]$ make
[highgo
@hgdb proj-
4.9.3]$ make install
配置和加载动态链接库
[root
@hgdb ~]
[root
@hgdb ~]
安装geos
[highgo
@hgdb ~]$ cd geos-
3.6.2/
[highgo
@hgdb geos-
3.6.2]$ ./configure --prefix=/data/highgo/
4.3.2/plugin/geos
[highgo
@hgdb geos-
3.6.2]$ make
[highgo
@hgdb geos-
3.6.2]$ make install
配置和加载动态链接库
[root
@hgdb ~]
[root
@hgdb ~]
安装gdal
[highgo
@hgdb ~]$ unzip gdal224.zip
[highgo
@hgdb gdal-
2.2.4]$ ./configure --prefix=/data/highgo/
4.3.2/plugin/gdal
[highgo
@hgdb gdal-
2.2.4]$ make
[highgo
@hgdb gdal-
2.2.4]$ make install
配置和加载动态链接库
[root
@hgdb ~]
[root
@hgdb ~]
安装postgis
[highgo@hgdb ~]$ tar -zxf postgis-
2.2.7.tar.gz
[highgo@hgdb ~]$ cd postgis-
2.2.7/
[highgo@hgdb postgis-
2.2.7]$ ./configure --prefix=
/data/highgo/
4.3.2/plugin/postgis --
with-pgconfig=
/data/highgo/
4.3.2/bin/pg_config --
with-geosconfig=
/data/highgo/
4.3.2/plugin/geos/bin/geos-config --
with-gdalconfig=
/data/highgo/
4.3.2/plugin/gdal/bin/gdal-config --
with-projdir=
/data/highgo/
4.3.2/plugin/proj
[highgo@hgdb postgis-
2.2.7]$ make
[highgo@hgdb postgis-
2.2.7]$ make install
启动hgdb，导入PostGIS插件
[highgo@hgdb ~]\$ pg_ctl
start -D /data/highgo/4.3.2/data -l /data/highgo/4.3.2/logfile
server starting
[highgo@hgdb ~]\$ psql
psql (4.3.2)
PSQL: Release 4.3.2
Connected to:
HighGo Database V4.3 Enterprise Edition Release 4.3.2 - 64-bit Production
Type "help" for help.
highgo=\# SELECT postgis_full_version();
postgis_full_version
POSTGIS="2.2.7 r16522" GEOS="3.6.2-CAPI-1.10.2 4d2925d6" PROJ="Rel. 4.9.3, 15 August 2016" GDAL="GDAL 2.2.4, rel
eased 2018/03/19" LIBXML="2.9.1" TOPOLOGY RASTER
(1 row)
highgo=#
create extension postgis;
CREATE EXTENSION
highgo=# CREATE EXTENSION postgis_topology;
CREATE EXTENSION
highgo=# CREATE EXTENSION fuzzystrmatch;
CREATE EXTENSION
highgo=# CREATE EXTENSION postgis_tiger_geocoder;
CREATE EXTENSION
highgo=# \dx
List of installed extensions
Name | Version | Schema | Description
------------------------+---------+------------+-----------------------------------------------------------------
----
fuzzystrmatch | 1.0 | public | determine similarities and distance between strings
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
postgis | 2.2.7 | public | PostGIS geometry, geography, and raster spatial types and functi
ons
postgis_tiger_geocoder | 2.2.7 | tiger | PostGIS tiger geocoder and reverse geocoder
postgis_topology | 2.2.7 | topology | PostGIS topology spatial types and functions
(5 rows)
by z
