Linux Platform PostGIS Installation

Source: Internet
Author: User
Tags bz2 mongodb support postgis postgresql version

1. Prerequisites:

PostgreSQL 9.6.1 has been installed through source mode and can be run successfully.

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 ' 1118.www.qixoo.qixoo.com/home/soft/geos-3.6.0/tests/thread '

MAKE[3]: Nothing to is done for ' all '.

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

MAKE[3]: Entering directory ' qkxue.net/home/soft/geos-3.6.0/tests '

MAKE[3]: Nothing to is 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 is 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 is 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[2]: Entering directory '/home/soft/geos-3.6.0/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 is done for ' install-data-am '.

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

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

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

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

MAKE[3]: Nothing to is done for ' install-exec-am '.

MAKE[3]: Nothing to is done for ' install-data-am '.

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

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

MAKE[1]: 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

......

......

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 is 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 is done for ' all-am '.

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

#

# make Install

......

......

MAKE[2]: Nothing to is 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 '

MAKE[1]: 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

#./configure

......

......

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

Bit Jpeg:yes

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

# make

......

......

. 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 Install

......

......

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

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

# tar ZXVF postgis-2.3.0.tar.gz

# CD postgis-2.3.0

#./configure

......

......

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

# make

......

......

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

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--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

Mkdir-p 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

Mkdir-p 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

Mkdir-p 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

Mkdir-p 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 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/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/'

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

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

#

7. Create an extension

1). Enter database query PostGIS available extensions

postgres=# SELECT name, default_version,installed_version from Pg_available_extensions WHERE name is 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). Add Postgres user 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

Export Path=/opt/pgsql/9.6.1/bin: $PATH

Export Manpath=/opt/pgsql/9.6.1/share/man: $MANPATH

$

3). Reboot system

Create an extension

postgres=# CREATE DATABASE realstate;

postgres=# \c realstate;

Connected to Database "Realstate" as User "Postgres".

realstate=# Create extension PostGIS;

CREATE EXTENSION

8. Verify the extension

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=#

Linux Platform PostGIS Installation

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.