Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Install PostGIS-2.1.8

2025-01-18 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

Version:

Proj-4.8.0.tar.gz

Geos-3.4.2.tar.bz2

Gdal-2.0.1.tar.gz

PostGIS-2.1.82.1.8

Prerequisites:

Proj,geos,gdal. PostGIS must be installed before installing proj,geos,gdal.

Install proj4

[root@Darren2 tools] # wget http://download.osgeo.org/proj/proj-4.8.0.tar.gz

[root@Darren2 tools] # tar xf proj-4.8.0.tar.gz

[root@Darren2 tools] # cd proj-4.8.0

[root@Darren2 proj-4.8.0] #. / configure-prefix=/usr/local/pgsql/plugin/proj

[root@Darren2 proj-4.8.0] # make & & make install

Waiting for about 1min

# configure and load dynamic link libraries:

[root@Darren2 proj-4.8.0] # vim / etc/ld.so.conf.d/proj-4.8.0.conf

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

[root@Darren2 proj-4.8.0] # ldconfig

Install geos

[root@Darren2 tools] # wget http://download.osgeo.org/geos/geos-3.4.2.tar.bz2

[root@Darren2 tools] # bzip2-d geos-3.4.2.tar.bz2

[root@Darren2 tools] # tar xf geos-3.4.2.tar

[root@Darren2 geos-3.4.2] #. / configure-prefix=/usr/local/pgsql/plugin/geos

.

Swig: false

Python bindings: false

Ruby bindings: false

PHP bindings: false

# these are negligible

[root@Darren2 geos-3.4.2] # make & & make install

Waiting for about 5min

# configure and load dynamic link libraries:

[root@Darren2 geos-3.4.2] # vim / etc/ld.so.conf.d/geos-3.4.2.conf

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

[root@Darren2 geos-3.4.2] # ldconfig

Install gdal

[root@Darren2 tools] # wget http://download.osgeo.org/gdal/2.0.1/gdal-2.0.1.tar.gz

[root@Darren2 tools] # tar xf gdal-2.0.1.tar.gz

[root@Darren2 tools] # cd gdal-2.0.1

[root@Darren2 gdal-2.0.1] #. / configure-prefix=/usr/local/pgsql/plugin/gdal

[root@Darren2 gdal-2.0.1] # make & & make install

Waiting for about 15min

# configure and load dynamic link libraries:

[root@Darren2 gdal-2.0.1] # vim / etc/ld.so.conf.d/gdal-2.0.1.conf

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

[root@Darren2 gdal-2.0.1] # ldconfig

Install PostGIS

[root@Darren2 tools] # wget http://download.osgeo.org/postgis/source/postgis-2.1.8.tar.gz

[root@Darren2 tools] # tar xf postgis-2.1.8.tar.gz

. / configure-- help parameter:

-- prefix=PREFIX install architecture-independent files in PREFIX [/ usr/local]

-- with-pgconfig=FILE specify an alternative pg_config file

-- with-geosconfig=FILE specify an alternative geos-config file

-- with-projdir=PATH specify the PROJ.4 installation directory

-- without-raster Disable the raster extension

[root@Darren2 postgis-2.1.8] #. / configure-- 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

.

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

-Compiler Info-

C compiler: gcc-g-O2

C++ compiler: Gmail +-g-O2

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

-Dependencies-

GEOS config: / opt/geos-3.4.2/bin/geos-config

GEOS version: 3.4.2

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

GDAL version: 2.0.1

PostgreSQL config: / usr/local/pgsql/bin/pg_config

PostgreSQL version: PostgreSQL 9.6.3

PROJ4 version: 48

Libxml2 config: / usr/bin/xml2-config

Libxml2 version: 2.7.6

JSON-C support: no

PostGIS debug level: 0

Perl: / usr/bin/perl

-Extensions-

PostGIS Raster: enabled

PostGIS Topology: enabled

SFCGAL support: disabled

-Documentation Generation-

Xsltproc:

Xsl style sheets:

Dblatex:

Convert:

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

# compiling

[root@Darren2 postgis-2.1.8] # make

