Linux 平台PostGIS安装

1.前提条件：

postgresql 9.6.1 已经通过源码方式安装完成并可成功运行。

2. other OS packets

OS: CentOS 6.4 X64

X64: libxml2-devel

3.geos-3.6.0

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

# tar xjvf geos-3.6.0.tar.bz2 

./configure

......

config.status: executing libtool commands

Swig: false

Python bindings: false

Ruby bindings: false

# make

make[3]: Leaving directory `/home/soft/geos-3.6.0/tests/geostest'

Making all in thread

make[3]: Entering directory `/home/soft/geos-3.6.0/tests/thread'

make[3]: Nothing to be done for `all'.

make[3]: Leaving directory `/home/soft/geos-3.6.0/tests/thread'

make[3]: Entering directory `/home/soft/geos-3.6.0/tests'

make[3]: Nothing to be done for `all-am'.

make[3]: Leaving directory `/home/soft/geos-3.6.0/tests'

make[2]: Leaving directory `/home/soft/geos-3.6.0/tests'

Making all in tools

make[2]: Entering directory `/home/soft/geos-3.6.0/tools'

make[2]: Nothing to be done for `all'.

make[2]: Leaving directory `/home/soft/geos-3.6.0/tools'

make[2]: Entering directory `/home/soft/geos-3.6.0'

make[2]: Nothing to be done for `all-am'.

make[2]: Leaving directory `/home/soft/geos-3.6.0'

make[1]: Leaving directory `/home/soft/geos-3.6.0'

# make install

Making install in tools

make[3]: Entering directory `/home/soft/geos-3.6.0/tools'

 /bin/mkdir -p '/usr/local/bin'

 /usr/bin/install -c geos-config '/usr/local/bin'

make[3]: Nothing to be done for `install-data-am'.

make[3]: Leaving directory `/home/soft/geos-3.6.0/tools'

make[3]: Entering directory `/home/soft/geos-3.6.0'

make[3]: Nothing to be done for `install-exec-am'.

make[3]: Leaving directory `/home/soft/geos-3.6.0'

# 

4.proj4

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

# tar zxvf proj-4.9.3.tar.gz

# cd proj-4.9.3

# ./configure

make[2]: Leaving directory `/home/soft/proj-4.9.3/jniwrap'

make[1]: Leaving directory `/home/soft/proj-4.9.3/jniwrap'

Making all in cmake

make[1]: Entering directory `/home/soft/proj-4.9.3/cmake'

make[1]: Nothing to be done for `all'.

make[1]: Leaving directory `/home/soft/proj-4.9.3/cmake'

make[1]: Entering directory `/home/soft/proj-4.9.3'

make[1]: Nothing to be done for `all-am'.

make[1]: Leaving directory `/home/soft/proj-4.9.3'

#

make[2]: Nothing to be done for `install-exec-am'.

 /bin/mkdir -p '/usr/local/lib/pkgconfig'

 /usr/bin/install -c -m 644 proj.pc '/usr/local/lib/pkgconfig'

make[2]: Leaving directory `/home/soft/proj-4.9.3'

5.gdal

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

export LD_LIBRARY_PATH=/opt/pgsql/9.6.1/lib

export PATH=/opt/pgsql/9.6.1/bin:$PATH

export MANPATH=/opt/pgsql/9.6.1/share/man:$MANPATH

GDAL is now configured for x86_64-pc-linux-gnu

  Installation directory:    /usr/local

  C compiler:                gcc -g -O2

  C++ compiler:              g++ -g -O2

  LIBTOOL support:           yes

  LIBZ support:              external

  LIBLZMA support:           no

  cryptopp support:          no

  GRASS support:             no

  CFITSIO support:           no

  PCRaster support:          internal

  LIBPNG support:            internal

  DDS support:               no

  GTA support:               no

  LIBTIFF support:           internal (BigTIFF=yes)

  LIBGEOTIFF support:        internal

  LIBJPEG support:           internal

  12 bit JPEG:               yes

  12 bit JPEG-in-TIFF:       yes

  LIBGIF support:            internal

  OGDI support:              no

  HDF4 support:              no

  HDF5 support:              no

  Kea support:               no

  NetCDF support:            no

  Kakadu support:            no

  JasPer support:            no

  OpenJPEG support:          no

  ECW support:               no

  MrSID support:             no

  MrSID/MG4 Lidar support:   no

  MSG support:               no

  GRIB support:              yes

  EPSILON support:           no

  WebP support:              no

  cURL support (wms/wcs/...):no

  PostgreSQL support:        yes

  MRF support:               yes

  MySQL support:             no

  Ingres support:            no

  Xerces-C support:          no

  NAS support:               no

  Expat support:             no

  libxml2 support:           yes

  Google libkml support:     no

  ODBC support:              no

  PGeo support:              no

  FGDB support:              no

  MDB support:               no

  PCIDSK support:            internal

  OCI support:               no

  GEORASTER support:         no

  SDE support:               no

  Rasdaman support:          no

  DODS support:              no

  SQLite support:            no

  PCRE support:              yes

  SpatiaLite support:        no

  DWGdirect support          no

  INFORMIX DataBlade support:no

  GEOS support:              yes

  QHull support:             internal

  Poppler support:           no

  Podofo support:            no

  PDFium support:            no

  OpenCL support:            no

  Armadillo support:         no

  FreeXL support:            no

  SOSI support:              no

  MongoDB support:           no

  SWIG Bindings:             no

  Statically link PROJ.4:    no

  enable GNM building:       no

  enable pthread support:    yes

  enable POSIX iconv support:yes

  hide internal symbols:     no

.so -lpq -lpthread -lrt -ldl -lpcre -lxml2 -lz  -Wl,-rpath -Wl,/usr/local/lib

make[1]: Leaving directory `/home/soft/gdal-2.1.2/apps'

rm -f gdal.pc

echo 'CONFIG_VERSION='`cat ./VERSION`'' >> gdal.pc

echo 'CONFIG_INST_PREFIX=/usr/local' >> gdal.pc

echo 'CONFIG_INST_LIBS=-L/usr/local/lib -lgdal' >> gdal.pc

echo 'CONFIG_INST_CFLAGS=-I/usr/local/include' >> gdal.pc

echo 'CONFIG_INST_DATA=/usr/local/share/gdal/data' >> gdal.pc

cat gdal.pc.in >> gdal.pc

make[1]: Leaving directory `/home/soft/gdal-2.1.2/scripts'

for f in LICENSE.TXT data/*.* ; do /home/soft/gdal-2.1.2/install-sh -c -m 0644 $f /usr/local/share/gdal ; done

/bin/sh /home/soft/gdal-2.1.2/libtool --mode=finish --silent /usr/local/lib

/home/soft/gdal-2.1.2/install-sh -d /usr/local/lib/pkgconfig

/home/soft/gdal-2.1.2/install-sh -c -m 0644 gdal.pc /usr/local/lib/pkgconfig/gdal.pc

6.postgis

# tar zxvf postgis-2.3.0.tar.gz 

# cd postgis-2.3.0

config.status: executing po-directories commands

  PostGIS is now configured for x86_64-pc-linux-gnu

 -------------- Compiler Info ------------- 

  C compiler:           gcc -g -O2

  SQL preprocessor:     /usr/bin/cpp -traditional-cpp -w -P

 -------------- Dependencies -------------- 

  GEOS config:          /usr/local/bin/geos-config

  GEOS version:         3.6.0

  GDAL config:          /usr/local/bin/gdal-config

  GDAL version:         2.1.2

  PostgreSQL config:    /opt/pgsql/9.6.1/bin/pg_config

  PostgreSQL version:   PostgreSQL 9.6.1

  PROJ4 version:        49

  Libxml2 config:       /usr/bin/xml2-config

  Libxml2 version:      2.7.6

  JSON-C support:       no

  PCRE support:         yes

  PostGIS debug level:  0

  Perl:                 /usr/bin/perl

 --------------- Extensions --------------- 

  PostGIS Raster:       enabled

  PostGIS Topology:     enabled

  SFCGAL support:       disabled

  Address Standardizer support:       enabled

 -------- Documentation Generation -------- 

  xsltproc:             

  xsl style sheets:     

  dblatex:              

  convert:              

  mathml2.dtd:          http://www.w3.org/Math/DTD/mathml2/mathml2.dtd

mkdir -p sql

cat us_lex.sql us_gaz.sql us_rules.sql sql_bits/address_standardizer_data_us_mark_editable_objects.sql.in > sql/address_standardizer_data_us.sql

cat us_lex.sql us_gaz.sql us_rules.sql sql_bits/address_standardizer_data_us_mark_editable_objects.sql.in > sql/address_standardizer_data_us--2.3.0.sql

cat sql/address_standardizer_data_us--2.3.0.sql > sql/address_standardizer_data_us--2.3.0--2.3.0next.sql

cat sql/address_standardizer_data_us--2.3.0.sql > sql/address_standardizer_data_us--2.3.0next--2.3.0.sql

/usr/bin/cpp -traditional-cpp -w -P -I../libpgcommon test-init-extensions.sql.in | grep -v '^#' | \

        /usr/bin/perl -lpe "s'MODULE_PATHNAME'\$libdir/address_standardizer-2.3'g" > sql/test-init-extensions.sql

/usr/bin/cpp -traditional-cpp -w -P -I../libpgcommon test-parseaddress.sql.in | grep -v '^#' | \

        /usr/bin/perl -lpe "s'MODULE_PATHNAME'\$libdir/address_standardizer-2.3'g" > sql/test-parseaddress.sql

/usr/bin/cpp -traditional-cpp -w -P -I../libpgcommon test-standardize_address_1.sql.in | grep -v '^#' | \

        /usr/bin/perl -lpe "s'MODULE_PATHNAME'\$libdir/address_standardizer-2.3'g" > sql/test-standardize_address_1.sql

/usr/bin/cpp -traditional-cpp -w -P -I../libpgcommon test-standardize_address_2.sql.in | grep -v '^#' | \

        /usr/bin/perl -lpe "s'MODULE_PATHNAME'\$libdir/address_standardizer-2.3'g" > sql/test-standardize_address_2.sql

make[2]: Leaving directory `/home/soft/postgis-2.3.0/extensions/address_standardizer'