.

PostGIS was built successfully. Ready to install.

[root@Darren2 postgis-2.1.8] # make install

.

Make [2]: Leaving directory `/ home/tools/postgis-2.1.8/extensions/postgis_topology'

Make [1]: Leaving directory `/ home/tools/postgis-2.1.8/extensions'

Wait for about 1min

Check whether PostGIS is installed successfully

Darren2:postgres:/usr/local/pgsql: > psql

Postgres=# select * from pg_available_extensions where name like 'postgis%'

Name | default_version | installed_version | comment

-+-

Postgis | 2.1.8 | | PostGIS geometry, geography, and raster spatial types and functions

Postgis_tiger_geocoder | 2.1.8 | | PostGIS tiger geocoder and reverse geocoder

Postgis_topology | 2.1.8 | | PostGIS topology spatial types and functions

Postgres=# create extension postgis

Postgres=# create extension postgis_topology

Postgres=# create extension fuzzystrmatch

Postgres=# create extension postgis_tiger_geocoder

Postgres=#\ dx

List of installed extensions

Name | Version | Schema | Description

-+-

Fuzzystrmatch | 1.1 | public | determine similarities and distance between strings

Plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language

Postgis | 2.1.8 | public | PostGIS geometry, geography, and raster spatial types and functions

Postgis_tiger_geocoder | 2.1.8 | tiger | PostGIS tiger geocoder and reverse geocoder

Postgis_topology | 2.1.8 | topology | PostGIS topology spatial types and functions

Error

(1)

[root@Darren2 postgis-2.1.8] # / configure-- with-pgconfig=/usr/local/pgsql/bin/pg_config-- with-geosconfig=/opt/geos-3.4.2/bin/geos-config-- with-projdir=/opt/proj-4.8.0/-- without-sfcgal

.

Checking for xml2-config... No

Configure: error: could not find xml2-config from libxml2 within the current path. You may need to try re-running configure with a-- with-xml2config parameter.

Solution:

Check to see if the xml2-config file exists, but the result does not exist.

[root@Darren2 postgis-2.1.8] # find /-name "xml2-config"

Check to see if libxml2 and libxml2-devel are installed

[root@Darren2 postgis-2.1.8] # rpm-qa | grep libxml2

Libxml2-2.7.6-14.el6.x86_64

Libxml2-python-2.7.6-14.el6.x86_64

Install libxml2-devel:

[root@Darren2 postgis-2.1.8] # yum install libxml2-devel-y

[root@Darren2 postgis-2.1.8] # rpm-qa | grep libxml2

Libxml2-2.7.6-21.el6_8.1.x86_64

Libxml2-python-2.7.6-21.el6_8.1.x86_64

Libxml2-devel-2.7.6-21.el6_8.1.x86_64

You can see that there is already a xml2-config file at this time

[root@Darren2 postgis-2.1.8] # find /-name "xml2-config"

/ usr/bin/xml2-config

Finally, the above compilation command can be executed successfully.

(2) error in creating extension Times

Postgres=# create extension postgis

ERROR: could not load library "/ usr/local/pgsql/lib/rtpostgis-2.1.so": libgdal.so.20: cannot open shared object file: No such file or directory

[root@Darren2 postgis-2.1.8] # ls-ltr / usr/local/pgsql/lib/rtpostgis-2.1.so

-rwxr-xr-x. 1 root root 1435637 Jul 12 05:44 / usr/local/pgsql/lib/rtpostgis-2.1.so

[root@Darren2 postgis-2.1.8] # ls-ltr / usr/local/pgsql/lib/libgdal.so.20

Ls: cannot access / usr/local/pgsql/lib/libgdal.so.20: No such file or directory

[root@Darren2 postgis-2.1.8] # find /-name 'libgdal.so.20'

/ usr/local/lib/libgdal.so.20

/ home/tools/gdal-2.0.1/.libs/libgdal.so.20

[root@Darren2 postgis-2.1.8] # cp / usr/local/lib/libgdal.so.20 / usr/local/pgsql/lib/

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report