make[1]: Leaving directory `/home/soft/postgis-2.3.0/extensions'

PostGIS was built successfully. Ready to install.

...... 

make[2]: Entering directory `/home/soft/postgis-2.3.0/extensions/address_standardizer'

/bin/mkdir -p '/opt/pgsql/9.6.1/lib'

/bin/mkdir -p '/opt/pgsql/9.6.1/share/extension'

/bin/mkdir -p '/opt/pgsql/9.6.1/share/doc/extension'

/usr/bin/install -c -m 755  address_standardizer-2.3.so '/opt/pgsql/9.6.1/lib/address_standardizer-2.3.so'

/usr/bin/install -c -m 644 .//address_standardizer.control '/opt/pgsql/9.6.1/share/extension/'

/usr/bin/install -c -m 644 .//address_standardizer_data_us.control .//sql/address_standardizer.sql .//sql/address_standardizer_data_us.sql .//sql/address_standardizer--1.0--2.3.0.sql .//sql/address_standardizer--2.3.0--2.3.0next.sql .//sql/address_standardizer--2.3.0next--2.3.0.sql .//sql/address_standardizer--2.3.0.sql .//sql/address_standardizer_data_us--2.3.0--2.3.0next.sql .//sql/address_standardizer_data_us--2.3.0next--2.3.0.sql .//sql/address_standardizer_data_us--2.3.0.sql  '/opt/pgsql/9.6.1/share/extension/'

/usr/bin/install -c -m 644 .//README.address_standardizer '/opt/pgsql/9.6.1/share/doc/extension/'

7.创建扩展

1).进入数据库查询postgis可用扩展

postgres=# SELECT name, default_version,installed_version FROM pg_available_extensions WHERE name LIKE 'postgis%' ;

          name          | default_version | installed_version 

------------------------+-----------------+-------------------

 postgis_tiger_geocoder | 2.3.0           | 

 postgis_topology       | 2.3.0           | 

 postgis                | 2.3.0           | 

(3 rows)

postgres=# 

2).添加postgres用户lib PATH

# su - postgres

$ vi .bash_profile 

# .bash_profile

# Get the aliases and functions

if [ -f ~/.bashrc ]; then

        . ~/.bashrc

fi

# User specific environment and startup programs

export LD_LIBRARY_PATH=/usr/local/lib:/opt/pgsql/9.6.1/lib

$ 

3).reboot系统

创建扩展

postgres=# create database realstate;

postgres=# \c realstate ;

You are now connected to database "realstate" as user "postgres".

realstate=# create extension postgis;

CREATE EXTENSION

8.验证扩展

realstate=# \dx

                                     List of installed extensions

  Name   | Version |   Schema   |                             Description                             

---------+---------+------------+---------------------------------------------------------------------

 plpgsql | 1.0     | pg_catalog | PL/pgSQL procedural language

 postgis | 2.3.0   | public     | PostGIS geometry, geography, and raster spatial types and functions

(2 rows)

realstate=#

本文转自 pgmia 51CTO博客，原文链接:http://blog.51cto.com/heyiyi/1873448